Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to filter a Grid (BROWSE FOR id_user=123, but with G
Message
 
To
08/04/1998 04:43:16
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00090364
Message ID:
00090419
Views:
31
>I need to ask u a simple question
> 1) I need to filter a table for be used with a Grid, but without use SET FILTER (because is for a multiuser program)
> EXAMPLE: BROWSE FOR id_product=123
>
> *** I don't really need to filter the table, only I want to show the product 123 in the Grid
> ** How I do that?? May I use SELECT SQL??? Filtering Environment could affect the multiuser accessing to the open tables???
>
> 2) I need to know how to remove a control in a column.
> EXAMPLE: column/header1/text1,spinner,checkbox
> ====> How to remove spinner (for example) in the repor design
>
> THANKS FOR ALL, I'M WAITING YOUR MAIL.......:))))))))


Hi Christian,

1) You could use SQL-SELECT. The only caveat here is to remember that each time you requery the SQL the Grid.RowSource is lost and must be reset. IMHO, a preferable approach would be to use a parameratized view.

2) Put grid in edit mode. Change combobox in properties dialog to show column/header1/spinner. Single click in appropriate column in grid. Hit delete key. Spinner in gone. HTH
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform