Andrew Gatt wrote:
A ha! This seems perfect, one quick question, when you say "id values
are small enough", are we talking about an integer size limit hard
coded into sqlite? I mean with the *10 is the value of id ultimately
limited to 6553? This may cause an issue, however if we are talking 32
bit then that won't be a problem.
Thank you for your help, i'm continually impressed with how much you can do
with an sql statement!
Andrew,
Actually internally sqlite3 supports 64 bit integers, so you should be
safe for even the largest tables.
However, your interface may only support 32 bit integers, so you may
need to use this lower limit. Which would mean the ids in your tables
must be less than about 200,000,000. This should still be plenty for
most applications. ;-)
Glad to help.
Dennis Cote
