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