>Hey
>
>I want make a test in the command windows.
>
>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
If the other suggestions fail, you might try:
Select
Hold.*, .T. as "cFlag" from ... [include the quotation marks as well]
Mark McCasland
Midlothian, TX USA