Re: MI Selecting using object type in an assorted table

[Ahmet Dabanli]

select * from table1 where str$(obj) = "point" into table1_points   is one step query   -----Original Message----- From: Andy <[EMAIL PROTECTED]> To: mapinfo mailing list <[EMAIL PROTECTED]> Date: 15 Temmuz 1999 Perşembe 15:25 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