community.borland.com

Article #25447: 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.




Last Modified: 26-OCT-00