Re: MI Adding to a selection in mapbasic
-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]
Vedr: MI Adding to a selection in mapbasic
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]
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]
