Managing unique Record Keys and Ids in legacy database that does not use Identity/Autoincrement RRS feed

  • Question

  • Hi folks;

    I am using the Lightswitch 2013 HTML Client and developing against an external legacy database.
    Unfortunately, the External database does not use Auto-increment keys.  They are managed in a single NextNo table.

    The NextNo Table contains a RecordType and NextNumber value for each record Type in the database.

    I would like to be able to generate a new NextNumber for the record Type being added and immediately display this value on the screen as the User creates a new record.

    I would start on a Browse Record screen and use an ADD NEW button to display the related AddEditScreen.
    The logic needs to query the NextNo table for the RecordType and increment the related NextNumber value.
    The new NextNumber value should be displayed on the AddEditScreen as the new Record's Key value.

    Any help would be appreciated.

    Monday, October 6, 2014 7:28 PM

All replies