Matt,
A simple precision first: objectinfo(obj,2) is not the object type (value is
1, not 2).
What you get with 2 is the symbol, text font or pen style of the object,
dependent on its type. The way the result is displayed is the printable
translation of the style contents. In fact the contents are "style
variables". To be able to get to it for comparison, you should create a
style variable (say: dim mypen as pen) and give it the contents you want
(mypen=makepen(1,2,65280) ) then you can use mypen in the SQL (where
str$(objecinfo(obj,2))=str$(mypen)) )
Jacques
Jacques PARIS
e-mail (>>>19.12.00) [EMAIL PROTECTED]
For MapInfo support, see the Paris PC Consult enr. site at
http://www.total.net/~rparis/gisproducts.htm
For MapBasic questions see the J.Paris site at
http://www.total.net/~jakesp/index.htm
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Matt Davey
Sent: January 15, 2001 11:09 AM
To: MI-L (E-mail)
Subject: MI-L SQL Query Query
Hi All
I have a table where I have updated a column to show the object type using
Str$ (ObjectInfo(Obj,2)). The result is either Pen (1, 2, 0) or Pen (1, 2,
65280) (black or green lines).
Just for fun I then ran a query "Select * from NSG_WDC where
Str$(objectinfo(obj,2))="Pen(1,2,65280)" into Greennsg" but this returns no
records. What's that all about?
Cheers
Matt Davey
Parkman
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
