Hi,
I'm trying to add some constraints to my databasefield, but except for the primary key they always fail.
I've tried to create a NOTNULL constraint by checking the mandatory option, but that didn't work, so i tried to do so with validation rules like name != "" and name != null but that didn't work either.
The foreign key i tried to realise with validation rules like id exists in (select id from clients) but that also didn't work.
Can someone help me with this? or is the only possibillity to check the values in the program itself?
Thx
I'm trying to add some constraints to my databasefield, but except for the primary key they always fail.
I've tried to create a NOTNULL constraint by checking the mandatory option, but that didn't work, so i tried to do so with validation rules like name != "" and name != null but that didn't work either.
The foreign key i tried to realise with validation rules like id exists in (select id from clients) but that also didn't work.
Can someone help me with this? or is the only possibillity to check the values in the program itself?
Thx