Perhaps someone can help me with this issue. I am moving an VFP 7 application to VFP 9.

I have a specific form that has a parent and 5 child tables (and it worked perfectly in VFP 7 for last 10 or 12 years), but when I delete a child record - it does give error #1593. However, the record is deleted when I close the error message.

Does anyone know if this error might be caused by a new changed feature in VFP 9? I am using CodeMine framework (which is no longer being developed), so I am trying to isolate my debugging issues. If needed, I can probably rebuild the relationship for these child records if in fact I isolate it to a CodeMine issue (which also had a version change from VFP 7 to VFP 9).

Any thoughts or suggestions are appreciated. Following is the exact error as copied form the error dialog:



Visual FoxPro 09.00.0000.7423 EXE Support Library for Windows [Feb 23 2009 13:26:51] Product ID
CodeMine 7.5.1b
Error #1593 in Requery
An unexpected system error has occurred. Please make a note of the error message details and report it to your system administrator.
Command cannot be issued within a transaction.

Call Stack:
13 cdefamily.wclass.cmdataaccess.requery
12 cdefamily.wclass.accessrequery
11 cdefamily.wclass.requery
10 cdefamily.cm_cms_rule_v81.requery
9 cdefamily.cm_cms_rule_v81.afterdelete
8 cdefamily.wclass._executerule
7 cdefamily.wclass.delete
6 formfam_only001.cmdatamanager.delete
5 formattendance001.delete
4 cmstatemanager.execute
3 formattendance001.cmddeletewclas.click
2 appapplication.start
1 C:\companyname (software\myapp\myapp.exe)