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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
