Seems that prehaps it is not possible, but perhaps I can offer you some hope? Jacques, I cannot close it as there are likely to be changes that have nothing to do with this function and I can't expect the user to commit every time they use this function.
I noticed an interesting phenomena with this though that will not work for me, but it could help in some circumstances.
If you add a column to a selection from a table, then that column does not also appear in the base table, only in the selection.
So if you used
Select * from baseTable Into TempSel Add Column TempSel (NextDay Date) From TempSel Set To D_HARV_DATE + 1 ..... Close Table TempSel
You get rid of the column without actually closing the table, perhaps it never existed....
Unfortunately, I want to use those columns in a multi-table selection, and I have to use base tables, but perhaps this might be of use in some circumstances where you don't want to close the table.
R
On Wed, 29 Oct 2003 08:31:20 -0500, Jacques Paris <[EMAIL PROTECTED]> wrote:
There is a very interesting behaviour here. If you run that command, the
column is added and is visible in the browser. If you do nothing like a
"save as" or a "commit", it is not registered in the table structure (you
can modify it without a suggested save before doing it) and there does not
seem to be any pending edit because there is no "Revert table" available.
So the solution would be to close the table as suggested but disregarded.
However; if the changes are only related to the new column, they will simply
be dropped because not considered as pending.
Jacques Paris e-mail [EMAIL PROTECTED] MapBasic-MapInfo support http://www.paris-pc-gis.com
-----Original Message----- From: Uffe Kousgaard [mailto:[EMAIL PROTECTED] Sent: 29-Oct-03 07:43 To: [EMAIL PROTECTED] Subject: Re: MI-L drop column
I asked about the same some time ago (1 year or more). The conclusion was:
Not possible :-(
Regards Uffe
----- Original Message ----- From: "Robert Crossley" <[EMAIL PROTECTED]> To: "MapInfo List" <[EMAIL PROTECTED]> Sent: Wednesday, October 29, 2003 1:30 PM Subject: MI-L drop column
Add Column T_CONSIGNMENT (NextDay Date) From T_CONSIGNMENT Set To D_HARV_DATE + 1
Now I want to get rid of that column again. I know I can close the table
and reopen it, but there will be pending changes that I don't want to
decide whther to keep or not.
Alter Table Drop Nextday says the column does not exist.
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8935
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8940
--
Robert Crossley Agtrix P/L 9 Short St New Brighton 2483 Far Southern Queensland AUSTRALIA
153.549004 E 28.517344 S
P: 02 6680 1309 F: New Connection M: 0419 718 642 E: [EMAIL PROTECTED] W: www.agtrix.com W: www.wotzhere.com
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8942
