> The ommissions list has some ommissions :) If you track the WiKi of > updates people have submitted you will find a much longer (but far > from complete) list: > http://www.sqlite.org/cvstrac/wiki?p=UnsupportedSql&t=1101185477
Not wanting to get into a heated debate about it but.... There are lots of "not sure if" type comments in that Wiki regarding whether or not the things on that wish list are SQL92 or not. To be fair I'd have to do a bit of research to see if they are or not myself but offhand, most of them look like they are SQL shortcuts that have alternative ways to do them available or DB specific to systems like Oracle and MS SQL and Postgres etc.... As for my work with SQLLite, I only require a couple of small tables with integer and text datatypes so I haven't really looked into using it for much else. I have to say, for what I need (and probably countless others) from an embedded solution it does do a good job :) It's not a perfect solution, but adequate for it's intended purpose... A bit like MySQL... :) Paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185461 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
