Subform Inserts Blank Row

vario · Unread post by **vario** » Fri Dec 23, 2011 7:59 am

I have a simple edit form showing vehicle details with a subform, with 1 blank row, showing odometer readings. When I amend the vehicle details or one of the subform rows and click "Save", the subform inserts a blank row (i.e dates contain "000-00-00", char values contain "" and numbers contain 0). How can I stop this from happening?

Unread post by **admin** » Wed Dec 28, 2011 7:04 am

Vario,

I can't say exactly but what have you got in the sql for your subform?

Capture.PNG

Steven

vario · Unread post by **vario** » Wed Dec 28, 2011 7:59 am

The SQL is pretty basic:

select * from odometer
where odo_vehicle_id = '#id#'
order by odo_start_date

I have subsequently discovered that the blank row is not inserted if I enable the "Delete" checkbox for the subform (which I do not really want to do).

Unread post by **admin** » Thu Dec 29, 2011 11:40 pm

Maybe 'enable' checkboxes but then hide them, like this..

http://forums.nubuilder.cloud/viewtopic.php?f=6&t=7606

Steven

nuBuilder Forum

Subform Inserts Blank Row

Subform Inserts Blank Row

Re: Subform Inserts Blank Row

Re: Subform Inserts Blank Row

Re: Subform Inserts Blank Row