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.