merry chrimbo one and all.... as for colour-of-objects selects.. yep the syntax is a pain... so why not use the excellent 'stylist' application from the equally excellent directionsmag tools & resources area
;-) r -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bill Thoen Sent: 23 December 2005 14:27 To: [email protected] Subject: Re: [MI-L] Fixes and New MapInfo Features On Fri, Dec 23, 2005 at 11:09:03AM +0100, Peter Horsbøll Møller wrote: > Seems that I didn't check my syntax before posting this statement to the > list, sorry for that. > > Here is the correct: > Select * From MYTABLE > Where Val(Str$(StyleAttr(ObjectInfo(OBJ, 3),2))) = RGB(0,0,255) > > Please note that this statement will only work on tables: > - contains only closed objects > - without records with no objects > > So to be sure you should start with these two statements: > Select * From MYTABLE Where OBJ INTO MYTABLE Kind of makes my point that it's not as simple as using pure SQL where the color of objects is an attribute in the data instead of being an embedded property of the project. The following is much easier: SELECT * FROM MYTABLE WHERE color = "blue" or SELECT * FROM MYTABLE WHERE color = 255 (depending how you code the field 'color') _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l ********************************************************************* This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. However, the information contained in this e-mail may subsequently be subject to public disclosure under the Freedom of Information Act 2000 and, unless the information is legally exempt from disclosure, the confidentiality of this e-mail and your reply cannot be guaranteed. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. http://www.bgs.ac.uk ********************************************************************* _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
