|Subject||RE: [firebird-support] Query does not return full result set|
> Hi AllYou're doing these from the same transaction? It looks like you've got
> It seems that I have an index problem
> Select * from Ostrip where DepotId='23' and InvNo='5016308'
> returns null
> Select * from Ostrip where DepotId='23' and PrnId='20' and
> returns the record
> Select * from Ostrip where InvNo='5016308' returns the record
> All queries should have returned at least the the same record
different data visible to different transactions.