> > 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.
If you do not expect any rows back from a query, use the do() function. Otherwise, you will need to post some sample code and, possibly a DBI Trace file (level 9) and versions of DBI and DBD::ODBC you use. Thanks, Jeff > > The OS is linux, the database is MSSQL and driver is > easysoft. Can anybody give me an idea about this error message. Thanks >
