How to see complete SQL command

Hello!

I am using a Interbase Query Component(IBQ_cuentasComp) with some variables:
datamodule->IBQ_cuentasComp->SQL->Text = "UPDATE \"cuentasSaldo\" CS SET CS.\"CSAL_CUENTACONAC\" = :cuentaConac WHERE CS.\"ID_CUENTASSALDO\" IN :idsCuentasSaldo ; ";

After having put the variables into their place with ParmsByName I get an error while calling Open() Method

1
2
datamodule->IBQ_cuentasComp->ParamByName("cuentaConac")->AsString = treeViewCuenta; /* Contains a String "Account Name" (I proofed that!) */
datamodule->IBQ_cuentasComp->ParamByName("idsCuentasSaldo")->AsAnsiString = inArray; /* Contains a String like "(2,5,6)" (I proofed that!) */ 


It says "Dynamic SQL Error ,SQL Error Code = -104, Token unknown -line 1, char 85?." But as I watch the IBQ_cuentasComp->SQL->Text I can only see my statement before the parameters are put and furthermore I don't know how to count it correctly for I don't know if I have to count the \ in my SQL command and the other chars in the String: { u"UPDATE \"cuentasSaldo\" CS SET CS.\"CSAL_CUENTACONAC\" = :cuentaConac WHERE CS.\"ID_CUENTASSALDO\" IN :idsCuentasSaldo ; \r\n" } If I count 85 chars I get to the middle of the word of the :idsCuentasSaldo parameter. Or does 85 refer to the whole statement after having put the parameters? How can I watch it? The IBSQLMonitor just gives me the same error message (Token unknown) and does not help me.
Please help!!! Thank you

Last edited on
Topic archived. No new replies allowed.