Devart Forums

Posted: **Tue 06 May 2014 12:43**

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

Posted: **Wed 07 May 2014 09:31**

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

Code: Select all

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

Posted: **Wed 07 May 2014 13:19**

works! thanks, once again, for your help!

Posted: **Wed 07 May 2014 13:29**

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

Devart Forums

Problems with "GenerateSQLforUpdTable"

Problems with "GenerateSQLforUpdTable"

Re: Problems with "GenerateSQLforUpdTable"

Re: Problems with "GenerateSQLforUpdTable"

Re: Problems with "GenerateSQLforUpdTable"