Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tracking which record changed in grid
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01624699
Message ID:
01624705
Views:
34
>>>>Hi,
>>>>
>>>>I have a grid bound to a cursor. I need to track which rows of the cursor user "touched" (made changes). So I am going to add a column CHANGED L to the cursor. Then when user makes any change in any column of the grid row I will set the value of CHANGED to .T.
>>>>
>>>>But how do I determined which cursor row is currently in focus/selected? That is, when user click in any column of the grid row, the cursor row does not actually move there.
>>>>
>>>>What would you suggest?
>>>
>>>You can use Column's control GotFocus and LostFocus or Valid events. E.g. in the GotFocus you save current value, in LostFocus or Valid you compare it with the saved value and set the flag using a replace command. It will update the current row which is the one that was touched.
>>
>>I know about GotFocus, LostFocus and other methods. But I didn't think that when I click into a cell the cursor row has moved. For example, if I click into a cell and then (on LostFocus) determine that the value has changed and then call the following:
>>
>>
>>replace CHANGED with .T.
>>
>>
>>I am not sure that the above will change the column CHANGED in the ROW corresponding to the cell value. You see what I mean?
>
>Yes and it will change the corresponding row. In other words, once you clicked and started to change, it will be that ROW. If you just clicked, then it is not known.

why then, when I click into any cell of the grid and in the GotFocus check the value of the PK field and display in messagebox(), I see the same value? no matter what cell I click?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform