Hi Daniel,
How about using commit() or setting up the connection instance as autoCommit ?
http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XConnection.html#commit
http://api.openoffice.org/docs/common/ref/com/sun/star/sdbc/XConnection.html#setAutoCommit
Alex
Hi Ocke, all,
- Peter Eberlein pet@refofd.verwalt-berlin.de a écrit :
Tested the download on Mac OSX SnowLeopard. Seems to work fine for me with the
Mysql connector 1.0.0.
Alex
P.S. One gripe that I do have is that although this installation overwrote my
previous OOo user settings,
Hi Ocke,
- Ocke Janssen ocke.jans...@oracle.com a écrit :
PS: We found an issue with select * from table where id in (
'll',OO')
The only way I can get this to run in that latest downloaded version is by
removing the single quotes around the values.
Alex
Hi Ocke,
- Ocke Janssen ocke.jans...@oracle.com a écrit :
I just have to set the issue to wontfix. :-(
The problem seems to be the database. Even with odbctest I get the
same
results = error and I tested a StarOffice 9.2 which is equal to OOo
3.2, same error as in OOo 3.2.1 and 3.3.
Hi Ocke,
- Ocke Janssen ocke.jans...@oracle.com a écrit :
As I mentioned, CAST works for me with OOo 3.2.1. It also works for
me in LibreOffice (just so you know 3.3 rc1, not sure which OOo_m that
is based on).
One more interesting thing
when executing
select CAST('2001-01-01' as
Hi Fernand,
Done, but whether it will make any difference ? Its not a blocker because it
doesn't cause a crash, or lose your data, but it is surely a regression from
3.2.
Alex
- Fernand Vanrie s...@pmgroup.be a écrit :
Alexander ,
It sould be good to send this message also to
Fernand,
Well I also use EXTRACT(), but have found that I still have to CAST the type.
If I just use the DATE/TIME functions on their own, the results are
inconsistent across the months, especially when adding or subtracting. I
haven't kept any of my old queries that did direct application of
Hi Fernand,
oStatement.setNull(1, ) for a textfield works fine ( =
long
SQLType others)
oStatement.setNull(2, ) for a timestamp returns 00-00-00
00:00:00 and not the Mysql (null)
i tried SQLtype 0 also with same results
Is this not a bug in that version (which one,
Hi,
Querying the V5R3 server, I see the expected results from the V5R3
server in both both Base (direct entry of SQL) and Calc (the Data
Source Browser and the spreadsheet). However, from the V5R2 server,
the three columns derived with char() show no useful information: in
the result of
Hi Christoph,
Hi,
I am looking for a way to use the postgres-sdbc module on darwin/mac
os x (if it supports kerberos authentication, which I assume since it
is using the postgresql client library, right?). However the packages
on
Congrats to both Drew and Zoltan in their respective new/continued roles !
Alex
-
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
lars.langh...@sun.com a écrit :
Hi Lars,
*Description*
-
It is possible to select BINARY, VARBINARY, LONGVARBINARY datatypes in
the Report Wizard. This will insert ImageControls instead of formatted
fields. The images will be set 4cm high. Pictures will scale down to
this size.
Emmanuel Charpentier a écrit :
Hi,
I have used the PostgreSQL SDBC driver for a while ...on x86 machines. I
currently use a new laptop with an Intel Core2 Duo. Consequently, I
installed Ubuntu Hardy amd64. This distribution has a
openoffice.org-sdbc-postgresql package, which is 0.7.5, and no
Joerg Budischewski a écrit :
Hi Joerg,
I'd like to announce the availability of the version 0.7.6 of the native
postgresql driver for OpenOffice.org for windows and linux x86.
What would it need to get it to work with Mac OSX (assuming that is at
all possible) ?
I have a Tiger OSX OOo Aqua
Christoph Lukasiak a écrit :
Hi Chris,
Unfortunately I shall be out of the office on travel all of that week,
so I can't count myself in this time. :-(
Alex
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
Bob Kline a écrit :
Hi Bob,
I'm having a number of problems with getting OpenOffice's Base to do
the right thing with this table, but the most frustrating is that when
I create a form based on the table, then go to insert a new row using
that form, I get an error message complaining that
Seale a écrit :
Hi Seale,
I just downloaded open office and just love it so far! I have been
wanting one system that works for everything so I am so glad to have
found you. I just bought an iMac in the last 4 months so I am trying
to get up to speed on it, but its address book is just not
Le Saturday 03 November 2007 21:22:48 Ariel Constenla-Haile, vous avez écrit :
Hi Ariel,
Can I change the status from UNCONFIRMED to NEW? I think we simple users
can not do this, am I wrong?
Well, this makes me think about what I did wrong with issue
On Wednesday 17 October 2007 07:29:31 Andrew Jensen wrote:
Hi Drew,
Darn MSAccess export files with booleans ( 0,1) and text fields can
looks like:
2145,0,0,0,1,Some text, and more text / all one field,0,0,2.15
That damned embedded comma..you know. Even better, this is a valid
export from
On Thursday 30 August 2007 04:04:12 Barbara Duprey wrote:
Hi Barbara,
Yes, I really, really want to go to 2.3, but the site is still
offering 2.2.1 as the latest stable release and I'm not sure a
development build is what I want. So I seem to have these choices:
stick with 2.0.4 until
On Wednesday 29 August 2007 15:53:22 Barbara Duprey wrote:
Hi Barbara,
When I was using the linked .dbf and this happened, I think it may be
why my data got so royally messed up. I suspect it was recovering by
using some data buffer it had hanging around, and with no primary key, I
believe
On Tuesday 21 August 2007 22:57:01 Frank Schönheit - Sun Microsystems Germany
wrote:
Hi Frank,
What I suppose the submitter of the issue ran into (unfortunately his
description wasn't clear here) is a NOT NULL field with a server-side
default - in this case, OOo wants to force him to enter
On Monday 20 August 2007 19:14:50 Barbara Duprey wrote:
One real problem, though -- I don't seem to be able to update from any
query with a join. The keys of both tables are in the data, and I'm only
trying to update in the Violations table. As long as I don't have a
join, no problem.
On Thursday 21 June 2007 01:32:54 Martin d'Anjou wrote:
Hi Martin,
I started using OO Base with ODBC and MySQL. It was slow to the point of
being unusable, and I almost gave up. However, I found that if I use the
IP address of the database server rather than the hostname, things go much
Le dimanche 20 mai 2007 00:MM, Marc Santhoff a écrit :
Hi,
But I'd be very pleased if someone would take the task of making XML
snippet format out of the posting (Alex?).
I can certainly have a look, but I've never used the snippet creator as yet,
probably for the same reasons as you ;-)
Le vendredi 18 mai 2007 18:MM, Marc Santhoff a écrit :
Marc,
It's Code-giving day today. ;)
You have saved me countless hours of trawling through the API, a huge thank
you
Please post any additions you make, not all possible cases are catched
by the code!
You're on !!
Alex
Hi Mike,
But MySQL does support relationships, so is this error mal formed?
Has this been solved and I'm doing something wrong in driver permissions?
Is there a workaround besides hard-coding updates by Macro or other?
Is there a solution planned in the future, if there is no present
Le samedi 28 avril 2007 20:MM, [EMAIL PROTECTED] a écrit :
Doh !!! Forget my last e-mail Mike, didn't look at the OP until after I sent
it - of course, you are one and the same. Sorry :-)
Alex
-
To unsubscribe, e-mail: [EMAIL
posta uno wrote:
Hi,
I have to create a database system and I’d like to use Open Office
insted of Microsoft Office.
For my Db I will have a Server,(probably Linux running on server), and
at least 10 Pc that must work in a network.They all will be linked to
server.
Same as in my office.
Hi all,
There is a very annoying, hmmm, well, I suppose you could call it a
feature, but I call it a bug ;-) when you install or upgrade OOo over a
previous installation.
This bug is that if you agree to having your data copied over (as do
most sane people who've carried out personal
Le mardi 02 août 2005 à 10:32 +0200, Frank Schönheit - Sun Microsystems
Germany a écrit :
Hi Frank,
How would a collaboration look like? OOo currently does not ship with
perl, nor does it have a UNO binding for perl [1], so how would OOo feed
your application with data? Are you interested in
Le mardi 02 août 2005 à 13:46 +0200, Frank Schönheit - Sun Microsystems
Germany a écrit :
Hi Frank,
Interesting. Do you know how they work? Do they create/manipulate the
mere files, or do they really connect to OOo and manipulate the docs by
using OOo?
AFAIK, they merely create/manipulate
Le lundi 14 février 2005 à 21:51 +1100, Justin Clift a écrit :
Hi all,
If I've come across a bug in OOo2 Base 680m77, and find an existing bug
for it in IZ (#42033) marked as RESOLVED/FIXED (680m75), does that means
it should be fixed already for m77 and I need to report it's still
Le jeudi 03 février 2005 à 08:22 +0100, Ocke Janssen a écrit :
I'm sorry. I haven't made a list of what Access can what hsqldb can't
and vice versa.
But if you want to make one, we would place them on our website :-) More
information about hsqldb can be found here www.hsqldb.org.
Well
34 matches
Mail list logo