標(biāo)題: 錯誤信息:USING option with open statement is invalid for insert cursor [打印本頁] 作者: feeling 時間: 2005-12-14 17:39 標(biāo)題: 錯誤信息:USING option with open statement is invalid for insert cursor 通過程序使用ODBC在執(zhí)行一個insert操作時出錯,相關(guān)信息如下:
STATE=60, CODE=-416, MSG=[DataDirect][ODBC 20101 driver][20101]USING option with open statement is invalid for insert cursor.
查了一下這個-416的錯誤代碼:
-416 USING option with open statement is invalid for insert cursor.
This OPEN statement refers to a cursor that was declared for an INSERT statement. The USING clause of the OPEN is not appropriate in this case; it is only used to specify the variables that are used with a SELECT statement. Review the program to ensure that the correct cursor has been used in this statement. If it has, and if the INSERT statement is written as part of the DECLARE statement, you can name the host variables directly in it. If the INSERT statement has been prepared, you can specify the host variables in a FROM clause in the PUT statement.