General information
Category:
Coding, syntax & commands
Hi Nick,
I think I answered my own question. After checking my code, it came to me, I only had one table SELECTED (Policy). I didn't
>Have the Client table open (SELECTED). so it couldn't get the client information FirstName Last Name into the report.
> So what I did was add the Client table after the SELECT POLICY, CLIENT. The Code is as following.
>
>SELECT * FROM Policy, Client ;
>WHERE policy.group_code==lcGroupCode ;
>AND policy.ins_co_name==lcIns_co_name ;
>INTO CURSOR myReport
>
>IF RECCOUNT("myReport") > 0
>Select myReport
>Report Form PAYMENT1 PREVIEW
>ELSE
>?? CHR(7)
>WAIT WINDOW "MATCH NOT FOUND, TRY AGAIN" TIME 2 NOWAIT
>ENDIF
>USE IN myReport
>thisform.text1.value=""
>thisform.text2.value=""
>thisform.refresh()
>thisform.text1.setFocus()
>
Does this look right ? or is there a better way of doing this ?
Happy john
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only