Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data change detection
Message
 
 
To
15/05/2008 07:45:50
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01317212
Message ID:
01317253
Views:
9
Thomas,

Why would you generate in-line schema in this case?

>If you don't want to check changes in individual fields, you could do something like this:
>
>
>* in form.init save cursor state in property
>Thisform.AddProperty([DataOnStart])
>CURSORTOXML([myCursor],[Thisform.DataOnStart],1,1+2+4,0,[1])
>
>* in 'save' procedure compare old vs. new
>CURSORTOXML([myCursor],[lcDataOnSave],1,1+2+4,0,[1])
>
>IF ThisForm.DataOnStart <> lcDataOnSave
>    * Save your Cursor here
>ENDIF
>
>
>However, I don't think, that it is a good idea to always save the complete cursor. You should check for changed records only and replace those in your database. So IMHO you should hang on to Craigs post.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform