Re: Database in Exclusive Mode Detailed

Rob Minter writes: |> 1. First Part. |> A. Prepare a cursor from a construct or otherwise. |> B. Open cursor |> C. Foreach Loop on Cursor to insert into a table values needed from cursor. |> D. Close cursor. |> E. Prepare Second Cursor from table with new info. |> F. Open cursor 2. |> G. Fetch One row at a time and display stuff. |> H. Close cursor 2. |> 2. Second Part. |> A. DATABASE <db-name> EXCLUSIVE statement executed. |> B. Some Selects and Updates are done. |> C. CLOSE DATABASE statment executed. |> D. DATABASE <db-name> statment executed. |> 3. Third Part. |> A. Prepare a cursor from a construct or otherwise. |> B. Open cursor |> C. Foreach Loop on Cursor to insert into a table values needed from cursor. |> |> This is where it is happening on the second time around. We are getting |> a -410 error. Problem is, it's erroring on an INSERT Statement. You aren't using an insert that was prepared in either the First or Second part (above), are you? When you close a database or issue a new database statement, all previously prepared statements are gone. You would need to reprepare the insert within the Third part. Dave Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney