Article ID: 156733
Article Last Modified on 10/15/2003
x='"' + ALLTRIM(ThisForm.Text2.Value) + '"' SET FILTER TO &x $ Test.cfield1 BROWSE
- or-
x='"' + ALLTRIM(ThisForm.Text2.Value) + '"' BROWSE FOR &x $ Test.cfield1When you define the variable x in this example, a pair of single quotation mark characters (') enclose a double quotation mark character (").
CREATE TABLE test (cfield1 c(10))
INSERT INTO test (cfield1) VALUES ("a")
INSERT INTO test (cfield1) VALUES ("a")
INSERT INTO test (cfield1) VALUES ("b")
INSERT INTO test (cfield1) VALUES ("b")
SET FILTER TO ALLTRIM(Thisform.Text2.Value) $ Test.cfield1 BROWSEYou could also use the following line of code:
BROWSE FOR ALLTRIM(ThisForm.Text2.Value) $ Test.cfield1
Additional query words: kbdsd VFoxWin
Keywords: KB156733