Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filter on a table
Message
 
To
17/03/2004 14:50:15
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00887220
Message ID:
00887227
Views:
10
>I have a cursor in my data environment and i want to put a filter on it
>
>
>i want to add the following filter
>airline = aparameter
>reserved = .f.
>
>
>THISFORM.Dataenvironment.cursor1.filter = 'airline = "'+THIS.Param+'"' + ' '
>
>
>so i dont know how to put the second one
>
>
>thks

If reserved is a field in the table, the following would only retrieve the rows that are not reserved.
THISFORM.Dataenvironment.cursor1.filter = 'airline = "'+THIS.Param+'"' + ' AND NOT reserved'
George

Ubi caritas et amor, deus ibi est
Previous
Reply
Map
View

Click here to load this message in the networking platform