Using LOCAL-SQL or Transact-SQL with SQL-server and BDE

Havard Ostgaard

Delphi Developer

Thu, 22 Jul 1999 03:00:00 GMT

Using LOCAL-SQL or Transact-SQL with SQL-server and BDE

I'm a bit confused how BDE works regarding SQL statements. Has BDE the
capability of taking Local-Sql (ANSI-SQL) statements and translate it to
the native SQL according to the db-server?
I've fiddled with the obvious Alias-parameter (SQLQRYMODE = LOCAL) but
without any result.

PS: The major reason for looking in to this is that Microsoft will
discontinue supporting Transact-SQL joins (table1.ID =* table2.ID) in
future versions of SQL-server. I know that SQL-Server 6.5 support
ANSI-SQL but I have to make programs that also will run on v6.0.

Havard Ostgaard

Other Threads

1. Local SQL, works in MS SQL, not in local SQL

2. Difference with PL-SQL and Transact-SQL

3. Local SQL v.s MS SQL Server

4. Delphi 3.0 - IIS ISAPI + SQL Server (MS) + BDE = SQL Server not found errors

5. Can BDE MSACCESS use SQL (not local SQL)

6. Local SQL challenge - for all you local SQL gurus:

7. MS Transact SQL in TQuery using D5

8. What BDE SQL = Server SQL?

9. BDE SQL Link / ODBC for MS SQL Server

10. Creating MS SQL Server database in the specific path Using SQL-DMO