
VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL Syntax
VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL
Syntax
We are trying to find a common standard for Oracle 8i and SQL Server 2000
for SQL commands in ADO 2.5 objects and VB6 code. They use different a
syntax for outer joins (one uses a (+) and the other a *:
Oracle 8 apparently also requires that the table name is sent between quotes
(although documentation says otherwise), whereas SQL 2000 forbids it.
Ex.
Oracle: select "t1".id from t1,t2 where t1.field1 (+)= f2.field2
SQL Server: select ti.id from t1,t2 where t1.field1 *= f2.field2
Can anyone help?
Thanks in advance!
Jorge Ferreira