Could someone take a look at this code and tell me what is wrong.
I am updating a text field in PD. I have a call to addText sending 4 parameters
Here is the function:
sql= "declare @ptr varbinary(16)";
sql += "select @ptr = textptr(" + column + ")";
sql += " from "+ table+ " ";
sql += "where project_id = convert(int,"+pk+")";
sql += " writetext " + table + "."+column + " @ptr with log \""+ textData + "\" ";
myQuery8 = connection.CreateQuery(sql);
Now everything works fine on the addText call, but if I have
I will get an error on the second addText.
The error is:
ct_command(): user api layer: external error: This routine cannot
be called when a command has been initialized
but not sent.
I have reversed the order of the calls to see if there was an inhereant problem with that particular field. There is not. Do I need to call a separate function for the second call that esentially does the same thing?