The explanations are not very obvious. First with Noselect "the statement
performs a query without changing the pre-existing selection table". But it
also says that "the query does not trigger the SelChangedHandler procedure"
which means that the objects selected that way do not show selected on the
original map/browser.
Do the following experiment:
select * from your_tab where ... into sel1
browse * from sel1
you see a list of selected records
select * from your_tab where ... into sel2 noselect
browse from sel2
you see a list of the records matching the where selection but that are not
"selected". If you were to do it using the same into name, you will get the
eauivalent of sel2, that is not "selected" records.
My conclusion is that if you want to add records to an already existing
selection using you multiple select approach, you will have to append the
records from sel2 to sel1, but you can do it only by committing at least
sel1 as a base table, and thus you cannot expect appending directly to a
selection.
And I would love to be contradicted!!!
Jacques Paris
e-mail [EMAIL PROTECTED]
MapInfo/MapBasic support http://www.paris-pc-gis.com
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Birgit
M�ller
Sent: November 30, 2001 10:50
To: '[EMAIL PROTECTED]'
Subject: MI-L Select statement
Hi,
I try to create a select statement, where the always selected objects will
stay in my Selection. So I just want to add more objects with my second
select statement to the old selection.
I tried it with two select statements
1) Select * from table where Columnname = "string" into Birgit
2) Select * from table where Columnname = "string" into Birgit noselect
But - it doesn't work!!!
Can anyone help me? How can I create the statements?
Thanks
Birgit
--
Dipl.-Geogr. Birgit M�ller
Momatec GmbH
Weiern 167
52078 Aachen
home: http://www.momatec.de
email: [EMAIL PROTECTED]
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
