Changed the order of generating and getting Unique ID for xml_nodes.nodeid and for uniqueid part of the accession# because of SQl Server capabilities: first let the db to generate unique id on insert (by db trigger and sequence or by IDENTITY key), then get that unique id for further use by the application. Used to be the opposite for these 2 unique id generations.
Changed the order of generating and getting Unique ID for
xml_nodes.nodeid and for uniqueid part of the accession#
because of SQl Server capabilities:
first let the db to generate unique id on insert (by db trigger and sequence or by IDENTITY key),
then get that unique id for further use by the application.
Used to be the opposite for these 2 unique id generations.