FIX: Keywords in WHERE Clause Cause Oracle ODBC Driver Errors

   SELECT * FROM PRBSPACE WHERE C1 = 'For Your Eyes Only'
				

MORE INFORMATION

Steps to Reproduce Behavior in ODBCTest

First, create the table:

   CREATE TABLE PRBSPACE (C1 VARCHAR(20))

   INSERT INTO PRBSPACE VALUES ('For Your Eyes Only')
   INSERT INTO PRBSPACE VALUES ('Select a Word')
   INSERT INTO PRBSPACE VALUES ('This is a test')
				

1. FULL CONNECT(Use Driver).
2. SET CURSOR ATTRIBUTES

   
      SQL_CURSOR_KEYSET_DRIVEN=1
      SQL_CONCUR_VALUES=4
   						

   Click OK.
3. Type the following SQL in the Execute window:
   
   SELECT * FROM PRBSPACE WHERE C1 = 'For Your Eyes Only'
4. SQLPrepare.
5. SQLExecute.
6. SQLBindCol.
7. SQLExtendedFetch.

RESULTS:

Return: SQL_NO_DATA_FOUND=100

To show that the steps above work, use the following SQL Statement:

   SQLCancel
				

Change the WHERE clause string to (this works):

   SELECT * FROM PRBSPACE WHERE C1 = 'This is a test'
				

Follow steps 4 through 7. No Error, and data is returned.

To show that different KEYWORDS are effecting the query try the following:

   SQLCancel
				

Change the WHERE clause to:

   SELECT * FROM PRBSPACE WHERE C1 = 'Select a Word'
				

Follow steps 4 through 7. Now the error occurs on the SQLPrepare: