Hi Larry
Try using the IN operator
Select * from MyTab where Level in (3, 5, 7 ) and TYPE in ("Type 1", "Type
2", "Type 3", "Type 9")
Peter Laulund
National Survey and Cadastre, Denmark
"Larry Nolan" <[EMAIL PROTECTED]> - 24-08-99 14:14:40
Besvar venligst til "Larry Nolan" <[EMAIL PROTECTED]>
Til: "mapinfo mailing list" <[EMAIL PROTECTED]>
cc: (bcc: Peter Laulund/MI/KMS)
Vedrørende: MI Adding to a selection in mapbasic
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]
