Applies To:
  • CitectSCADA 1.20 2.00 2.01 3.00
Summary:
Question: I have a large SQL command I need to pass to SQLExec() function. But the command is bigger than cicode can handle. How can I process this command? 

Solution:
You may pass long SQL commands by using the SQLSet() and SQLAppend() functions to build up the required strings and then call the SQLExec() function. For example:

SQLSet(hSQL, "SELECT *");
SQLAppend(hSQL, " FROM EMP");
SQLAppend(hSQL, " ORDER BY last_name");
SQLExec(hSQL, "");

For more information see the online help on SQLSet() and SQLAppend().

 
Keywords:
 

Attachments