Reverse a list

Peter Haworth pete at
Sat Feb 14 00:34:21 CET 2015

We both used in memory databases.  The filename is ";memory:"

On Fri Feb 13 2015 at 2:46:45 PM Bob Sneidar <bobsneidar at>

> He may also have been using a memory resident database. That is what I
> suggested at the first. To do this, use “memory” as the file name.
> Bob S
> On Feb 13, 2015, at 12:40 , Mike Kerner <MikeKerner at<mailto:
> MikeKerner at>> wrote:
> I must have missed a thread, somewhere.  That would be the thread on how LC
> handles loops.
> To recap, doing this sort using an sqlite database (insert the values into
> a table, then sort the table), was taking me almost 40 seconds.  Then Pete
> chimed in and had it working in a couple hundred milliseconds.
> The difference?  Pete was using a loop of the form
> repeat for each line tLine in theData
> and I was doing a
> repeat with i = 1 to the number of lines in tData
> So, is there some more in-depth discussion of loop forms in LC, somewhere?
> I learned something new, today, because 300x faster is a little bit
> important.
> _______________________________________________
> use-livecode mailing list
> use-livecode at
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:

More information about the use-livecode mailing list