OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

MySql: Foreign key of new created record in subform is 0

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
StefanR
Newbie
Newbie


Joined: 12 Feb 2006
Posts: 3

PostPosted: Sun Feb 12, 2006 12:21 pm    Post subject: MySql: Foreign key of new created record in subform is 0 Reply with quote

Hi,

my subform works fine. But if i create a new record in the subform OpenOffice inserts a record with 0 in the foreign key field. I'm sure that the subrecord is correctly connected to the masterform because the subform does only show the associated records.
In MySql 5 this results in a foreign key constraint error.

I tried with OpenOffice 2.0.1 and MySql 4.1 with Linux and MySql 5 with Windows and latest JDBC/ODBC connectors.

I found a thread here where someone else solved this problem by using another dbms, any other ideas?

Thanks!
Stefan
Back to top
View user's profile Send private message
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Sun Feb 12, 2006 1:13 pm    Post subject: Reply with quote

I was sure this was working...hmm..

I went back and tried again..from scratch..witn 2.0.1 and the latest developers build. Nope it isn't working...

Now, I need to run over the the other thread where i kept telling someone...oh, it works for me..and eat my hat..

EDIT

Well, I can't find the other thread...so if per chance the person that had created that thread reads this...well...what I said above.. Embarassed

Drew 'hmmm...this fedora sure tastes swella' Jensen
_________________
Blog - http://baseanswers.spaces.live.com/
Back to top
View user's profile Send private message Send e-mail Visit poster's website
StefanR
Newbie
Newbie


Joined: 12 Feb 2006
Posts: 3

PostPosted: Mon Feb 13, 2006 1:38 pm    Post subject: Reply with quote

I've found the other thread and posted a link to this new one:
http://www.oooforum.org/forum/viewtopic.phtml?p=122041
Back to top
View user's profile Send private message
paolOOo
General User
General User


Joined: 30 Jan 2006
Posts: 23
Location: Italy (near Milan)

PostPosted: Tue Feb 14, 2006 1:48 am    Post subject: Re: MySql: Foreign key of new created record in subform is 0 Reply with quote

StefanR wrote:
Hi,

I found a thread here where someone else solved this problem by using another dbms, any other ideas?

Thanks!
Stefan


Hi Stefan,

yes, I'm trying with sqlite, till now it's my best choice even if it leak of cuncurrency and access control.
I've also tried postgre and I've found the above problem disappear but I've found problems with the auto_increment_value in primary key.

bye
Paolo
_________________
Non ci sto capendo un ca##o!!!
Back to top
View user's profile Send private message MSN Messenger
paolOOo
General User
General User


Joined: 30 Jan 2006
Posts: 23
Location: Italy (near Milan)

PostPosted: Tue Feb 14, 2006 4:52 am    Post subject: Re: MySql: Foreign key of new created record in subform is 0 Reply with quote

paolOOo wrote:


I've also tried postgre and I've found the above problem disappear but I've found problems with the auto_increment_value in primary key.



And I've finished now also to try firebird with the same result (problems with primary key)

Bye
_________________
Non ci sto capendo un ca##o!!!
Back to top
View user's profile Send private message MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group