SQLExec vs CreateSQL

3 Answers

1. 
   

   
   

   pandu on Feb 18, 2012 Reply

   SQLEXEC() = It will fetch only one row
   CREATESQL() = Multiple rows fetch in at a time

   +9 Votes 0 Votes  0 Votes

2. Best Answer
   
   

   
   

   reddy on Apr 16, 2012 Reply

   SqlExec ,create Sql :we can update the database through these two function.but suppose if you use sqlexec you can update /delete / select / insert one row at time .
   create Sql you can update / delete / select / insert multipul row s at time .

   +9 Votes 0 Votes  0 Votes

3. 
   

   
   

   sahare on Jul 25, 2012 Reply

   Using SqlExec, you can run a query directly for execution to get a single row of data.
   Using CreateSQL, you have to assign it to a record variable first, so that you will get multiple rows of data. “reddy” has given a correct answer above.

   +4 Votes 0 Votes  0 Votes