Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set filter to
Message
From
05/03/2005 04:43:34
 
 
To
04/03/2005 22:12:31
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00992643
Message ID:
00992976
Views:
29
>my code si show below:
>case thisform.combo1.value= type
> SELECT table1
> SET ORDER TO type
> var1=thisform.text1.value
> set filter to type=ALLTRIM(var1)
> thisform.list1.requery
>case....
>endcase
>
>is that anything wrong in my code?
>Thanks a lot!!

Ng,

the requery line not end at the line, it start at the line,
then the SET FILTER TO expression must to be public.

But, when you filter the active key,
uses SET KEY TO ( or RANGE ),
it store the value and then it have not the
public expression problem,
and it is the fastest solution.
  SELECT table1
  SET ORDER TO type
  SET KEY TO ALLTRIM(thisform.text1.value)
* with SET FILTER
*  var1=[']+ALLTRIM(thisform.text1.value)+[']
*  set filter to type=&var1

  thisform.list1.requery
  ....
Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform