DBGateway_Execute

version 2004

DBGateway_Execute (connID; sqlQuery)

Parameter	Type		Description
connID	Longint		Connection ID returned by DBGateway_Connect
sqlQuery	Text		SQL Query (INSERT..., UPDATE..., CREATE TABLE...)

The DBGateway_Execute command executes a SQL statement that is not supposed to return a data set (inserting records, updating records, deleting records, etc.).

connID is a Longint returned by DBGateway_Connect.

sqlQuery is a Text variable that contains the SQL statement.

   DBGateway_Execute(connID; "INSERT INTO mydata (id, name, amount) VALUES (1275, 'SOFT CIE', 990.99)")
   If(DBGateway_ErrorCode(connID)#0)
      ALERT(DBGateway_ErrorString(connID))
   Else
          `Record inserted
      ...
   End if