begin works and commit works in

Rudolph Your problem is caused by the cursor being closed after the commit. You will find somewhere in the manuals (about commit I think) that it says that when a commit is performed, all cursors get closed. To get around this you need to declare you cursor with hold. I cannot remember the exact syntax, it is something like this (check the manual): Foreach TxFT With Hold For Select..... This should get you out of difficulties. Mark MarkDenham@aol.com (home) Denham.M@amstr.com (work)