OK, I'll add to the fray....Rather than try to attach a PDF (which I believe I couldn't do anyway)...I've placed an old archaic PDF document on our website that I composed for a User's Group meeting here in Phoenix, AZ years ago. It covers some of the lesser known things that you can do with SQL Select - including selecting by attribute.
http://www.analygis.com/downloads/SQL.pdf It's free, it's small. Have at it. - Ian Erickson ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "David R Sherrod" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, March 24, 2004 2:49 PM Subject: Re: MI-L MI-L: Integer attributes for ObjectInfo, following on Greg Phillips's kind summary > > > > > > I will put in a plug for Jacques Paris' books "MiniGuide to the MapBasic > Window" and " My (MI) Bag o'Tricks". They seem to capture everything > useful the manual left out. > > ____________ > Kent Treichel > Analyst-GIS > Tax Research > Minnesota Department of Revenue > MS 2230 > 600 North Robert St > St. Paul, MN 55146-2230 > 651-556-6150 > > > > > "David R Sherrod" <[EMAIL PROTECTED]> 03/24/2004 03:39 PM > > > > |--------------------------------------------------------------------------- --------------------------------------------------------+-> > | | | > | | | > | | | > | | | > | To:| | > | <[EMAIL PROTECTED]> | | > | cc:| | > | | | > | Subj:| | > | MI-L MI-L: Integer attributes for ObjectInfo, following on Greg Phillips's kind summary | | > | | | > | | | > | | | > | | | > | | | > | | | > |--------------------------------------------------------------------------- --------------------------------------------------------+-> > >---------------| > | | > >---------------| > > > > > > Greg's summary helps me immensely, owing to my limited programming skills > and vast ignorance. Namely, > > To capture the colour of polygons create a new 40 Character field in the > table and use Update Column with the following value > objectinfo(obj, 2) > This will return for example > Pen (2, 2, 16711680) (which is red) > Pen (2, 2, 65280) (which is green) > Pen (2, 2, 255) (which is blue > > I experimented a bit and determined that 2 is the integer attibute value > for pen, 3 for brush. Is there some way to find the list of all integer > attribute values needed for objectinfo's argument 2? I tried the RTFM > method first, to avoid wasting list time. But I come up empty handed. > > Sincerely, > David > -------------------------------------------- > David R. Sherrod, Hawaiian Volcano Observatory > U.S. Geological Survey, PO Box 51 > Hawaii National Park, HI 96718 > voice 808-967-8831 (me) > Obs. 808-967-7328 (everybody else) > fax 808-967-8890 > [EMAIL PROTECTED] > ----------------------------------------- > > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 11068 > > > (Embedded image moved to file: pic14018.jpg) > ---------------------------------------------------------------------------- ---- > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 11070 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11071
