> I haven't tested it yet, but Johannes changed a version I checked in > which was based on the withviews. My version was not tested on oracle, > but it created the same structure in MSSQL. The current code checks for > option database-supports-insert-triggers so I guess it will be ok.
Indeed; it should be backwards compatible. > > Doesnt return oracle the complete list of reservated words? No it doesnt, at least, that didn't work in the version that Nico committed. I did however find a list online, and put it in the oracle.xml file now. > This will work for all queries > > PAGING_PREFIX = "select * from (select rownum a, thedata.* from ( "; > PAGING_POSTFIX = " ) thedata ) where a between ? and ? "; > limitQuery = PAGING_PREFIX + query + PAGING_POSTFIX; I wrote a version that works for all queries that I will commit later this week or next week. The main prlbmen I got was with multilevel queries where you query the same fieldname from different builders; the 'select *' will fail on oracle. I did create a workaround though, but it needs more checking. By the way; I just saw that mysql 5.0 also supports both views and triggers on views; and the syntax is similar. Maybe a nice testcase to see if this code works on mysql 5.0? Johannes _______________________________________________ Developers mailing list [email protected] http://lists.mmbase.org/mailman/listinfo/developers
