select * from table1
where str$(obj) = "point"
into table1_points
is one step query
-----Original Message-----
To: mapinfo mailing list <[EMAIL PROTECTED]>
Date: 15 Temmuz 1999 Perşembe 15:25
Subject: MI Selecting using object type in an assorted table

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

Reply via email to