Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-11 Thread Marc Santhoff
Coming back lately ... Am Montag, den 03.09.2007, 06:34 +0200 schrieb Marc Santhoff: > Am Sonntag, den 02.09.2007, 19:36 +0200 schrieb Andreas Saeger: > > Marc Santhoff wrote: > > > > > > The thread on [EMAIL PROTECTED] is quite long and verbose, it's hard to > > > find the > > > core informati

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-09 Thread Dinbandhu
On Sun, 2007-09-09 at 20:00 +0100, John McCreesh wrote: > On Sat, 2007-09-08 at 08:02 -0400, Dinbandhu wrote: > > On Sat, 2007-09-08 at 09:01 +0100, John McCreesh wrote: > > > On Fri, 2007-09-07 at 21:13 -0400, Dinbandhu wrote: > > > [snip] > > > > If 2.3 is available, then how do I get it? > > >

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-09 Thread John McCreesh
On Sat, 2007-09-08 at 08:02 -0400, Dinbandhu wrote: > On Sat, 2007-09-08 at 09:01 +0100, John McCreesh wrote: > > On Fri, 2007-09-07 at 21:13 -0400, Dinbandhu wrote: > > [snip] > > > If 2.3 is available, then how do I get it? > > > > Go to http://download.openoffice.org/ and click on "Help us test

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-08 Thread Dinbandhu
On Sat, 2007-09-08 at 09:01 +0100, John McCreesh wrote: > On Fri, 2007-09-07 at 21:13 -0400, Dinbandhu wrote: > [snip] > > If 2.3 is available, then how do I get it? > > Go to http://download.openoffice.org/ and click on "Help us testing". > But read what it says on the next page: "The software is

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-08 Thread Dinbandhu
On Sat, 2007-09-08 at 05:36 +, Drew wrote: > >I see. That is interesting. Does that apply to adding data to the > table > >too? Or just to making changes in the table format/structure? > > > Yes, the table grid in the form lets you add data, edit or delete data > same as you would in the data v

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-08 Thread John McCreesh
On Fri, 2007-09-07 at 21:13 -0400, Dinbandhu wrote: [snip] > If 2.3 is available, then how do I get it? Go to http://download.openoffice.org/ and click on "Help us testing". But read what it says on the next page: "The software is not recommended for production deployment at this stage. There are

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-07 Thread Drew
>I see. That is interesting. Does that apply to adding data to the table >too? Or just to making changes in the table format/structure? > Yes, the table grid in the form lets you add data, edit or delete data same as you would in the data view window. It also allows you to easily add such things

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-07 Thread Dinbandhu
On Sat, 2007-09-08 at 02:02 +, Drew wrote: > Hi Swarup, > > >> > 2. How to add a column? > >> > > >> > 3. How to move a column from one location to another? > >> > > >> Simply don't. The order of columns is not relevant. > > > >For me, it is helpful to be able to do so. Because: > > > >1

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-07 Thread Drew
Hi Swarup, >> > 2. How to add a column? >> > >> > 3. How to move a column from one location to another? >> > >> Simply don't. The order of columns is not relevant. > >For me, it is helpful to be able to do so. Because: > >1. The columns in my Base table are not at all in the order they were in >in

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-07 Thread Dinbandhu
Hello, Posted the below yesterday, but no reply. I'd be very interested in getting confirmation re some of the specific questions as well as hearing thoughts about the general comments at the end. Please use the copy below to go through, as I've reworded quite a bit for clarity and removed certain

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-07 Thread Dinbandhu
Hello, Sent out the below yesterday. Anyone know the answer? 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

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-06 Thread Dinbandhu
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

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-06 Thread Dinbandhu
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

[dba-dev] Re: problems importing MSA files into OO Base

2007-09-06 Thread Andreas Saeger
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

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-06 Thread Frank Schönheit - Sun Microsystems Germany
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

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-06 Thread Dinbandhu
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

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-06 Thread Dinbandhu
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

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-06 Thread Dinbandhu
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,

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-06 Thread Frank Schönheit - Sun Microsystems Germany
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

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-06 Thread Dinbandhu
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

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-05 Thread Frank Schönheit - Sun Microsystems Germa ny
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 going to go > seriously wrong? > > How does one manage the situation in view of the bug. If

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-05 Thread Drew
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, close Base and reopen it everything works just fine. One final comme

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-05 Thread Dinbandhu
Hello Drew, On Wed, 2007-09-05 at 23:38 +, Drew wrote: > >> I don't read the whole thread > >> > > >> > I did that, and when I clicked on "save" to close the edit view of the > >> > table, I received a warning message: > >> > > >> > "Warning! The column "ID" could not be changed. Should the

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-05 Thread Drew
>> I don't read the whole thread >> > >> > I did that, and when I clicked on "save" to close the edit view of the >> > table, I received a warning message: >> > >> > "Warning! The column "ID" could not be changed. Should the column >> > instead be deleted and the new format appended?" >> > >>

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-05 Thread Dinbandhu
On Wed, 2007-09-05 at 23:23 +0200, Mechtilde wrote: > Hello, > > Dinbandhu schrieb: > > On Wed, 2007-09-05 at 22:43 +0200, Andreas Saeger wrote: > >> Dinbandhu wrote: > I don't read the whole thread > > > > I did that, and when I clicked on "save" to close the edit view of the > > table, I receiv

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-05 Thread Mechtilde
Hello, Dinbandhu schrieb: > On Wed, 2007-09-05 at 22:43 +0200, Andreas Saeger wrote: >> Dinbandhu wrote: I don't read the whole thread > > I did that, and when I clicked on "save" to close the edit view of the > table, I received a warning message: > > "Warning! The column "ID" could not be cha

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-05 Thread Dinbandhu
On Wed, 2007-09-05 at 22:43 +0200, Andreas Saeger wrote: > Dinbandhu wrote: > > On Wed, 2007-09-05 at 18:23 +0200, Andreas Saeger wrote: > >> Swarup, > >> Please notice the P.S. at the bottom before you continue. > > > > I've got success. The database is created, it has all the correct data > > in

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-05 Thread Dinbandhu
Now that my table is created and functional, I have some basic user questions: 1. How to change the name of an existing column? I tried to double click on the column title window, but it doesn't give me a cursor to change the name. 2. How to add a column? I cannot find anywhere command for "in

[dba-dev] Re: problems importing MSA files into OO Base

2007-09-05 Thread Andreas Saeger
Dinbandhu wrote: > On Wed, 2007-09-05 at 18:23 +0200, Andreas Saeger wrote: >> Swarup, >> Please notice the P.S. at the bottom before you continue. > > I've got success. The database is created, it has all the correct data > in it, and it is fully editable. > > Using the guidelines you've given i

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-05 Thread Dinbandhu
On Wed, 2007-09-05 at 18:23 +0200, Andreas Saeger wrote: > Swarup, > Please notice the P.S. at the bottom before you continue. I've got success. The database is created, it has all the correct data in it, and it is fully editable. Using the guidelines you've given in this current letter about how

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-05 Thread Drew
t: [dba-dev] Re: problems importing MSA files into OO Base > >Marc Santhoff wrote: >> >> I wonder if this difficulties are >> - a special problem using ubuntu >> - only occur when copying from .mdb >> - or are similar when using other database types >> >>

[dba-dev] Re: problems importing MSA files into OO Base

2007-09-05 Thread Andreas Saeger
Marc Santhoff wrote: > > I wonder if this difficulties are > - a special problem using ubuntu > - only occur when copying from .mdb > - or are similar when using other database types > > Anyone having similar experiences not using an access database? > > Marc Hi Marc, Just a quick and dirty out

[dba-dev] Re: problems importing MSA files into OO Base

2007-09-05 Thread Andreas Saeger
Swarup, Please notice the P.S. at the bottom before you continue. Dinbandhu wrote: > [...] > Hi Andreas, > [...] > 1. I think I was able to understand and follow each step of your > instructions. And in the end, the table was made. Indeed, all the > columns and rows are there, correctly labeled. A

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-04 Thread Dinbandhu
On Fri, 2007-08-31 at 21:38 +0200, Andreas Saeger wrote: > Hello, Swarup > I've added a detailed step-by-step instruction how to import mdb via > spreadsheet to Base. Have a look at the users.dba list and give a try. > > Good luck, > Andreas Hi Andreas, I tried doing the How-To you wrote in the u

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-04 Thread Dinbandhu
On Sun, 2007-09-02 at 19:36 +0200, Andreas Saeger wrote: > Marc Santhoff wrote: > > > > The thread on [EMAIL PROTECTED] is quite long and verbose, it's hard to > > find the > > core information there. > > > > Marc > > Swarup uses Ubuntu and it is quite difficult to transfer data from a > read-o

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-09-02 Thread Marc Santhoff
Am Sonntag, den 02.09.2007, 19:36 +0200 schrieb Andreas Saeger: > Marc Santhoff wrote: > > > > The thread on [EMAIL PROTECTED] is quite long and verbose, it's hard to > > find the > > core information there. > > > > Marc > > Swarup uses Ubuntu and it is quite difficult to transfer data from a >

[dba-dev] Re: problems importing MSA files into OO Base

2007-09-02 Thread Andreas Saeger
Marc Santhoff wrote: > > The thread on [EMAIL PROTECTED] is quite long and verbose, it's hard to find > the > core information there. > > Marc Swarup uses Ubuntu and it is quite difficult to transfer data from a read-only mdb datasource to a native hsqldb datasource. He encounters problems with

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-08-31 Thread Dinbandhu
On Sat, 2007-09-01 at 01:15 +0200, Andreas Saeger wrote: > Swarup, > I'm not a developer, so I can hardly tell if things have to be like > that. I believe that Base has started too late. Until now it is the > least mature component in this office suite, although a rock stable, > reliable database c

[dba-dev] Re: problems importing MSA files into OO Base

2007-08-31 Thread Andreas Saeger
Swarup, I'm not a developer, so I can hardly tell if things have to be like that. I believe that Base has started too late. Until now it is the least mature component in this office suite, although a rock stable, reliable database could be the most attractive component to serve all other components

Re: [dba-dev] Re: problems importing MSA files into OO Base

2007-08-31 Thread Dinbandhu
On Fri, 2007-08-31 at 21:38 +0200, Andreas Saeger wrote: > Hello, Swarup > I've added a detailed step-by-step instruction how to import mdb via > spreadsheet to Base. Have a look at the users.dba list and give a try. > Many thanks, Andreas, for your detailed instructions. I have read through them

[dba-dev] Re: problems importing MSA files into OO Base

2007-08-31 Thread Andreas Saeger
Hello, Swarup I've added a detailed step-by-step instruction how to import mdb via spreadsheet to Base. Have a look at the users.dba list and give a try. Good luck, Andreas - To unsubscribe, e-mail: [EMAIL PROTECTED] For addition