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. > 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. Anyway, combined keys are nearly useless. Uwe _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
