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?
tia, --Mike
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.
Not sure I'm understanding. Do you want to allow editing in the grid or do you want a popup form to edit the records from the grid?
I have allowed editing in grids with no problems for many years using visual max frame.
I would never use an on key label for anything in an application. I would use buttons with hot keys or if that is not possible use the form's key press.
On 18 September 2018 17:03:18 GMT-04:00, 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?
tia, --Mike
[excessive quoting removed by server]
On 2018-09-18 19:29, Frank Cazabon wrote:
Not sure I'm understanding. Do you want to allow editing in the grid or do you want a popup form to edit the records from the grid?
I've always used a separate form for single record add/edit. Then took that object and validated it in the business object (my controls were always thisform.oRecord.cLastName, etc.), then passed that to my data object to add/edit/delete in the backend (MySQL) database via my SPT code.
I have allowed editing in grids with no problems for many years using visual max frame.
For some reason (probably years before I switched to non-binding VFP cursors instead of local views or direct tables in my earliest VFP days), I favored avoiding data entry in grids. Some here may have helped me form that position too.
I would never use an on key label for anything in an application. I would use buttons with hot keys or if that is not possible use the form's key press.
I liked the Help manual idea for it!
I use ON KEY Alt+F2 SUSPEND in my main program for when I get in a loop 😊
John Weller 01380 723235 07976 393631 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).
We use ON KEY LABEL F1 for throwing up the application help file. Aside from that we almost exclusively use form KeyPreview() methods I think.
I use ON KEY LABEL just for debugging purposes, like suspending, opening dev tools menu or admin maintenance, dumping memory variables to disk and the like.
El mié., 19 sept. 2018 10:51, Alan Bourke alanpbourke@fastmail.fm escribió:
We use ON KEY LABEL F1 for throwing up the application help file. Aside from that we almost exclusively use form KeyPreview() methods I think.
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
Me too, On Key label activates several app to assist on development. Not for production except F1 to activate help Koen
Op wo 19 sep. 2018 om 13:54 schreef Fernando D. Bozzo fdbozzo@gmail.com
I use ON KEY LABEL just for debugging purposes, like suspending, opening dev tools menu or admin maintenance, dumping memory variables to disk and the like.
El mié., 19 sept. 2018 10:51, Alan Bourke alanpbourke@fastmail.fm escribió:
We use ON KEY LABEL F1 for throwing up the application help file. Aside from that we almost exclusively use form KeyPreview() methods I think.
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
I thought set help on and set help to <file name> automatically make the F1 key work without having to use on key label. At least I have never had to set on key label f1 to get my help to work in my applications.
Frank.
Frank Cazabon
On 19/09/2018 04:51 AM, Alan Bourke wrote:
We use ON KEY LABEL F1 for throwing up the application help file. Aside from that we almost exclusively use form KeyPreview() methods I think.
On 2018-09-19 11:19, Frank Cazabon wrote:
I thought set help on and set help to <file name> automatically make the F1 key work without having to use on key label. At least I have never had to set on key label f1 to get my help to work in my applications.
I never used the integrated help like that. My F1 key simply called the routine to launch the appropriate help document (PDF) via ShellExecute.
Thinking about it some more, I always have a menu available with the 2 help bars: _mst_hpsch and _mst_help so maybe that's why F1 works by default, but then again, maybe it just works by default. I have my screens and controls set (HelpContextID) to bring up specific places in the help file (CHM) so that the help is context sensitive. If you're not using the built in help functionality I guess you need to handle the F1 key some other way. It's amazing how much we forget if we don't do this stuff regularly.
Frank.
Frank Cazabon
On 19/09/2018 10:16 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
On 2018-09-19 11:19, Frank Cazabon wrote:
I thought set help on and set help to <file name> automatically make the F1 key work without having to use on key label. At least I have never had to set on key label f1 to get my help to work in my applications.
I never used the integrated help like that. My F1 key simply called the routine to launch the appropriate help document (PDF) via ShellExecute.
[excessive quoting removed by server]
I wrote software for the used car business and one early customer paid me big money to put an ON KEY command to format the hard disk. This was either in 89 or 1990 time frame.
The other On Key was to bring up the command window to execute commands in an attempt to find out what might be wrong at a client's site.
On Tue, Sep 18, 2018 at 4:03 PM 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?
tia, --Mike
[excessive quoting removed by server]
On 2018-09-19 09:36, Stephen Russell wrote:
I wrote software for the used car business and one early customer paid me big money to put an ON KEY command to format the hard disk. This was either in 89 or 1990 time frame.
LOL!!! Sounds like the "self-destruct button" on the St. Georges secret spy ship in the beginning of For Your Eyes Only! "Destruct ATAC system!"
He got the program to do all of his forms but didn't want any "real" facts outside of his books. Accounting for the auto industry is pretty "obscure" to be honest. Values you see on contracts are not the same in the GL for the actual transaction, especially if there was a trade in in the deal as well as "packaged" add-ons.
On Wed, Sep 19, 2018 at 9:19 AM mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
On 2018-09-19 09:36, Stephen Russell wrote:
I wrote software for the used car business and one early customer paid me big money to put an ON KEY command to format the hard disk. This was either in 89 or 1990 time frame.
LOL!!! Sounds like the "self-destruct button" on the St. Georges secret spy ship in the beginning of For Your Eyes Only! "Destruct ATAC system!"
[excessive quoting removed by server]