Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

Subform lookup NULL on first row only

Questions related to using nuBuilder Forte.
Post Reply
vario
Posts: 148
Joined: Mon Dec 05, 2011 12:23 pm
Location: Newton Abbot, UK
Has thanked: 1 time
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: 4292
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 444 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: 148
Joined: Mon Dec 05, 2011 12:23 pm
Location: Newton Abbot, UK
Has thanked: 1 time
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: 4292
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 444 times
Contact:

Re: Subform lookup NULL on first row only

Unread post by kev1n »

This is now on Github.
Post Reply