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"
Accepted Solution
Posted: 3 years ago
There shouldn't be a '.' before class.
{SQLpage:MySQLPage}
UPDATE {Class:MyClass} SET
PROPERTY='C'
WHERE
NAME='HOTEL'