nuBuilder Forum

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?

Vario,

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

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).

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

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

Steven