Welcome Guest. Sign in or Signup

3 Answers

SQLExec vs CreateSQL

Asked by: 9765 views PeopleCode

It’s common to see SQLExec and CreateSQL functions in PeopleCode that interact with the Database. Can you compare between SQLExec and CreateSQL?

Related Questions

3 Answers



  1. pandu on Feb 18, 2012 Reply

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

    +8 Votes Thumb up 0 Votes Thumb down 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 Thumb up 0 Votes Thumb down 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 Thumb up 0 Votes Thumb down 0 Votes


Answer Question