Page 2 of 2
Re: Subform not saved on a new registration
Posted: Sat May 06, 2023 10:01 am
by johan
Ok thanks
Must every primary key be varchar(25)?
Re: Subform not saved on a new registration
Posted: Sat May 06, 2023 10:21 am
by kev1n
Just for subforms.
Re: Subform not saved on a new registration
Posted: Sat May 06, 2023 4:24 pm
by johan
Kev1n
Just tested this.
I've changed my primary key of table bron into varchar(25)
Screenshot 2023-05-06 16.20.02.png
Result is almost the same. Before change of primary key my editform closed and returns to browsform, now the editform stays open but the values in subform are empty again.
Johan
Re: Subform not saved on a new registration
Posted: Sat May 06, 2023 4:33 pm
by kev1n
Did you log in again afterwards?
Re: Subform not saved on a new registration
Posted: Sat May 06, 2023 4:55 pm
by johan
Yes I did. Even used another browser.
Re: Subform not saved on a new registration
Posted: Sat May 06, 2023 6:26 pm
by kev1n
Could you export your form and tables once again?
Re: Subform not saved on a new registration
Posted: Sat May 06, 2023 7:30 pm
by johan
Kev1n
I've dumped the form and SQL again.
Thanks
Johan
Archive.zip
Re: Subform not saved on a new registration
Posted: Sun May 07, 2023 8:27 am
by kev1n
Also change this id to varchar(25):
Code: Select all
ALTER TABLE `contracten` CHANGE `re_id` `re_id` VARCHAR(25) NOT NULL;
Re: Subform not saved on a new registration
Posted: Sun May 07, 2023 9:23 am
by johan
Kev1n
This solved it.
Thanks for your help.
Johan