[All]
Escape clause {oj} fails to function
Abstract: Escape clause {oj} fails to function
Problem:
Escape clause {oj} fails to function since upgrade to ODBC
driver version 2.00.903. Error returned is "[Visigenic] [ODBC
InterBase 4.x Driver] [InterBase] Dynamic SQL Error".
Solution:
This is a bug in the Visigenic InterBase ODBC driver for
version 2.00.903. Here are two workarounds:
1) Use the driver version 1.00.809.
2) Try to eliminate the use the escape clause {oj}. Pass sql
statement directly to the InterBase engine. For example:
Statement using escape clause
------------------------------
select proj_id,full_name from {oj employee left outer join
employee_project on employee.emp_no=employee_project.emp_no}
Without {oj} escape clause:
------------------------------
select proj_id,full_name from employee left outer join
employee_project on employee.emp_no=employee_project.emp_no
Note: One can run the above statement against the sample database,
employee.gdb, in the examples directory.
