Vedr: MI Multi select
Hi David just type this in the mapbasic window Select * from MyTab where MyColm in (4,5,12,13, 14, etc. ) Peter Laulund National Survey and Cadastre, Denmark "David Eagle" <[EMAIL PROTECTED]> - 2000 06 15 10:43:48 Til:[EMAIL PROTECTED] cc: (bcc: Peter Laulund/MI/KMS) Vedrørende: MI Multi select This is a very simple query select but I can't work out how to do it! I have a column which has a code within it refering to mode of transport...I want to select all the records that equal codes 4,5,12,13 & 14...(These represent cars (with different no.s of passengers and mcycles)). I can select them individually with: column = 14 but have tried numerous ways of multi selecting to no avail...Can someone please solve this simple but annoying problem for me... TIA, Dave _ David A. Eagle WS Atkins Consultants - East Anglia Wellbrook Court, Girton Road, Cambridge, CB3 0NA. Direct Dial Tel: (01223) 814090, Fax: (01223) 277529 E-Mail: [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 Multi select SUM
Thanks guys...3 replies and 3 slightly different ways to do it! I couldn't quite get Toms to work though, it wasn't having it at all... Anyway, thank you! Question: This is a very simple query select but I can't work out how to do it! I have a column which has a code within it refering to mode of transport...I want to select all the records that equal codes 4,5,12,13 & 14...(These represent cars (with different no.s of passengers and mcycles)). I can select them individually with: column = 14 but have tried numerous ways of multi selecting to no avail...Can someone please solve this simple but annoying problem for me... TIA, Dave Answers: From: PERRY Chris<[EMAIL PROTECTED]> To: "'David Eagle'" <[EMAIL PROTECTED]> Subject:RE: MI Multi select Date sent: Thu, 15 Jun 2000 20:28:13 +1000 David, the key here is the word ANY... Try: column=any(4,5,12,13,14) From: "laurentFrilleux"<[EMAIL PROTECTED]> To: "David Eagle" <[EMAIL PROTECTED]> Subject:Re: MI Multi select Date sent: Thu, 15 Jun 2000 12:20:16 +0100 hello try to select your code by select code =4 or code = 5 or code= From: Tom Manson <[EMAIL PROTECTED]> To: "'David Eagle'" <[EMAIL PROTECTED]> Subject:RE: MI Multi select Date sent: Thu, 15 Jun 2000 11:39:16 +0100 Try this: column like any(2,3,14,etc) I've only done this with character fields, but integer should also work. Tom _ David A. Eagle WS Atkins Consultants - East Anglia Wellbrook Court, Girton Road, Cambridge, CB3 0NA. Direct Dial Tel: (01223) 814090, Fax: (01223) 277529 E-Mail: [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 Multi select
This is a very simple query select but I can't work out how to do it! I have a column which has a code within it refering to mode of transport...I want to select all the records that equal codes 4,5,12,13 & 14...(These represent cars (with different no.s of passengers and mcycles)). I can select them individually with: column = 14 but have tried numerous ways of multi selecting to no avail...Can someone please solve this simple but annoying problem for me... TIA, Dave _ David A. Eagle WS Atkins Consultants - East Anglia Wellbrook Court, Girton Road, Cambridge, CB3 0NA. Direct Dial Tel: (01223) 814090, Fax: (01223) 277529 E-Mail: [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]