That’s helpful. I suspect now that it’s some related table that has bad data in it’s primary key field even though the error I get when saving says it’s in my main Members table. I doubt this helps, but this is the full error: Error when executing the method "Test Method" at line number 18 Cannot save record 81770 in table Members of database Akasha Danta
Error code: 1046 Cannot save record 81770 in table Members of database Akasha Danta component: 'dbmg' task -21, name: 'P_9' Error code: 1049 Cannot update record 81770 in table Members of database Akasha Danta component: 'dbmg' task -21, name: 'P_9' Error code: 1116 Mandatory field is Null in record 81770 in table Members component: 'dbmg' task -21, name: 'P_9' I wanted to activate the debug log and see if there was anything helpful there, but I can’t seem to get the debug log to work: SET DATABASE PARAMETER(34;2+4) // enables file with v14 format, with parameters and runtimes QUERY([Members];[Members]EMB=81766) [Members]UUID:=Generate UUID SAVE RECORD([Members]) SET DATABASE PARAMETER (34;0) // disables file But no file is created in the Logs folder next to the structure file on our 4D server (v15.1 on a Mac). Any idea why a log file isn’t created? -- Sannyasin SiddhanathaswamiOn September 1, 2016 at 12:47:49 AM, Arnaud de Montard ([email protected]<mailto:[email protected]>) wrote: Hi, note that the code you send detects mandatory fields but not primary keys… while PKs *are* mandatory. -- Arnaud de Montard ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
