Nigel Weeks wrote:

>>Hi All
>> It seems that I have an index problem
>>
>> Select * from Ostrip where DepotId='23' and InvNo='5016308'
>>returns null
>>
>> however
>>
>> Select * from Ostrip where DepotId='23' and PrnId='20' and
>>InvNo='5016308'
>>returns the record
>>
>> and
>>
>> Select * from Ostrip where InvNo='5016308' returns the record
>>
>> All queries should have returned at least the the same record
>>
>>
>>
>
>You're doing these from the same transaction? It looks like you've got
>different data visible to different transactions.
>
>N.
>
>

or a corrupted index ?

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br