Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ZAPping a table displayed in a grid
Message
From
10/03/2000 09:11:50
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00344045
Message ID:
00344138
Views:
26
Hi Ashley.

>> process to zap and then re-populate a table displayed in a grid on page 2 and then makes page 2 active.
The result was an empty grid display. <<

My standard method for changing the Contents of the grid's RecordSource is to either use a parameterized view and requery it when necessary or to use an updateable cursor and zap it when necessary like so (where csrCategory is the grid's RecordSource):

*** Rebuild the cursor used as the recordSource for the grid
SELECT csrCategory
ZAP
SELECT * FROM Categories WHERE Categories.Cat_No = Thisform.Cat_No ;
INTO CURSOR Temp NOFILTER
SELECT csrCategory
APPEND FROM DBF( 'Temp' )
USE IN Temp
GO TOP IN csrCategory
This.nRecNo = 1
This.Refresh()

I never have a problem doing it like this.

Marcia
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform