Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pessimistic Row Buffering vs No Buffering
Message
From
17/09/2000 21:07:02
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00417335
Message ID:
00417476
Views:
16
Hi,
>and compare OLDVALs with CURVALs (both are VFP unctions special for this). When you encounter differense, AND when user changed value locally - ask about overwrite. When user not change value, replace value in currect reccord by

Just finished testing a proceedure based on the method you suggested. I works great! Thanks. Was stuck for a bit on finding the number of fields in the table without hardcoding it. Ended up with

mnTotFields=Len(SUBSTR(GETFLDSTATE(-1,"Students"),2))

FOR mnHitPoint=1 to mnTotFields &&Check Each Field
SELECT students
fieldname=field(mnHitPoint)
IF &fieldname==OLDVAL(FIELD(mnHitPoint)) &&This user hasn't changed it

And so on! I have a customer that will be very happy.

Thanks again,
Bill
Bill Leber
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform