Re: Can't Save Record Mandatory field is null

2022-01-29 Thread Arnaud de Montard via 4D_Tech
> Le 27 janv. 2022 à 22:55, Alan Tilson via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Hello Keisuke, > You make it sound simple, so how do I "parse the xml"? > Open it in a text editor and search for "reject null values"? > Thanks! Hi Allan, it seems to be "never_null". But if you

Re: Can't Save Record Mandatory field is null

2022-01-27 Thread Alan Tilson via 4D_Tech
Hello Keisuke, You make it sound simple, so how do I "parse the xml"? Open it in a text editor and search for "reject null values"? Thanks! Alan On Wed, Jan 26, 2022 at 6:46 PM Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > you can "export structure" and parse the xml. > > I cannot

Re: Can't Save Record Mandatory field is null

2022-01-26 Thread Keisuke Miyako via 4D_Tech
you can "export structure" and parse the xml. I cannot find a way to search for fields with "Reject NULL Values" set to true. Surely this must be possible, so can someone please let me know how to do it? ** 4D Internet Users

Re: Can't Save Record Mandatory field is null

2022-01-26 Thread Alan Tilson via 4D_Tech
Hello again, I cannot find a way to search for fields with "Reject NULL Values" set to true. Surely this must be possible, so can someone please let me know how to do it? Thank you, Alan On Wed, Jan 26, 2022 at 12:26 PM Alan Tilson wrote: > Hello Sannyasin, > I just got bitten by this same

Re: Can't Save Record Mandatory field is null

2022-01-26 Thread Alan Tilson via 4D_Tech
Hello Sannyasin, I just got bitten by this same issue, so thank you very much for sharing the solution. We had a field that was accidentally marked to 'Reject null input values' over 15 months ago and today it started causing problems! But we are back up and running after searching for this issue.

Re: Can't Save Record Mandatory field is null

2016-09-07 Thread Sannyasin Siddhanathaswami
Solved! Tech support found that I had “Reject null input values” on by First Name field! We must have checked that by accident at some point. Unchecking it fixed the issue. -- Sannyasin Siddhanathaswami On September 1, 2016 at 11:25:56 PM, Sannyasin Siddhanathaswami

Re: Can't Save Record Mandatory field is null

2016-09-02 Thread Sannyasin Siddhanathaswami
Regarding the debug log, I was able to start and stop it from the maintenance tab on the 4D Server administration window. That’s good enough as I didn’t have any other activity at the logging time. Of course, I don’t understand enough of what the log says to see any problem... -- Sannyasin

Re: Can't Save Record Mandatory field is null

2016-09-02 Thread Sannyasin Siddhanathaswami
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

Re: Can't Save Record Mandatory field is null

2016-08-31 Thread Sannyasin Siddhanathaswami
Aloha Kirk, Good hint. I’ll look at related tables/fields for mandatory. I’ll also double check I have primary keys on everything. I thought I did. Chip, unfortunately I get this error when I try to save a record with code without loading a form. -- Sannyasin Siddhanathaswami On August 31,

Re: Can't Save Record Mandatory field is null

2016-08-31 Thread Kirk Brooks
Sannyasin, You can also get that error if there are related or linked records. I've never seen this come up outside of a change in structure when there is existing data. And a primary key field that doesn't get set, of course. Those might be clues. On Tue, Aug 30, 2016 at 9:05 PM, Sannyasin

Can't Save Record Mandatory field is null

2016-08-30 Thread Sannyasin Siddhanathaswami
Aloha, I’m having a super weird error in our database. For maybe 1000 records I get an error when opening/saving a record. It says : Cannot Save record… Cannot update record… Mandatory field is Null in record… I’ve run verify records in the maintenance center and it didn’t find any errors. I