| View previous topic :: View next topic |
| Author |
Message |
StefanR
Newbie
Joined: 12 Feb 2006
Posts: 3
|
 Posted: Sun Feb 12, 2006 12:21 pm Post subject: MySql: Foreign key of new created record in subform is 0 |
 |
|
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 |
|
 |
DrewJensen
Super User
Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD
|
| Posted: Sun Feb 12, 2006 1:13 pm Post subject: |
|
|
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.. 
Drew 'hmmm...this fedora sure tastes swella' Jensen
_________________
Blog - http://baseanswers.spaces.live.com/ |
|
| Back to top |
|
|
StefanR
Newbie
Joined: 12 Feb 2006
Posts: 3
|
|
| Back to top |
|
|
paolOOo
General User
Joined: 30 Jan 2006
Posts: 23
Location: Italy (near Milan)
|
| Posted: Tue Feb 14, 2006 1:48 am Post subject: Re: MySql: Foreign key of new created record in subform is 0 |
|
|
| 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 |
|
|
paolOOo
General User
Joined: 30 Jan 2006
Posts: 23
Location: Italy (near Milan)
|
| Posted: Tue Feb 14, 2006 4:52 am Post subject: Re: MySql: Foreign key of new created record in subform is 0 |
|
|
| 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 |
|
|
|
