I know that, I have been doing that for years. I even teach VFP to newbies and that is one of the first things they learn

But you know what, I _forgot_ to kill the recordsource prior to changing the underlying cursor.

Gosh!! You guys call this "brain fart" right?

Well, I guess I had one today.

Thank you Fred and Stacey, you cleared the fog in my brain :-)

Rafael Copquin



El 08/08/2013 05:50 p.m., Fred Taylor escribió:
It's called "grid reconstruction".  What you've done is destroy all the
code that went with the grid.  You may be able to stop that behavior by
blanking the grid.RecordSource property, getting the new data via SQL, and
then resetting the grid.RecordSource property to your new alias for the SQL
cursor.  Even if they're the same name, you still have to do this.  You may
also need to reset your Column.ControlSource property of all your columns
if your fields in the grid or in any order other than what the fields in
the cursor are.


Fred


On Thu, Aug 8, 2013 at 1:44 PM, Rafael Copquin <[email protected]>wrote:

Again with hot key blues!:-(

I have this form with a grid and a series of hot key calls from the
keypress event of one of its columns (the textbox of the column)

All goes well, until I change the underlying cursor of the grid.
The hot keys no longer work

IOW, I use a select statement to show a cursor in the grid. The hot keys
work.
Then I use another select statement to populate the grid. And now the hot
keys do not work any more

Why?

Please help!

Rafael Copquin

______________________________**_________________
Post Messages to: [email protected]
Subscription Maintenance: 
http://mail.leafe.com/mailman/**listinfo/profox<http://mail.leafe.com/mailman/listinfo/profox>
OT-free version of this list: http://mail.leafe.com/mailman/**
listinfo/profoxtech <http://mail.leafe.com/mailman/listinfo/profoxtech>
Searchable Archive: 
http://leafe.com/archives/**search/profox<http://leafe.com/archives/search/profox>
This message: http://leafe.com/archives/**byMID/profox/52040320.1040005@**
fibertel.com.ar<http://leafe.com/archives/byMID/profox/[email protected]>
** 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.


--- StripMime Report -- processed MIME parts ---
multipart/alternative
   text/plain (text body -- kept)
   text/html
---

[excessive quoting removed by server]

_______________________________________________
Post Messages to: [email protected]
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/[email protected]
** 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.

Reply via email to