Try an or instead of the and
Edit all from colorlist where colornum contains '123' or colornum contains
'456'
-------- Original Message --------
Subject: [RBASE-L] - Lost my code and my memory
From: "Dick Fey" <[EMAIL PROTECTED]>
Date: Wed, September 03, 2008 10:45 am
To: [email protected] (RBASE-L Mailing List)
Some years back I had code in one of my apps to do a specific search.
Seemed no-one was using it, so I deleted it. Now they want it back, and I
can't figure out how I did it in the first place. Seems like a simple
problem.
Need to find a product in the database where more than one color number
matches a product. Each color may exist in many products, but I want to see
the product(s) that have both colors.
ie:
Edit all from colorlist where colornum contains '123' and colornum contains
'456'
Anything I try gives me a syntax error, or a no rows exist error.
I know the rows are there, so its a syntax issue.
Suggestions appreciated.
Dick Fey
Carpet Broker Inc.
