Hello Marc,
>> After compacting, it is now 8.88 K
> This is what I was hoping for when I copied the table definitions and
> deleted the old tables. Would it make sense to add this as a menu option?
Yes. Not sure if there already is an issue requesting this, though.
Ciao
Frank
-
andrew wrote:
Marc Blakely wrote:
Drew, I've recently run into a similar situation with a database I'm
developing for work.
There are two tables which I import records into from a csv file via
Calc. I delete the previous records from each table prior to the
import (actually append, sinc
Hello Andre,
> we would love to see ldap support for form letters. is anyone working on
> this yet ?
>
> reference:
> http://dba.openoffice.org/development/projects.html#ldap
Nobody is working on this at the moment. The "we" in your sentence
suggests you're a corporate user, who is perhaps even
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
about. This sounds serious enough to have a deeper look into
Hello,
we would love to see ldap support for form letters. is anyone working on
this yet ?
reference:
http://dba.openoffice.org/development/projects.html#ldap
best regards
andré roth
Dreamlab Technologies AG
Monbijoustrasse 36
3011 Bern
Switzerland
Tel: +41 31 398 6
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 the statement in the query designer. The
designer is
Marc Blakely wrote:
Drew, I've recently run into a similar situation with a database I'm
developing for work.
There are two tables which I import records into from a csv file via
Calc. I delete the previous records from each table prior to the
import (actually append, since the structure d
andrew wrote:
Frank Schönheit - Sun Microsystems Germany wrote:
Hi Andrew,
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 just queries the single table.
But if one uses that table in a join, then the
andrew wrote:
Hmm. In the Execute SQL Statement dialog, I had
UPDATE "Addresses" SET ADDR = TRIM ( ADDR )
Hi Barbara,
I believe it was Mr Reagan that said - 'Trust but verify."
Out of the box HSQL has
LTRIM = Left Trim
RTRIM = Right Trim
But no TRIM... if you could see how hard I am l
Frank Schönheit - Sun Microsystems Germany wrote:
Hi Andrew,
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 just queries the single table.
But if one uses that table in a join, then they records are ret
Am Donnerstag, den 23.08.2007, 18:46 -0500 schrieb Barbara Duprey:
>
> Marc Santhoff wrote:
> > Am Donnerstag, den 23.08.2007, 16:42 -0500 schrieb Barbara Duprey:
> >
> >
> >> OK, I saw in the Help that only admin commands are allowed in the
> >> Execute SQL Statement dialog, so I created a qu
Hmm. In the Execute SQL Statement dialog, I had
UPDATE "Addresses" SET ADDR = TRIM ( ADDR )
Hi Barbara,
I believe it was Mr Reagan that said - 'Trust but verify."
Out of the box HSQL has
LTRIM = Left Trim
RTRIM = Right Trim
But no TRIM... if you could see how hard I am laughing right now
Marc Santhoff wrote:
Am Donnerstag, den 23.08.2007, 16:42 -0500 schrieb Barbara Duprey:
OK, I saw in the Help that only admin commands are allowed in the
Execute SQL Statement dialog, so I created a query. Same result, except
that the whole statement is there. So what token is it complain
Am Donnerstag, den 23.08.2007, 16:42 -0500 schrieb Barbara Duprey:
> OK, I saw in the Help that only admin commands are allowed in the
> Execute SQL Statement dialog, so I created a query. Same result, except
> that the whole statement is there. So what token is it complaining about?
>
> SQL St
Barbara Duprey wrote:
andrew wrote:
Barbara,
I sure don't feel preached at, just informed. Would you by any
chance know the SQL to remove leading and trailing blanks from
FIELDA in TABLEB? I'm sure it's all somewhere in there, but I can't
face that learning curve right now!
UPDATE TA
andrew wrote:
Barbara,
I sure don't feel preached at, just informed. Would you by any chance
know the SQL to remove leading and trailing blanks from FIELDA in
TABLEB? I'm sure it's all somewhere in there, but I can't face that
learning curve right now!
UPDATE TABLEB SET FIELDA = TRIM( F
Hello Xiaofei,
(I *really* hope I got the salutation right this time :). The habit in
this list - and all other OOo lists I know - is to address the oner
person with the first name, so I hope you don't mind.)
> Thanks very much for your reply, duyunfen has Fwded it to me, we have
> tracked the b
Hi Mr. Schönheit,
Thanks very much for your reply, duyunfen has Fwded it to me, we have
tracked the bug but the deadlock seem to occur somewhere among windows'
system processes, here is how the Call Stack looks at a point when the
phenomenon happens:
>user32.dll!77d191be()
user32
18 matches
Mail list logo