What makes you think that transaction control is not part of SQL-92? If a database engine does not support transaction control it is not a full implementation. Transaction control is at the very heart of effective data management.
Shane Harrelson wrote: > Additionally, it's important to note that the LIMIT/OFFSET clause is not > standard SQL, and although it is supported by SQLite, and many other SQL > engines, there are some that do NOT support it, most notably Microsoft SQL > Server. > > HTH. > -Shane > > > On Tue, May 19, 2009 at 2:23 PM, Sam Carleton <scarle...@gmail.com> wrote: > > >> Kees Nuyt wrote: >> >> >>> Imagine a SELECT with an ORDER BY which makes SQLite sort >>> the resultset before it can return the first row in the >>> resultset. Need I say more? >>> >>> http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor >>> >>> >>> >> Thank you for the link, it is a VERY useful read, VERY useful! >> >> Sam >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
