Subform not saved on a new registration

johan · Unread post by **johan** » Sat May 06, 2023 10:01 am

Ok thanks
Must every primary key be varchar(25)?

Unread post by **kev1n** » Sat May 06, 2023 10:21 am

Just for subforms.

johan · Unread post by **johan** » Sat May 06, 2023 4:24 pm

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

Unread post by **kev1n** » Sat May 06, 2023 4:33 pm

Did you log in again afterwards?

johan · Unread post by **johan** » Sat May 06, 2023 4:55 pm

Yes I did. Even used another browser.

Unread post by **kev1n** » Sat May 06, 2023 6:26 pm

Could you export your form and tables once again?

johan · Unread post by **johan** » Sat May 06, 2023 7:30 pm

Kev1n
I've dumped the form and SQL again.
Thanks
Johan

Archive.zip

Unread post by **kev1n** » Sun May 07, 2023 8:27 am

Also change this id to varchar(25):

Code: Select all

ALTER TABLE `contracten` CHANGE `re_id` `re_id` VARCHAR(25) NOT NULL;

johan · Unread post by **johan** » Sun May 07, 2023 9:23 am

Kev1n
This solved it.
Thanks for your help.
Johan

nuBuilder Forum

Subform not saved on a new registration

Re: Subform not saved on a new registration

Re: Subform not saved on a new registration

Re: Subform not saved on a new registration

Re: Subform not saved on a new registration

Re: Subform not saved on a new registration

Re: Subform not saved on a new registration

Re: Subform not saved on a new registration

Re: Subform not saved on a new registration

Re: Subform not saved on a new registration