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 Paradis
Working for Technologies Softdesign inc.