Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filtered records using grids
Message
From
07/03/2006 09:06:58
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01102016
Message ID:
01102048
Views:
18
Hi Neil

I'm guessing your lcAction variable went out of scope and maybe you have an error handler suppressing a possible warning.

Try this instead

>
>SELECT vwmactions
>lcaction = vwmactions.event
>
>SET FILTER TO event = &lcaction.
>LOCATE
>
>thisform.pageframe1.page1.grid1.Refresh()
>thisform.refresh()
>
>

As to coming at it the wrong way, I'd say you are. I strongly recommend you consider using SPT or cursor adaptors instead of SET FILTER. Set filter and grids are not a good combination - when the number of records displayed in the grid is very few of a large number of records in the table. SQL also let's you create cursors from multiple tables more easily than the corresponding SET RELATIONS/SET FILTER etc. Keep it in mind.
Previous
Reply
Map
View

Click here to load this message in the networking platform