Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filter clear
Message
From
17/10/2004 12:58:35
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
17/10/2004 02:57:20
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00951906
Message ID:
00952101
Views:
9
>hi ,
>thank you very much,
>
>if you have a time ,i need example to make this via mycode under .
>
>SELECT mstr
>LOCATE FOR BILLNO=THISFORM.TEXT1.VALUE .AND. DATEIN=THISFORM.TEXT2.VALUE
>IF FOUND()
>SET FILTER TO BILLNO=THISFORM.TEXT1.VALUE .AND. DATEIN=THISFORM.TEXT2.VALUE
>
>
LOCAL m.lnSelect, m.lcOldFilter, m.lcBillNo, m.lcDateIn
m.lnSelect = SELECT()
SELECT mstr
m.lcOldFilter = FILTER()
m.lcBillNo = THISFORM.TEXT1.VALUE && should be THISFORM.txtBillNo.Value
m.lcDateIn = THISFORM.TEXT2.VALUE && should be THISFORM.txtDateIn.Value
SET FILTER TO BILLNO=&lcBillNo. AND DATEIN=&lcDateIn.
LOCATE
IF NOT FOUND()
  SET FILTER TO &lcOldFilter.
ENDIF
SELECT (m.lnSelect)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform