ID Number: Q76567
1.11 | 1.11 | 1.11
MS-DOS | WINDOWS | OS/2
buglist1.17
Summary:
Problem ID: PRSQL9109005
SYMPTOMS
Using dbqual() to add a WHERE clause to a query can result in a
syntax error (that is, message 102, "Incorrect syntax near '%.s'").
CAUSE
When the unique index is on a CHAR or VARCHAR column, dbqual() uses
apostrophes to build the WHERE clause. However, dbqual() does not
take into consideration that the character column data may contain
an apostrophe. In this case, dbqual() will not build a
syntactically correct WHERE clause.
For example, if the character column contains the last name,
"O'Neil", then dbqual() mistakenly builds a WHERE clause similar to
"where (name = 'O'Neil') and...".
STATUS
Microsoft has confirmed this to be a problem in DB-LIBRARY (dblib)
version 1.17. Microsoft is researching this problem and will post
new information here as it becomes available.
Additional reference words: db-lib