|GSAK (Geocaching Swiss Army Knife)|
Iterating throuh a table via SqlGet=Handle, places a "lock" on the table which must be released. When you reach the end of of the table ($_SqlEoln = true) this lock is automatically released. However there may be times when you don't want to iterate throught the whole table and you use the Break command to exit the loop. If you do exit the loop before $_SqlEoln = true, then you must use SqlGetClose to make sure you close the table and release the lock.
Handle - this is the corresponding handle number (0 to 4) used in the Sqlite() function with the option SqlGet=Handle. If the Handle= paramater is omitted then the defualt handle of 0 is used.
As the default handle is 0, the Handle for SqlGetClose,SqlNext,SqlGet and $_SqlEol is not really required. So for brevity, the previous example can also be coded as:
See also Sqlite(), SqlGet(), SqlNext
Alpha List Category List
Copyright 2004-2014 CWE Computer Services |