Master table Field UPDATE with value in detail table field

Scriptcase 8 Discussion
#1

/*

  • This macro execute SQL commands passed as parameter or a SQL command in the SQL field action type.
    */
    sc_exec_sql(“UPDATE tumisler s, kabuldurum p
    SET [s.ID] = [p.ID_FK]
    WHERE [s.SonDurum] = [p.Durumu]”, “conn_mysql”)

Error message received:

Parse error: syntax error, unexpected ‘$_SESSION’ (T_VARIABLE) in C:\Program Files (x86)\NetMake\v81\wwwroot\scriptcase\app edas\form_tumisler\form_tumisler_apl.php on line 3681

#2

Why is SET [s.ID] = [p.ID_FK] bewteen curly brackets? Remove it. SC understands it as globals