Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simple Syntax help
Message
From
14/12/2006 10:38:20
 
 
To
14/12/2006 10:34:41
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01177599
Message ID:
01177603
Views:
7
Which line raises the error message?

>Hi,
>
>Any Ideas Why the code below is giving me a type mismatch error ? Thanx for any help recieved.
>
>Bobby
>
>
>LOCAL ldDate,liSitting
>
>ldDate=THISFORM.txtBox_date.VALUE
>liSitting=THISFORM.ccombobox1.VALUE
>
>SELECT ehrbt
>LOCATE
>SCAN FOR BETWEEN(ldDate,from_date,to_date) AND !EMPTY(lisitting)
>
> SELECT 0
> SELECT *;
> FROM ehrbb ;
> WHERE ehrbb.tableid=ehrbt.tableid .AND. ehrbb.sittingid=liSitting .AND. ehrbb.book_date=ldDate ;
> INTO CURSOR tmpBook
> IF _TALLY>0 && have booking
> MESSAGEBOX("Its working")
> THISFORM.clistbox1.ADDITEM(TRANSFORM(ehrbt.tableid))
> THISFORM.clistbox1.ADDLISTITEM(ehrbt.t_description,THISFORM.clistbox1.NEWITEMID,2)
> THISFORM.clistbox1.ADDLISTITEM(ehrbt.special_req,THISFORM.clistbox1.NEWITEMID,3)
> &&Thisform.Refresh
> ELSE
>
> MESSAGEBOX("Nothing There")
>
> ENDIF
>
> SELECT ehrbt
>ENDSCAN
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform