>>I have the following SQL SELECT:
>>
>>

>>   SELECT a.client_num, a.NAME, a.DATE, a.price, a.client_src, ;
>>      b.ma_number AS ma_num, b.upin, b.dr_code AS drc, ;
>>      b.drv_code AS dvc, b.pr_author AS prior_auth, .T. AS SEND ;
>>      FROM ver a ;
>>         LEFT OUTER JOIN clients b ON a.client_num = B.client_num ;
>>      INTO ARRAY laWMA;
>>      WHERE ("WMA" $ a.client_src) ;
>>      AND (a.STATUS != "CXL") ;
>>      AND (a.STATUS != "NS") ;
>>      AND (NOT "C" $ a.meter) ;
>>      AND a.verified;
>>      AND NOT DELETED()
>>

>>
>>After these are selected, they are copied into another table and deleted from the original table.
>>
>>This will work fine for "a while" (the number of times isn't consistant, but it's low, like 2-5), then there will be nothing in the array, even though trips that pass the WHERE are verified. If I PACK the table, it starts working again. Any ideas why this would act that way?
>>
>>BTW - This SELECT has been working fine for months, and just started this pattern of not working after a few runs.
>>
>>-Michelle
>
>The DELETED() function is not reliable in SQL, because it reads from Current record of current alias.
>
>Best way os to just set DELETED ON before the query.

The deleted is on. I'm not sure why it's there. It's been so long since I wrote that SELECT, I just figured I had a reason for it and left it alone. :)

I'll try taking it out.

Thanks,

-Michelle