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 <mikeker...@roadrunner.com<mailto:mikeker...@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 _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
