repeat & the db funcs
charles.hartman at conncoll.edu
Sun Oct 9 22:42:19 EDT 2005
On Oct 9, 2005, at 9:28 PM, Kay C Lan wrote:
> If the data is small, say less than 100MB, why not just use the
> 'revDataFromQuery' function to load all the data into a variable on
> you can then use the 'repeat for each line tMyLine of
> This would be much quicker than repeated calls to the database.
That does make sense. If it makes me squeamish, that's just OCD . . .
> If the data is large, why not just use 'revCurrentRecordIsLast'
> function in
> a 'repeat until...' control structure:
> repeat until revCurrentRecordIsLast(tMyRecordSetID)
> <insert your transcript code here>
> revMoveToNextRecord tMyRecordSetID
> end repeat
> In this last case though, I think your suggestion would be a nice
I missed the revCurrentRecordIsLast() function. With that, no reason
to mess with the repeat control-structure syntax. Thanks. I thought I
might be overlooking a simple solution.
More information about the Use-livecode