Welcome to the nuBuilder Forums!

Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.

Subform lookup NULL on first row only

Questions related to using nuBuilder Forte.
Post Reply
vario
Posts: 154
Joined: Mon Dec 05, 2011 12:23 pm
Location: Newton Abbot, UK
Has thanked: 2 times
Been thanked: 1 time

Subform lookup NULL on first row only

Unread post by vario »

I have a subform with a lookup field. When I enter several rows and do not have a value in the lookup, only the first is created with a NULL column value and the rest are empty strings. I would prefer it to leave the unpopulated column values as NULL. I'm using the latest version (from Sourceforge).

Neil.
kev1n
nuBuilder Team
Posts: 4562
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 76 times
Been thanked: 528 times
Contact:

Re: Subform lookup NULL on first row only

Unread post by kev1n »

Try replacing this line

Code: Select all

$("[id^='" + o.form + nuPad3(o.rows) + "']").addClass('nuEdited')
with

Code: Select all

$("[id^='" + o.form + nuPad3(o.rows) + "']").removeClass('nuEdited')
then log in again.
vario
Posts: 154
Joined: Mon Dec 05, 2011 12:23 pm
Location: Newton Abbot, UK
Has thanked: 2 times
Been thanked: 1 time

Re: Subform lookup NULL on first row only

Unread post by vario »

Thanks! NULL values in all unpopulated lookup ids.

Neil.
kev1n
nuBuilder Team
Posts: 4562
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 76 times
Been thanked: 528 times
Contact:

Re: Subform lookup NULL on first row only

Unread post by kev1n »

This is now on Github.
Post Reply