Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Test with sql
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00185305
Message ID:
00185307
Views:
17
You need to make sure that hold.date_prod, Date1, and Date2 are all the same type. If they're supposed to be dates, make sure you put the date in curly brackets like this: m.Date2={11/21/1999}.

>1) I open the table in my deta session
>2) I put a date in my var
>
>When i try this. Error Operator/operand typy mismatch
>
>3) SELECT *, .T. AS cFlag FROM hold WHERE between(hold.date_prod,
> Date1, ?Date2)AND !DELETED() INTO CURSOR tmpHold
>
>Where is my problem, behind the keyboard I know
>
>Pierre P
Previous
Reply
Map
View

Click here to load this message in the networking platform