s e-mail in error, please notify us immediately by
return e-mail or telephone + 61 2 9955 7772 and destroy the original
message. Thank you."
-Original Message-
From: Andy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 15 July 1999 8:59
To: mapinfo mailing list
Subject: MI Selectin
1999 6:59 AM
> To: mapinfo mailing list
> Subject: MI Selecting using object type in an assorted table
>
>
> Imagine a table holding points, polylines and regions (polygons in the
> real world). Is there a one-stop method for sql selecting all the
> points, or all the lines e
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 a
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:25Subject: MI Selecting usi
://www.total.net/~rparis/gisproducts.htm
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of AndySent: July 15, 1999 6:59 AMTo:
mapinfo mailing listSubject: MI Selecting using object type in
Imagine a table holding points, polylines and
regions (polygons in the real world). Is there a one-stop method for sql
selecting all the points, or all the lines etc..
I can do it in a two-stop method; as
below;
Select id, obj from table1 into Selection
Browse * From Selection
and then;
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 > Maintena
