Can't Prepare when '$' is included in parameter name

[tsteinmaurer]

Hello,

I've upgraded to 5.2.5. The following used to work in previous versions, but fails in 5.2.5.

I have the following table:

Code: Select all

CREATE TABLE T10 
(
  T10$ID               INTEGER         NOT NULL,
  T10$ID2              INTEGER,
 CONSTRAINT PK_T10 PRIMARY KEY (T10$ID)
);

A TIBCSQL instance with the following statement:

Code: Select all

insert into t10 (t10$id, t10$id2) values (:t10_id, :t10_id2)

Preparing the statement with the following code in Delphi 2010:

Code: Select all

if not IBCSQL1.Prepared then
  IBCSQL1.Prepare;

fails with the following exception text:

Code: Select all

First chance exception at $7500C41F. Exception class EIBCError with message
'
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 44
$'.
Process IBDacPrepareBug.exe (4000)

Obviously, if I remove the '$' from parameter names, preparing the statement works.

Any ideas?

Thanks.

[tsteinmaurer]

Any ideas? Thanks.

[PavloP]

To use parameters with name containing a '$' symbol, quote them, for example:

Code: Select all

insert into t10 (t10$id, t10$id2) values (:"t10$id", :"t10$id2")

When using the TIBCTable and TIBCQuery components, set the Options.QuoteNames property to True.

[tsteinmaurer]

Ok. Thanks. But having to use that options in this particular case regarding parameter names is new? Why not keep it backwards-compatible?

[PavloP]

We have reproduced the problem and fixed it. This fix will be included in the next IBDAC build.