Andy & others
You can by using the Str$( ) wrapper around the objectinfo command. You
need to substitute the MapBasic.Def codes (which I've included at the
bottom)
eg. For points
Select * from <TABLE> where Str$(ObjectInfo(obj,1)) = "5" into RESULTS
The number after obj stands for the Mapbasic equivalent of
OBJ_INFO_TYPE, while the number 5 in quotes stands for points which you
may freely substitue with other objects - see table below.
OBJ_TYPE_ARC 1
OBJ_TYPE_ELLIPSE 2
OBJ_TYPE_LINE 3
OBJ_TYPE_PLINE 4
OBJ_TYPE_POINT 5
OBJ_TYPE_FRAME 6
OBJ_TYPE_REGION 7
OBJ_TYPE_RECT 8
OBJ_TYPE_ROUNDRECT 9
OBJ_TYPE_TEXT 10
This should help -one of the tricks of the trade.
Cheers
Mike
_______________________
Mike Eden
Senior Technical Services Manager
RSK Environment (UK) Ltd.
+44 (0)1928 726006
<mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: Andy [mailto:[EMAIL PROTECTED]]
Sent: 15 July 1999 12:13
To: mapinfo mailing list
Subject: MI Selecting using object type in an assorted table
Sorry,
a minor correction to my posting.
we had to save a copy of the table between the two SQL commands. the
first query produces a column called 'Object'. But this cannot be
queried successfully - until the save. Reopening the saved table, and
examining the contents under Table > Maintenance the column is now a
char field and is called '_Object'. It is this field that can now be
queried.
So it's a three or four step method now..
But why can't i query the obj directly?
Andrew Bailey
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]