Problems with "GenerateSQLforUpdTable"

[petersen]

hi

in some projects we use "TDBAccessUtils.SQLGenerator(AQuery).GenerateSQLforUpdTable ..." to generate sql-statements for "TIBCQuery".

we recently updated ibdac from 5.2.6 to 5.3.7.

with version 5.2.6 everything works like a charm but after updating to 5.3.7 we run into the same issue as described here: http://forums.devart.com/viewtopic.php?f=28&t=28618

Code: Select all

INSERT INTO CLIENTES
  (CGC, DIV, RAZAO, CIDADE, ...)
VALUES
  (?, ?, ?, ?, ...)

instead of

Code: Select all

INSERT INTO CLIENTES
  (CGC, DIV, RAZAO, CIDADE, ...)
VALUES
  (:cgc, :div, :razao, :cidade, ...)

can you please give us a hint to solve this problem?!

thank you

[ZEuS]

To resolve the problem, please add the following line before calling the GenerateSQLforUpdTable method:

Code: Select all

TDBAccessUtils.SQLGenerator(AQuery).SubstituteParamName := False;

[petersen]

works! thanks, once again, for your help!

[ZEuS]

It's good to see that the problem was solved.
If any other questions come up, please contact us.