Advice: do not mix business meaning with object ID.The fiscal number of an invoice can't be an identity (try two concurrent Save and then transaction-rollback of the first Save).
2009/9/30 chris <[email protected]> > > Hi, > I have an MSSQL db with identity columns to get consecutive numbers. > > e.g. Invoice object has invoiceID, which my users like to have > consecutive numbers. Identity works well for this. > > In addition to just having these numbers in this field they also need > a string invoiceReference, which will default to the invoiceID but be > manually editable on some ocassions. > > How can I best get the default case to work (where I need to invoiceID > & invoiceReference to be auto-generated to the same consecutive > number) while having the fewest possible database roundtrips. > > Thanks, > Chris > > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" 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/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
