Jay said: > Interesting! > How do they handle calculated columns and constraints and such? > Does it just fail?
Most ADO wrappers cough up a hairball and refuse to proceed. That is, coincidentally, what should be done when you're trying to update a dataset that resulted from a join. Unless I'm completely missing something, actually updating a dataset is restricted to use in cursors, and SQLite notably does not support cursors. What people decide to do with their wrappers is their own business, but I for one would much rather see Dr. Hipp's time devoted to new features such as the previously mentioned true ALTER TABLE syntax than chasing down bugs that allow people to support dodgy SQL. For those of you having the problems with loading data into a hash, feel free to contact me off-list and I'll help you get around the problem. The solution is fairly easy. Clay Dowling -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development
