Help w Inserts and Tracking/Logging

Classic Servoy
1

I have setup Tracking on one table, the Log database has been created.

I have two problems.

  1. When I select Insert new record from the Select menu, I am immediately getting a “Error Saving Records Dialog” with the details stating ORA-01400: cannot insert NULL into (“MYDB”.“MYTABLE”.“CLAIMNUMBER”)

I’m not sure why I’m getting this on the Insert command? I can fill in the key value, and the record seems to update OK.

  1. However, my Log file is showing only one record for one change to one record, despite the fact that I’ve made numberous changes and additions.

Not sure what I’m doing wrong here, but would appreciate any insight.

Thanks,
Lee