Date: 2004-04-15T13:20:32
Editor: 217.85.255.245 <>
Wiki: DB Torque Wiki
Page: HarderTorqueFaq
URL: http://wiki.apache.org/db-torque/HarderTorqueFaq
no comment
Change Log:
------------------------------------------------------------------------------
@@ -3,7 +3,7 @@
== How can I create DB-Schemes where Tables contain a Primary-Key with more than one
column? ==
For Example:
-[[[<?xml version="1.0" encoding="UTF-8"?>
+{{{<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE database SYSTEM "D:\JAVA\database_3_1.dtd">
<database defaultIdMethod="native" name="survey_db">
<table name="survey_system">
@@ -23,6 +23,11 @@
<reference local="systemid" foreign="systemid"/>
</foreign-key>
</table>
-</database>]]]
+...
+...
+...
+</database>}}}
-If try to insert a Survey you will get an Error. So... What to do?!?
+If you try to insert a "Survey" you will get an Error. Or isn't it allowed to use
multi-column-Primary-Keys?!? After debugging the Torque-Source-Code (I still have a
head-ache :-) ) I found out, that the PK-Engine only looks for the first column with
the PK-Attribute. If i'm right, I had to completely restructure my database-design to
have only ONE column as Primary-Key.
+
+Any Ideas or Comments?!?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
