I have since taken Sqlite version 2.8.9 and rewritten the OS related code plus a bit of other stuff due to stack space limitations. (I will zip it up and send it to you when I can find a minute.)
All worked well with a minimal test application but when I put in into my full size application the SELECT statements ran very slow under Palm OS 5 and would not run at all under Palm OS 3.5 due to insufficient memory and stack space. I have a few ideas about how to get around the limitation imposed by the Palm OS but I just have to find the time to try it out.
Another potential problem had to do with indexes and hotsynch'ing but that one is fairly involved. If there are enough people interested I would be happy to document my experiences, results and recommendations.
-- Warren Taylor, B.Sc., Taylor Software Inc. mailto:[EMAIL PROTECTED] http://www.taylorsoftware.ca/
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

