There were three recs that were marked for deletion (all with fcCurId = "DUH"). After packing the table, the function seemed to work fine. How would that cause this problem?
>>No there are no filters and the table has one index: UPPER(fcCurID) FOR .NOT. DELETED()
>>
>>>>Thanks in advance,
>>>
>>>How is the table ordered?
>>>
>>>Is there any filters on the table?
>
>Your sure that one record is not deleted?
Ronald Suen
Epic Information Solutions Inc.
Ph: (780) 488-4418
Fax: (780) 488-0402