Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi-Steps error in ADO
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00525714
Message ID:
00526762
Views:
22
Thanks for the reply!

First ot all, the server not reject the post. Ado give the option to save the recordset in xml formta, and it keep the info necesary to do it. The problem is when i try to assign the generated id from sql server inside my local recordset.

I use XML not because is the buzz in this moment... is for stability.

VFP is not a good languaje in the Pointer/COM arena. The big problem is when this try to realese the object. For example

Local oRecordSet

oRecordSet=createobject(...

*-- work with oRecordSet

Return oRecordset = THIS LINE IS A PROBLEM. BAD RELEASING OF THE OBJECT IF IT HAVE REFERENCES TO OTHER OBJECTS.... MANUALLY DESTROY NOT WORK; UNASSIGNED MAYBE

Something VFP release the object, somethings not. Why? I see something (in debug) how VFP destroy the object in caos order, so maybe the object is released AFTER the others or BEFORE the others...

If a error ocurrs inside the method, is more problem... VFP not have a protection of error (Like Try..Except..End or Try..Finally in Delphi), so somethings the object still alive (and yes, i assign oRecordSet=.NULL., destroy the containers object, etc... I spend much time in it...)

Crahs, Red errors, OS Crahs, lost of code (Yes, something VFP destroy my code, forms, reports and projects!). This not is for a virus or bad machine, this happened in 4 different machines, in NT, 98 and 2000. Simply VFP have problems with COM (and yes, i have SP)
The Life is Beautiful!

Programmer in
Delphi, VS.NET
MCP
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform