Uwe Grauer wrote: > Carl Karsten wrote: >> Uwe Grauer wrote: >>> Carl Karsten wrote: >>>> But I am going to ask, just for kicks: can you show me the CREATE TABLE >>>> and >>>> whatever is needed to make it happen on FireBird? >>>> >>>> Carl K >>>> >>> Look here: >>> http://dabodev.com/tracker/0274 >>> >>> This is with a single key. >>> But you see how it is done. >>> It would be the just like that for combined keys. >> um, no. 2 unique ID's is a special case of a compound key, that has even >> less >> chance of ever being used. (which would put it at less than zero.) >> > > Could be done with a Stored Procedure where you have one of the keys as > input parameters.
"input parameter" is not "server generated". > >> Each part of a compound key typically has duplicates. The key gen routine >> would >> need to somehow know ... um.. I can barely think it let alone put it to >> words. >> >> Assuming it did get generated, then I want to know how the client could be >> informed of the new values after the INSERT. >> >> I am pretty sure this is not only 'impractical' but maybe impossible. >> >> Carl K >> > > You couldn't automate this. Do you agree it (server generated compound keys) is impossible? Carl K _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
