Reverse a list

[Bob Sneidar]

IOC nvm. Looks like that is how revExecuteSQL works. I can see now why I was befuddled trying to get SQL to work in LC using their built in functions.

Bob S


On Feb 17, 2015, at 12:11 , Mike Kerner <MikeKerner at roadrunner.com<mailto:MikeKerner at roadrunner.com>> wrote:

Peter (Brett),

Help me with the chunking piece, then.

The following is very fast:
put "INSERT INTO sortTest VALUES :1" into tSQL
repeat for each line tLine in tDataSet
  revExecuteSQL dbid, tsql, tline
end repeat

The following is very slow:
put "INSERT INTO sortTest VALUES :1" into tSQL
put the number of lines in tDataSet into numLines
repeat with i = 1 to numLines
  revExecuteSQL dbid, tsql, line i of tDataSet
end repeat