Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tracking which record changed in grid
Message
From
16/09/2015 11:34:40
 
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:
01624702
Views:
48
I would suggest:
procedure form.load
cursorSetProp('yourCursor', 'buffering', 5)
...
select yourCursor
GO TOP
store 0 to liRec, lnRec
DO WHILE .T.

	liRec = GetNextModified(m.liRec, 'yourCursor')
	IF m.liRec > 0

		&& record modified
		GO m.liRec IN yourCursor
		lnRec = m.lnRec + 1
		
	ELSE
		EXIT
	ENDIF
enddo
>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?
Thierry Nivelet
FoxinCloud
Give your VFP application a second life, web-based, in YOUR cloud
http://foxincloud.com/
Never explain, never complain (Queen Elizabeth II)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform