I have a windows form that is connected to a SQL 2014 dataset. I just recently upsized the form from a local access table to a SQL server table. OH BOY!
A left over issue that I'm having is that I have a PK set on field called 'Record_ID' that is seeded from the server. The update command is throwing an error that the value is null. (that's my problem I think) The identical code worked fine for Access by SQL is wielding amighty fist I think (which is why I did it)
I'm using this code.
I'm left wondering if I can insert new and call an update to force the field to update and assign a value? The continue to add any information and update again?