Product: Database Access
Type: new
Title: advanced database setting: "Use keyword AS before table alias
names"
Posted by: [EMAIL PROTECTED]
Affected: -
Effective from: CWS dba22ui
*Flags*
-------
API/ BASIC [ ]
Configuration [ ]
File format change [ ]
Help/ Guide [x]
Performance test [ ]
Translation [x]
UI relevant [x]
*Description*
-------------
In the advanced database settings (menu: Edit / Database / Advanced
Settings, dialog page: special settings) a new option is available,
called "Use keyword AS before table alias names".
This option is enabled if and only if "Append the table alias name on
SELECT statements" option is checked, and itself checked by default
for newly created databases.
When checked, SQL statements generated by Base will use the AS keyword
as follows:
SELECT * FROM "table" AS "table"
When not checked, the above statement would look like
SELECT * FROM "table" "table"
The first option is more human readable, the second option is required
by some databases (Oracle ODBC, in particular).
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
