Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Code was working in VFP 7 but not VFP 9
Message
 
 
To
05/02/2014 14:30:10
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01593286
Message ID:
01593325
Views:
36
Thank you, I will check that out. If it's not a change in VFP 9 then that does in fact help.

>Mel,
>
>not that I know of a specific VFP 9 problem here,
>
>REQUERY() is not allowed during a TRANSACTION. The ERROR 1593 help dosen't show it, but look under BEGIN TRANSACTION.
>
>Check TXNLEVEL and search the callstack where the TRANSACTION starts.
>
>I have never trusted foreign frameworks. :)
>
>HTH
>
>Lutz
>
>>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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform