Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by richlp
-
How to compose a SELECT() UDF
Try making the UDF a custom method on the form and call it with SELECT field1 FROM Mytable WHERE Thisform.MyTest(TRIM(field2),lcNwrd) .......Rich- richlp
- Post #4
- Forum: Microsoft: FoxPro
-
How to compose a SELECT() UDF
I'm not sure I understand the rules you need to enforce, so here is my guess. 1. If lcNwrd does NOT contain a question mark then select the record if Field2 matches any arrangement of the letters in lcNwrd - that is lcNwrd Acceptable Values 'aak' 'aak', 'aka', 'kaa' 'abc'...- richlp
- Post #2
- Forum: Microsoft: FoxPro
-
calcuation question
You might also try putting a 0 (zero) in the value property for the test box. I think this sets the value to numeric without a control source. .....Rich- richlp
- Post #4
- Forum: Microsoft: FoxPro
