Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data change detection
Message
From
15/05/2008 07:45:50
 
 
To
14/05/2008 23:06:20
Reza Meamar
Homa Programming Group
Shiraz, Iran
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:
01317251
Views:
11
Hi Reza,

>I have a cursor that I fill it with some data and it connected to one grid and some textbox in my form. I have a SAVE command button on my form that user must click on it , if he/she made any changes in data.
>How I can know that user changed the data? ( or How I can know that user changed the cursor content? )

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.
Best Regards
-Tom

Debugging is twice as hard as writing the code in the first place.
Therefore, if you write the code as cleverly as possible, you are,
by definition, not smart enough to debug it.

Oh, and BTW: 010101100100011001010000011110000101001001101111011000110110101101110011
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform