Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Grid Control Record Source
Message
From
15/01/1999 16:07:13
 
 
To
15/01/1999 16:02:57
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00176700
Message ID:
00176707
Views:
23
>I want to display a grid on a form, with records that only meet certain standards. I've tried setting the record source type property of the grid control to 3-query and 4-SQL statement, and specified the appropriate path to the query or the SQL statement in the grid's record source property. My grid is always empty. What am I doing wrong?

Firstly, base your grid on cursor (another possibility is to base it on p-view). Then repopulate this cursor anytime you change your criteria values. Note, that repopulating the cursor should be done carefully like this:
Select MyGridCursor
ZAP
Select ... Where (your criterea here) Into Cursor tmp NOFILTER
cDbf=dbf()
Select MyGridCursor
Append From (cDbf)
Thisform.Grid.Refresh
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform