I'm evaluating SAPDB and i think that it is excelent.umm - i don't think SAPDB supports this "trigger", does it?
What say you about the option "ON UPDATE CASCADE", is it a fault?, is it not
requided?.
I never needed it.
I always use "autoincrement"-columns (or in SAPDB terms: SERIAL-colums) as my primary key.
So all FOREIGN KEYS point to a non-updateable column. The "ON UPDATE CASCADE" option has some disadvantages, and you can always add a autoincrement-column to a table and use that in your foreign-keys.
So "ON UPDATE CASCADE" is not needed.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
