-----Original Message-----
From: Larry Nolan <[EMAIL PROTECTED]>
To: mapinfo mailing list <[EMAIL PROTECTED]>
Date: Tuesday, August 24, 1999 17:34
Subject: MI Adding to a selection in mapbasic
Try this (I did not try, but I think it will work) :
select mycolumn from mytable
where mytable.mycolumn in(artefact1,artefact2,artefact3,.....,artefact20)
have a look in the mapbasic manual for the exact syntax for the "IN" clause
Kind regards,
Ton Brouwer
> I have a mapbasic application designed for a Archaeology excavation
>project where I need to be able to select artefacts from my tables based on
>level and artefact type for display.
> My problem is that I have about 50 different artefact types and about
10
>different levels. I tried to create a SQL query which listed all of the
>artefacts I wanted but mapinfo coughed saying the the SQL was too complex.
>It appears that there is maxium number of AND or OR operators you can have
>in the SQL query. So I split my SQL query into several querys with no more
>than 20 operators and then I cannot find a way to add to an existing
>selection except to use a couple of temporary tables and the Insert Into
>command. This works but is painfully slow.
>
> Does anyone know of a simple way to add to an existing selection?
>
>thanks
>
>Larry Nolan
>St. John's, Newfoundland, Canada
>
>voice (709) 729-2168
>email [EMAIL PROTECTED]
>
>
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]