boolean=dbExecSQL(sql: string)
The function puts through an SQL command, whose type is INSERT, UPDATE or DELETE. We are not about to explain the principle of INSERT, UPDATE or DELETE commands and SQL language. We advise to read appropriate manuals. If the SQL order has been well accomoplished, the function returns true. If an error occured during the SQL order, the function returns false.

Parameters
The only parameter in this function is the SQL command INSERT, UPDATE or DELETE.

Note
When working with texts in SQL you have to separate using quotation marks, for example WHERE ordNumber='abc'.

Example - Director

global ado
if ado.dbExecSQL("INSERT INTO data (ordNumber, company) VALUES ('dmmMBD27', 'Studio dmm') ") then

end if

if ado.dbExecSQL("UPDATE data SET registration='YU-AKO'  WHERE ordNumber='A001' ") then

end if

if ado.dbExecSQL("DELETE FROM data") then

end if

Example - Authorware

CallObject(ado; "dbExecSQL","UPDATE data SET registration='YU-AKO'  WHERE ordNumber='A001' ")