Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filter clear
Message
From
16/10/2004 00:24:55
 
 
To
16/10/2004 00:18:12
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00951906
Message ID:
00951910
Views:
10
Mohammed,

You can also try this:
WITH ThisForm
   lcBillNo = .Text1.Value
   ldDateIn = .Text2.Value
ENDWITH

SELECT * FROM mstr INTO CURSOR temp WHERE BILLNO=lcBillNo AND DATEIN=lcDateIn

IF _TALLY <= 0
   MESSAGEBOX( "No records found!" )
ENDIF
Hope to help,

Dennis


>hi,
>thank you for reply.
>
>i mean new code do the same work(another way)
>
>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
>>
>
>
>
>thanks.
Previous
Reply
Map
View

Click here to load this message in the networking platform