Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Checkbox Control in Grid
Message
From
08/02/2002 08:34:46
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00616905
Message ID:
00617237
Views:
45
Hi David.

When you ZAP the table you are ripping the table out from under the grid and it self destructs (loses all of the columns) and then it rebuilds itself. When it does this it reconstructs with itself with the default VFP controls.

Sorry, but you are mistaken here. This is a technique that I use all the time and I call a "safe select". Zapping the grid's RecordSOurce does not close it. So I use code like this all the time with no problem whatsoever:
*** Rebuild the cursor used as the recordSource for the grid
SELECT csrCategory
ZAP
SELECT * FROM Categories WHERE Categories.Cat_No = This.Parent.cboSections.Value ;
	INTO CURSOR Temp NOFILTER
SELECT csrCategory
APPEND FROM DBF( 'Temp' )
USE IN Temp
GO TOP IN csrCategory
This.nRecNo = 1
This.Refresh()
OTOH, Packing the grid's RecordSource does close the table and rip the grid's RecordSOurce out from under it.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform