Uniforming SQL syntax (ex. allow float in CAST/CONVERT instead of SQL_Double only)
As a 'user' of the Advantage DB (local server only) I was wondering, why
the type names SQL_Double, SQL_Integer, etc. are used in CAST/CONVERT statements instead of the 'normal'
type names like 'float' and 'integer', which are already used in the declare
statements and the create tabel statements?
If it's backwards compatibility, why not allow the SQL_ types AND the
'normal' types, which are used in ADS already?
This would be less confusing for developers to 'use' the ADS sql-syntax.
Jens Mühlenhoff commented
The reason for this might have something to do with ODBC support.
ODBC uses SQL_ for the SQL to C data type conversions.
Ronald Hoek commented
Note, I'm not asking to remove the old SQL_xxx types, only to allow some addition types to be used in the syntax!!!