Create buttton to change and update one field in the database

Scriptcase 9 General
#1

Hello All,

I need to create a buttton to change and update one field in the database inside a form (instead of delete i need to add a trash field with 1).
I’m a scripcase beginner and also programming.

Thanks for help.

#2

Hi
Create a new button in the form with type PHP
In the code:
$update_sql=“your update sentence”;
sc_exec_sql($update_sql);

That’s all.

#3

Thanks, will try. need to understand how to easy define the “your update sentence”

#4

UPDATE table
SET field1=‘value1’, field2=‘value2’
WHERE fieldx=‘valuex’ AND… (in case the condition has more than one field.

MySQL UPDATE Statement

#5

thanks for help. works