Jonathan Stokes wrote:
>
> >
> >here's an interesting one..
> >
> >am trying to pull out selected records from a rivers dataset. when i do
> >the query as follows ALL the records in the dataset are selected...
> >
> >Where Condition Name = "River Thames" Or "Thames"
> >
> >????
> >
> >am doing this in MI 4.5.2 WHY!!!!
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Try
Where Name = "River Thames" Or Name = "Thames"
instead.
The SQL engin cannot guess that the expression after OR also reflects on
Name.
Mats.E
--
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
:Email/ [EMAIL PROTECTED] ICQ#9517386 :
:---------------------------------------------------------------------:
:Mail/ GISKRAFT, Mats Elfstroem, Vaepplingv 21, SE-227 38 LUND, SWEDEN:
:Phones: +46 46 145959, +46 70 595 3935 :
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]