SQLType has nothing to do with the Interbase Dialect. Interbase Dialect has to do with additions to the supported SQL syntax, which isn't compatible with IB 5.6 and below. It is choosen in the database itself, and in the database connection component in Delphi (TIBDatabase and similar)
AFAIK, DADE SQLType has to do with the SQL features used by the DADE query builder. The difference I know of is the SQL89 and SQL92 join syntax. SQL1 is joining like:
SELECT ... FROM table1, table2 WHERE table1.PK = table2.FK
where SQL2 is joining like SELECT ... FROM table1 INNER JOIN table2 ON table1.PK = table2.FK.
AFAIK MSAccess doesn't support SQL92 joins, MSSQLServer does support SQL92 joins. Interbase 6 and higher does support SQL92 joins in Dialect1 and Dialect3
Comments
As far as I know, Borland is not making any radical changes to Interbase.
Interbase 7.1 should be ok to use with ReportBuilder.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
I'm just wonder as Interbase 7.x can use Dialect3 as we use.
/Ronny
SQLType has nothing to do with the Interbase Dialect. Interbase Dialect
has to do with additions to the supported SQL syntax, which isn't
compatible with IB 5.6 and below. It is choosen in the database itself,
and in the database connection component in Delphi (TIBDatabase and
similar)
AFAIK, DADE SQLType has to do with the SQL features used by the DADE
query builder. The difference I know of is the SQL89 and SQL92 join
syntax. SQL1 is joining like:
SELECT ...
FROM table1, table2
WHERE table1.PK = table2.FK
where SQL2 is joining like
SELECT ...
FROM table1 INNER JOIN table2 ON table1.PK = table2.FK.
AFAIK MSAccess doesn't support SQL92 joins, MSSQLServer does support
SQL92 joins. Interbase 6 and higher does support SQL92 joins in
Dialect1 and Dialect3
Diederik
Clear as crystal.
Thanks.
/Ronny