Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid RowColumn Change
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00026366
Message ID:
00026542
Views:
44
>>>How do you differentiate between a row or column change in a grid. RowColumnChange is just sent a number so it could be either one. I'm trying to stop a row change when the user has modified a record. Thanks.
>>
>>In BeforeRowColChange Event:
>>select gridsource && table/cursor/view
>>thisform.togglegrid=recno()
>>In AfterRowColChange Event:
>>select gridsource
>>IF thisform.togglegrid=recno()
>>**** row changed
>>ELSE
>>**** column changed
>>ENDIF
>
>recno() is very tricky, would avoid as can give erratic behavior, especially in multiuser environment with additions and deletions, packs and buffering etc. Much better to use activerow or a primary key field check.

Sorry, I have to mention that in multi-user environment RECNO() is pretty reliable because nobody can pack tables over there.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform