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]