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
