RE: MI Thanks for the QueryN suggestions

2000-04-06 Thread Leduc, Yannick

Hi Mick,

If the query is based on a SQL statement, the query can be saved in
the workspace. On the other hand, if the query is based on the user's
selection of elements, there is no way for the workspace to keep track of
the selection. So it can't be saved even if you give it a name.

If you want to actually save your manual selection, you have to find out
what condition will pinpoint the ones that interest you. Usually, you will
use the unique ID of the object and list them in the SQL statement:

Select * from your_table where ID in("001","323", "5435", "65313") into
My_selection

This way, the selection will be saved in the workspace. I'm aware that it
can be tedious to list more than ten items... in this case, you can use a
geographic component in your query, like a round buffer.

The secret is to be able to put words to your selection.

Good luck

-Message d'origine-
De : Mick [mailto:[EMAIL PROTECTED]]
Envoyé : 6 avril, 2000 10:56
À : [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]
Objet : Re: MI Thanks for the QueryN suggestions


Kirk

I'm a little confused, why can't you save a named query selection in a
workspace?

Cheers

Mick Saunders


- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 06, 2000 9:12 AM
Subject: MI Thanks for the QueryN suggestions


 Hello List,

 Thanks for all your input.  I was hoping to find a way to save a selection
 with a specific name within a MapInfo Workspace.  It seems the only way to
 rename a selection is through the Query menu and select all into a new
table
 name.  Because QueryN does not get saved in the Workspace, the new table
 name does not either.

 Thanks,

 Kirk
 --
 To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
 "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



RE: MI Thanks for the QueryN suggestions

2000-04-06 Thread Eberl,Christine [NCR]

Hi Guys...Sure you can save a manually selected set of items.  Clear the
cosmetics layer, make your manual selection, copy the selection,  paste into
cosmetics layer, then save it.  A bit round about but it works; let me know
if your particular job won't allow that

Cheers CHristine

phone: (819) 997 - 6082
fax:  (819) 953 - 6612
email:   [EMAIL PROTECTED]

Address: Christine Eberl 
  Migratory Birds Technician
  Canadian Wildlife Service
  100 Gamelin Blvd
   Hull, PQ
   K1A 0H3


-Original Message-
From: Leduc, Yannick [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 06, 2000 11:29 AM
To: 'Mick'
Cc: MapInfo-L (E-mail)
Subject: RE: MI Thanks for the QueryN suggestions


Hi Mick,

If the query is based on a SQL statement, the query can be saved in
the workspace. On the other hand, if the query is based on the user's
selection of elements, there is no way for the workspace to keep track of
the selection. So it can't be saved even if you give it a name.

If you want to actually save your manual selection, you have to find out
what condition will pinpoint the ones that interest you. Usually, you will
use the unique ID of the object and list them in the SQL statement:

Select * from your_table where ID in("001","323", "5435", "65313") into
My_selection

This way, the selection will be saved in the workspace. I'm aware that it
can be tedious to list more than ten items... in this case, you can use a
geographic component in your query, like a round buffer.

The secret is to be able to put words to your selection.

Good luck

-Message d'origine-
De : Mick [mailto:[EMAIL PROTECTED]]
Envoyé : 6 avril, 2000 10:56
À : [EMAIL PROTECTED]
Cc : [EMAIL PROTECTED]
Objet : Re: MI Thanks for the QueryN suggestions


Kirk

I'm a little confused, why can't you save a named query selection in a
workspace?

Cheers

Mick Saunders


- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 06, 2000 9:12 AM
Subject: MI Thanks for the QueryN suggestions


 Hello List,

 Thanks for all your input.  I was hoping to find a way to save a selection
 with a specific name within a MapInfo Workspace.  It seems the only way to
 rename a selection is through the Query menu and select all into a new
table
 name.  Because QueryN does not get saved in the Workspace, the new table
 name does not either.

 Thanks,

 Kirk
 --
 To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
 "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]