Question
1
Replies
514
Views
Posted: June 20, 2017
Last activity: June 21, 2017
Closed
Solved
Update Syntax for update external database(oracle) in Connect SQL
Hi all,
Can you tell me syntax for update external DB in connect SQL?
i use below syntax, but it seems error.
{SQLpage:MySQLPage}
UPDATE {.Class:MyClass} SET
PROPERTY="C"
WHERE
NAME="HOTEL"
There shouldn't be a '.' before class.
{SQLpage:MySQLPage}
UPDATE {Class:MyClass} SET
PROPERTY='C'
WHERE
NAME='HOTEL'