System Setup - Saving changes to Connection Setup - Exceptio

Post Reply
gwtiltman
Site Admin
Posts: 668
Joined: Thu Dec 26, 2013 12:02 pm
Location: Northwold, Gauteng

System Setup - Saving changes to Connection Setup - Exceptio

Post by gwtiltman » Fri Dec 27, 2013 4:39 pm

If you get an error
'[Save Settings] Exception: Cannot insert value NILL into Column 'RedID'

after clicking on save, follow these steps:

Solution:-
Go into Management Studio
Select the table MISCDATA and right-click and select DESIGN
Set RECID's (Is Identity) to YES;
you'll need to set BATCHID's (Is Identity) = NO
Set BATCHID's default value = (0)

Post Reply