Unanswered: Error executing SQL code in While Loop (Was "Help Needed")
I need one help please. I prepared one command out side the while loop. And i am executing the prepared query in the while loop through front end. And i am committing in the while loop through front end only.After the commit the cursor again going to select execute command. At that time i am getting error as :[Microsoft][ODBC Driver Manager] Function sequence error. Can any one help me how to rectify this error. I came to know why the error coming. Because i am trying to execute the command after coming. But i need to do this. Previously i used SQLBASE. In that i used "DBP_PRESERVE" that problem has gone. But here how to do. I am new to this.