Hi,

At December 21, 2005, 5:39 AM, Cao Ancoinc wrote:

> 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

What are the plans for each one?

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)