[libreoffice-users] LO 4.0: intrinsic database: relations only between primaries keys?

Hello

(It seems that my message did not pass to the gmane newserver, that is
why I resend this message)

I am using Kubuntu 10.04 and installed the latest LO 4.0 (the problem
occurs also in 3.6, and in OO 3.3).

I set up the intrinsic (hsql) data base. I created two tables using the
templates: one is Task (from business) the other Accounts (from
personal). All the field values are the default ones.  I use an existing
field as a primary key (autovalue on), namely TaskId (numeric) and
AccountId (numeric). I insert some data and save them.


I then set up a relation between the two tables, where I relate the
fields corresponding to the primary keys. (TaskId-->AccountId) I save
the relation and reopen it.

Now I want to edit the relation and I am offered the possibility to add
more fields. So I select the notes file in either table but I receive
the following error.

 Primary or unique constraint required on main table.
 "Accounts" in statement [ALTER TABLE "Tasks"
  ADD FOREIGN KEY ("TaskId","Notes") REFERENCE "Accounts"("AccountI","Notes")]
 
I am puzzled, in the intrinsic database only relations between primary
keys are possible?? Is this a property of the intrinsic database, or is it a
bug? I am thinking of submitting a bug report.

Any help would be appreciated

Uwe Brauer 


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted