On 2018-09-18 17:03, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
VFP9SP2 on Win7/8/10 pcs
I really never fully took advantage of this gem in VFP. In my apps, I haven't allowed editing in grids in probably 14 years. Some of my users seem to want that though so I'm thinking of allowing such ability now. I was thinking of using ON KEY to pop up a lookup form to add data records to the grids (instead of that native whatever way of doing an APPEND blank in the native VFP grid).
In the past, I've really just used ON KEY to pop up the help file on demand.
In what other ways have you used ON KEY in your designs?
It's worth noting too that I use disconnected cursors (like Charlie Coleman's approach from the late 1990s!). Backend is MySQL and I basically just use the current app handle (or re-establish if not connected) and perform the add/edit/delete. So it's not like I have to worry about updateable views or anything like that. My own framework is all SPT calls.