Hi,

At August 29, 2003, 15:11, henry FRANQUET wrote:

> Hello

> with BDE we can either use ' or " as string delimiter. BDE
> transforms " to meet interbase requirement

> IBO doesn't, so I have to modify the string before inserting in
> TString SQL property

Both quotes are accepted in Interbase, but only the single-quote is a
string delimiter. The double-quote is a database object name
delimiter, they are required if the object name is case sensitive.

Here's an example:

SELECT CLIENTS."FirstName", CLIENTS."LastName"
FROM CLIENTS
WHERE CLIENTS."LastName"='Smith'

The double-quotes are required when field names or table names are
defined as case sensitive. And, there might be other database objects
that would also require the double-quotes, because of their case
sensitivity.

The BDE probably checks to see if the value is not a field name before
changing the double-quote to a single-quote.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)