OR in WHERE

[keatk at comcast.net]

> 
> Not works OR for fields that are in different tables.

THAT IS A MAJOR BUG ... SQL spec has no such limitation and OR across tables is common in anything more than a simple databse ...  and it has bitten me... and it does not even produce an error which makes it worst!

- karen


> On 5/20/04 6:59 PM, "Scott Runkel" <srunkel at hypix.com> wrote:
> 
> >> Valentina is a very good product, the bug with OR in WHERE not working
> >> is very significant.  I need to understand both a theory and a method
> >> for a work around of the OR bug.
> > 
> > Sorry if I missed something, but could you possibly summarize the bug? Basic
> > use of OR seems to work fine for me. I say "seems to" since it's hard to tell
> > when > I have no other method of searching my database. When I search for two
> > words with AND I get a small number of results, when I use OR I get many more.
> 
> 
> OF for fields that are from the same table works.
> 
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
> 
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina