Marc Santhoff wrote: > Am Samstag, den 19.01.2008, 19:42 +0100 schrieb Andreas Saeger: >> I prefer to create selects in SQL view. In SQL view I have can turn on >> "native SQL" which is the same as "pass-through" in Access(?). > > I think so, yes. > >> Is there any feature in "OOo SQL" not in "native SQL" for hsqldb? The >> only scenario I can think of > ... > > Writing code (=SQL queries and the like) is dangerous if you would ever > have to move your base application from one database to another. > > Let's say you are building it using internal HSQL and afterwards want to > make it mutli user moving to an external SQL server. If you or someone > else decides to use MySQL or Oracle, some of the native HSQL statements > will fail. Although there are standars like SQL92, SQL99 and SQL2003 (is > that one finished?), the implementations do differ a lot in practice. > > When I was dealing with programming database client programs I strictly > avoided using features only available in one brand. And stored > procedures too, you have to write them completely new when changing > databases. > > That's what "OOoSQL" does for you. > > Marc
Thanks for the warning. What if we stay with your database engine but switch the frontend? In this scenario we would be better off with native SQL, ain't we? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
