Hi, I use the following statement to insert records (which are not in the real table) from temp table to real table, but it gives me error message. The statement I use is: "$copySQL = "INSERT INTO $tblReal (SearchID, Score) SELECT SearchID, Score FROM $tempTBL WHERE SearchID NOT IN (SELECT SearchID FROM $tblReal)";
the error message is: DBD::ODBC::st execute failed: [unixODBC][Driver Manager]Function sequence error (SQL-HY010)(DBD: dbd_describe/SQLNumResultCols err=-1) at ./SGPPModule/ParseResult/SGPPDataInsertCDnew.pl line 531. The OS is linux, the database is MSSQL and driver is easysoft. Can anybody give me an idea about this error message. Thanks Grace ------------------------------------------------------
