Error in code when creating new record through deeplink

[derk.hulshof]

Hi all,

I am using a deeplink in third party webapplication to show a form from a Servoy solution.
Using : {serverUrl}/servoy-webclient/ss/s/{mySolutionName}/m/{myMethodName}/a/{value}

In the method I do some coding to retrieve some information from table A. The form / foundset which is displayed is using table B.
Now I use
var idx = forms.uren.foundset.newRecord(false);
to make sure that I have a new record in the foundset.
When this line is called Servoy generates an error depending on not null columns in table B.

---- error ---
Kan form data niet opslaan / Can't save form data
> com.servoy.j2db.dataprocessing.DataException: ORA-01400: Kan geen NULL invoegen in ("[SCHEMA/USERNAME]"."TABLE B"."COLUMN").
> com.servoy.j2db.dataprocessing.DataException: ORA-01400: Can't insert null value into ("[SCHEMA/USERNAME]"."TABLE B"."COLUMN").
--- end error --------

How can I fix this, or anyone an idea?

It works all fine, only this error is raising, where I want to get rid of.

Tnx in advance

version:
Servoy v7.3.1 and/or 7.4

[Harjo]

has this really something todo with using a deeplink?
or do you get the same error, when you show the same form, and someone hit's a button?

[derk.hulshof]

Hi Harjo,

Tnx for the reply. It also happens when when I put the var idx = forms.uren.foundset.newRecord(false); line within an onAction call outside the deeplink.

[Hans Nieuwenhuis]

what if You use databaseManager.nullColumnValidatorEnabled = false;

I set this in the onOpen method of my solution

[derk.hulshof]

Hi Hans,

Tnx for the reply.
Nope is not the answer.

Looks like Servoy initiated a foundset (empty record) or something, which it would like to save on the newRecord call.

[derk.hulshof]

Solved: it was the autoSave option