Hi John,
I created a table called payment with an ins_co_name and added acouple records. Threw a text box and a button on a form. I put the following in the click event of the button:
local cCoName
cCoName = THISFORM.textbox1.VALUE
SELECT * FROM PAYMENT ;
WHERE ins_co_name = cCoName ;
INTO CURSOR Mycursor
IF _TALLY != 0
WAIT WIND 'got some records'
ELSE
WAIT WIND 'nothing there'
ENDIF
Note: What is entered in the text box has to match what's in the field as far as case.
>Roi,
>
>Could you give me the me another example just useing a single table ?
>> the table is payment.ins_co_name <
>> the form is search1 <
>> I want the user to be able to enter data in the form.textbox1 <
>> and have it relate to the table payment.ins_co_name <
>> and output to a report <
>> if data found .t. <
>> wait 'Data found will now print ' <
>> report form to preview <
>> Else <
>> Wait 'No data found '
>> Return <
>
>> Please one more time <
>> John <
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!