>Hy
>
> It's my first sql question
>
>This is good
>SELECT *, .T. AS cFlag FROM hold WHERE !DELETED() INTO CURSOR tmpHold1
>?????????????
>But I want compare a field in the same select
>
>SELECT *, .T. AS cFlag FROM hold WHERE hold.data_prod >= &lcDate1;
> AND hold.data_prod <= &lcDate2;
> and !DELETED() INTO CURSOR tmpHold
>
>How can I do this
>
>Pierre P
>
>Thanks
Pierre --
If lcDate1 and lcDate2 are local variables, you don't need to use macro substitution (&).
Bill
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