Salesforce

Syntax of DML Commands (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Syntax of DML Commands (Magic xpa 4.x)

The utility uses the existing connection to the data source selected and sends the function SQLExecDirect with a SQL command in the szSqlStr field.

After each command, the log indicates whether the command was successful or not.

Note: The table and index are actually created and dropped from the database that the data source points to.

CREATE TABLE T11025 (FLD1 CHAR(1), FLD2 CHAR(1))

**** Succeeded ****

CREATE UNIQUE INDEX I11025 ON T11025 (FLD1)

**** Succeeded ****

DROP INDEX I11025 ON T11025

**** Succeeded ****

DROP TABLE T11025

**** Succeeded ****

The utility disconnects from the data source using the SQLDisconnect function.

In order to do the same, simply select Connect\Full Disconnect.

******* Disconnected Successfully ... ******

******************************************************

Reference
Attachment 
Attachment