Update statements fail when fieldname starts with digit

[uberbach]

Using DbxSda driver version 4.45.0.18, I cannot execute update statements when at least one fieldname starts with a digit. An older driver that I have (3.10.8.0) has no problem with it, because it puts quotes around the fieldname.

For example the old driver generates:

Code: Select all

update "1fieldname"...

and the new one does

Code: Select all

update 1fieldname

[Dimon]

To solve the problem you sould use the TCRSQLConnection component and set the UseQuoteChar parameter, like this:

Code: Select all

CRSQLConnection.Params.Values['UseQuoteChar'] := 'True';