On Thu, 2007-09-06 at 16:19 +0200, Andreas Saeger wrote:
> Dinbandhu wrote:
> >
> > 1. How to change the name of an existing column?
> Example for given table "Table1" having field "ID" to be renamed to "ID_New"
> ALTER TABLE "Table1" ALTER COLUMN "ID" RENAME TO "ID_New"
ok, thanks.
> > 2. How
On Thu, 2007-09-06 at 15:13 +0200, Frank Schönheit - Sun Microsystems
Germany wrote:
> Hello Swarup,
>
> > I guess someone will be fixing the error in Base which requires the
> > above two options to be pursued.
>
> It is fixed in 2.3.
That's great. Is 2.3 released for general use yet? By all me
Dinbandhu wrote:
>
> 1. How to change the name of an existing column?
Example for given table "Table1" having field "ID" to be renamed to "ID_New"
ALTER TABLE "Table1" ALTER COLUMN "ID" RENAME TO "ID_New"
>
> I tried to double click on the column title window, but it doesn't give
> me a cursor to
Hello Swarup,
> I guess someone will be fixing the error in Base which requires the
> above two options to be pursued.
It is fixed in 2.3.
Ciao
Frank
--
- Frank Schönheit, Software Engineer [EMAIL PROTECTED] -
- Sun Microsystems http://www.sun.com/staroffice -
- Op
I sent the below message to this list yesterday, but it seems to have
become buried by the current discussion. I really need replies to the
below though. Without this, I can't do anything with my new table.
Thanks, S.
---
Now that my table is created and functi
Hello Frank,
On Thu, 2007-09-06 at 14:04 +0200, Frank Schönheit - Sun Microsystems
Germany wrote:
> Hello Swarup,
>
> >> If you say "Yes", the data in this column is lost. If you say "No",
> >> nothing happens, including the column not being altered.
> >
> > I see. So if I have no needs for that
Hello Drew,
On Thu, 2007-09-06 at 03:38 +, Drew wrote:
> Alright, just tried a little test on Ubuntu ( should be the same for any
> other platform also )
>
> Yes, if after you alter the pk columns in the tables to be IDENTITY you run
> SHUTDOWN SCRIPT or SHUTDOWN COMPACT in the sql window,
Hello Swarup,
>> If you say "Yes", the data in this column is lost. If you say "No",
>> nothing happens, including the column not being altered.
>
> I see. So if I have no needs for that PARTICULAR "ID" column which I
> had, then I could say "Yes" and the program will go ahead and remove my
> ID
On Thu, 2007-09-06 at 08:32 +0200, Frank Schönheit - Sun Microsystems
Germany wrote:
> Hello Swarup,
>
> > ok, but what should I do? Do I say "yes", or, "No"?
> >
> > What sort of "bug" is it? i.e. is the "bug" superficial, such that the
> > file will still work fine if I say yes, or is something