Re: [dba-dev] Appending Data to a Table

2007-08-21 Thread andrew
Barbara Duprey wrote: andrew wrote: Barbara Duprey wrote: Ah, yes. I'd still prefer this to be done automatically when the data exceeded the field capacity, perhaps after verification that this is what's wanted, but I'm glad the new version will at least allow the redefinition without data d

Re: [dba-dev] Appending Data to a Table

2007-08-21 Thread andrew
Hi Barbara, I wasn't gong to send another email on this thread again tonight - but.since this one just arrived. I read over your earlier message, with the numbered issues a couple of times, and had a few more comments. Mostly dealing with some of the features for data exchange between Base /

Re: [dba-dev] Appending Data to a Table

2007-08-21 Thread Barbara Duprey
andrew wrote: Barbara Duprey wrote: I'd have thought that "VARCHAR" would automatically expand as needed up to at least 255, but it doesn't, and the field definitions cannot be modified in place. The option is presented to delete the field and append a new one as redefined, but that discards

Re: [dba-dev] Appending Data to a Table

2007-08-21 Thread Frank Schönheit - Sun Microsystems Germa ny
Hi Marc, > This is issue 80917. > ... > And this one is issue 80916 Thanks and thanks. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.op

Re: [dba-dev] Appending Data to a Table

2007-08-21 Thread Barbara Duprey
andrew wrote: Barbara Duprey wrote: (Comments in message) Yes, that was the specific question (let's call it Issue 1). In this case, it would be complicated by the fact that Base did not define the PK it generated for the original .dbf import as auto-increment. This one has a work arou

Re: [dba-dev] Appending Data to a Table

2007-08-21 Thread andrew
andrew wrote: I closed up SO8 and started up OOo2.3m_1 to check that copy paste to Calc again I can copy a range of cells in an Access dataview and paste them into a Calc sheet. I can not drag and drop a table object from Acess to a Calc sheet. -

Re: [dba-dev] Appending Data to a Table

2007-08-21 Thread andrew
Frank Schönheit - Sun Microsystems Germany wrote: Hi Barbara, Your idea sounds somewhat unusual for a database (in which situations, for instance, would you want to copy a rectangular portion to a location starting at another column? How often, really, does one have data where this makes sense?)

Re: [dba-dev] Appending Data to a Table

2007-08-21 Thread Marc Santhoff
Am Dienstag, den 21.08.2007, 04:15 +0200 schrieb Marc Santhoff: > > > Okay, missing first columns on copy and paste would be worth an issue > > > > Definitely. > > I'm in preparation of writing it. There seems to be an off-by-one error > somewhere in the pasting code, the first line is missing wh

Re: [dba-dev] Comments on Issue 80426

2007-08-21 Thread Frank Schönheit - Sun Microsystems Germany
Hi Andrew, > I wasn't sure whether to add these comments directly to the issue, or if > here might be a better spot. They could be moved. > > It seems to me that the crux of the issue is this: > > The need for for a rowset that can have certain fields flagged as display > only. > > The problem

Re: [dba-dev] Appending Data to a Table

2007-08-21 Thread andrew
Barbara Duprey wrote: I'd have thought that "VARCHAR" would automatically expand as needed up to at least 255, but it doesn't, and the field definitions cannot be modified in place. The option is presented to delete the field and append a new one as redefined, but that discards all the data. (I

Re: [dba-dev] Appending Data to a Table

2007-08-21 Thread andrew
Barbara Duprey wrote: (Comments in message) Yes, that was the specific question (let's call it Issue 1). In this case, it would be complicated by the fact that Base did not define the PK it generated for the original .dbf import as auto-increment. This one has a work around. If you drag

Re: [dba-dev] Appending Data to a Table

2007-08-21 Thread Barbara Duprey
(Comments in message) Frank Schönheit - Sun Microsystems Germany wrote: Hi Barbara, Are you (or is anybody else lurking here) aware of an issue for this? If not - Barbara or Marc, care to submit one? I mean, there should be a direct way, shouldn't it? I'd be glad to submit an issu

Re: [dba-dev] Ghost records

2007-08-21 Thread andrew
and one final interesting thing. I created a new database using StarOffice. Dragged the tables from the old database to the new empty one. In the new database I have a CheckOut table with - you guessed it. 109 records. All the data was restored. A feature? -

Re: [dba-dev] Ghost records

2007-08-21 Thread andrew
A quick follow up on this. I received this message from the user: "Well, I did have the system crash several times while I was experimenting with stuff. The weirdest problem I had was yesterday after I deleted some of the test data from the CheckOut table, and tried to e-mail the database to

[dba-dev] Ghost records

2007-08-21 Thread Andrew Jensen
I am running into a problem and curious if anyone has seen it. Received a Base database via email. The database file was created using OOo2.2 under MS Vista. In one particular table there are, what appear to be deleted records that do not show in a dataview window. They are not returned if one j

[dba-dev] Comments on Issue 80426

2007-08-21 Thread Andrew Jensen
Hi, I wasn't sure whether to add these comments directly to the issue, or if here might be a better spot. They could be moved. It seems to me that the crux of the issue is this: The need for for a rowset that can have certain fields flagged as display only. The problem with server side default