Re: [dba-dev] Ghost records

2007-08-24 Thread Frank Schönheit - Sun Microsystems Germany
Hi Andrew, >> You might want to take into account what I just added to issue 69995 - >> basically, we all who we tampered with this issue overlooked the obvious >> - the table had a filter associated with it, thus it didn't display all >> records. If you remove this filter, the record count is per

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

2007-08-24 Thread Frank Schönheit - Sun Microsystems Germa ny
Hi Barbara, > About these bugs - do I need to upgrade to 2.2.1, or the latest > development 2.3, and see whether they exist there before documenting the > issues? That would be helpful. I don't think any of those issues already exists, but I might be wrong. In this case, you would save a few pe

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

2007-08-24 Thread Barbara Duprey
Frank Schönheit - Sun Microsystems Germany wrote: Hello Barbara, Thanks for the explanation, Frank. This modality is pretty confusing for somebody who's used to "update queries" from that other program! Maybe the doc should all make it clear that the Designer is only for SELECT commands

Re: [dba-dev] Ghost records

2007-08-24 Thread andrew
Frank Schönheit - Sun Microsystems Germany wrote: Hello Andrew, I'll open / update all these this weekend. You might want to take into account what I just added to issue 69995 - basically, we all who we tampered with this issue overlooked the obvious - the table had a filter associate

Re: [dba-dev] Ghost records

2007-08-24 Thread Frank Schönheit - Sun Microsystems Germany
Hello Andrew, > I'll open / update all these this weekend. You might want to take into account what I just added to issue 69995 - basically, we all who we tampered with this issue overlooked the obvious - the table had a filter associated with it, thus it didn't display all records. If you remove

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

2007-08-24 Thread Frank Schönheit - Sun Microsystems Germa ny
Hello Barbara, > Thanks for the explanation, Frank. This modality is pretty confusing for > somebody who's used to "update queries" from that other program! Maybe > the doc should all make it clear that the Designer is only for SELECT > commands (nothing else produces a result set, right?), and

Re: [dba-dev] Ghost records

2007-08-24 Thread andrew
Frank Schönheit - Sun Microsystems Germany wrote: Hi Andrew, Should I change the summary on the current Issue or close that one and open another? Please add your findings to the issue (and change the summary if appropriate) , I think it still describes pretty good what this all is abo

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

2007-08-24 Thread Marc Santhoff
Am Freitag, den 24.08.2007, 08:07 -0500 schrieb Barbara Duprey: > Should the addition of > leading and trailing blanks for copies from Writer be considered a bug, > or is changing that an RFE? http://www.openoffice.org/issues/show_bug.cgi?id=80916 and the other one you can omit: http://www.op

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

2007-08-24 Thread Barbara Duprey
Frank Schönheit - Sun Microsystems Germany wrote: Hello Barbara, When I tried this as a query, that didn't work either: SQL Status: 0 Error code: -155 Statement does not generate a result set Just as explanation, as you already found your way: This message says you executed t