Hi Justin, if round trip is your main concern , I would use a UDF in place of such unportable syntax.
regards, Dario. El 27/11/10 20:20, Justin N. escribió: > If using it for such a query I would agree, however it allows a single > DB roundtrip for something such as inserting into the main table and > then the various link tables as well. We typically will insert the > NEXTVAL of a sequence in the first INSERT section and then use > CURRVAL of the same sequence that we inserted into the main table for > all the rest of the link tables. > > Example: > INSERT ALL INTO > PERSON > (PERSON_ID, OTHER_STUFF) > VALUES > (PERSON_ID_SEQUENCE.NEXTVAL, OTHER_VALS) > INTO > PERSON_ORG_LNK_TABLE > (PERSON_ID, ORG_ID) > VALUES > (PERSON_ID_SEQUENCE.CURRVAL, ORG_ID) -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
