Hello Drew, Regina, > Well, I should maybe do this in the issue tracker, but for now the list will > do.
(thanks to both for the investigations and all the issues submitted so far) > First - in advanced options settings I insured that 'append table name > alias on select statement' was checked. > ( so much for my doubting it is now an optional setting ) > > [ I'm still at a loss for how to do this with an embedded database? ] That option only controls the default-generation of statements. With it being ON, a simple SELECT statement would look as follows: SELECT * FROM "table" "table" where the alias equals the table name. You'll rarely find databases in the wild which require this notation. In particular, HSQLDB doesn't require it, so the option is not available there. The option does *not* affect your ability to manually assign alias names - which, now that you say it, is possible in the SQL view only, not in the design view. Hmm. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
