GSAK (Geocaching Swiss Army Knife) | ||
Contents
- Index
SqlQuote(sData) : string The is mainly to help Sqlite users cope with the apostrophe inside data strings when building sql commands. Sqlite denotes string data by surrounding it in single quotes. If your data has the possibility of having single quotes inside it, you must escape it (replace each single quote with two of them) otherwise you will get a sql syntax error. I would advise using this function when dealing with string data in sqlite. For example, if you wanted to get a list of all caches codes that had been placed by the current cache placer your current sql would need to have been coded something like:
This can now be coded as:
Alpha List Category List |
Copyright 2004-2019 CWE Computer Services Privacy Policy Contact |