Author: mbsoftwaresolutions@mbsoftwaresolutions.com
Posted: 2018-09-18 16:03:18 Link
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
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/c46ca07dbf6c37ebb1c2ea963f3a6d4b@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: mbsoftwaresolutions@mbsoftwaresolutions.com
Posted: 2018-09-18 16:05:33 Link
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.
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/82e16be6788f6df0874312e4f798eac0@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
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]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/C8A291C6-A0E2-468B-B16C-F8260E1D1E5A@gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
At 14:03 2018-09-18, 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?
I use
on key label "ctrl+0" *
so .null. can not be entered into controls.
I also enjoy the minor joke of
*
being executable in this control. Note that it does not mean the same as
on key label "ctrl+0"
Sincerely,
Gene Wirchenko
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/901f7bd9393ecc6ffb51b353985c30f8@mtlp000085
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: mbsoftwaresolutions@mbsoftwaresolutions.com
Posted: 2018-09-18 22:37:40 Link
On 2018-09-18 21:18, Gene Wirchenko wrote:
> I use
> on key label "ctrl+0" *
> so .null. can not be entered into controls.
Clever!!!!
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/de37121c794ed016258589ac52cb296b@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: mbsoftwaresolutions@mbsoftwaresolutions.com
Posted: 2018-09-18 22:41:41 Link
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!
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/626e7795171ba6c35e29d93d8c8d01b6@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
At 20:37 2018-09-18, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
>On 2018-09-18 21:18, Gene Wirchenko wrote:
>> I use
>> on key label "ctrl+0" *
>>so .null. can not be entered into controls.
>
>Clever!!!!
Thank you, but ...
I do not think of the above as particularly clever; it is
simply something that I worked out to avoid nulls. I happened to
think that way; you did not. With something else, it may go the
other way. Because we can communicate our
discoveries/solutions/what-have-yous, we each end up with more as a result.
This is a big reason why I like forums and lists.
On another point, I had an icase() function about five years
before Microsoft added it to VFP. Except for that Microsoft's
version has selected parameter evaluation and mine has all parameters
evaluated -- not something programmers can control in the VFP
language -- our icase()s work the same.
I wonder if Microsoft came up with the idea themselves -- not
that difficult; it seemed obvious to me -- or glommed onto my idea
(which I had posted publicly). Either way is fine with me, just as I
do not mind anyone using the above bit of code.
Sincerely,
Gene Wirchenko
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/22d9cc27527bfe7f68d4b3b37554b955@mtlp000084
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
> Except for that Microsoft's version has selected parameter evaluation and mine has all parameters evaluated -- not something programmers can control in the VFP language -- our icase()s work the same.
Technically speaking, you would be able to achieve this by rewriting the FXP file which must not be encrypted. There's a token for SkipOnTrue and SkipOnFalse that VFP inserts into expressions that are not fully evaluated, such as AND or OR. Whether this is really worth the effort is an entirely different question, though.
--
Christof
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/404CDC5D-46B5-4A33-A4E9-71E185388859@wollenhaupt.org
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
I use ON KEY Alt+F2 SUSPEND in my main program for when I get in a loop
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
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/1537347086.268168.1513190752.20E1E827@webmail.messagingengine.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.