Difference betwen SQLExec and CreateSQL

There are two basic differences:

1st : If you want to delete insert or update a single record use the SQLExec along with corresponding PeopleCode record object method.

If you want to delete insert or update a series of records all of the same type use the CreateSQL or GetSQL functions not the Execute SQL class method.

2nd : SQLExec can only Select a single row of data. If your SQL statement (or your SQL.sqlname statement) retrieves more than one row of data SQLExec sends only the first row to its output variables. Any subsequent rows are discarded. If you need to SELECT multiple rows of data use the CreateSQL or GetSQL functions and the Fetch SQL class method.

You can review more about this document by using the following Google Search

Enter your search terms Submit search form

Related Posts by Categories