In T-SQL code on SQL Server 2005, the variable :t_id is being passed from other pages and works in other statements, but it is not parsing within this statement:
insert into TFT (WG_ID,task_id,tf_id)
SELECT (select WGID from LU_T where TID= :t_id ), :t_id , (select max(TF_ID) from LU_TF); ");
If I replace :t_id with a number, it works fine. I tried declaring a new variable and passing it to the statement, and I get this same error:
An error was encountered while saving: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error (SQLExecute at extpdo_odbcodbc_stmt.c:133)
Any idea what is going on?