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.
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 Inserts Blank Row
-
vario
- Posts: 154
- Joined: Mon Dec 05, 2011 12:23 pm
- Location: Newton Abbot, UK
- Has thanked: 2 times
- Been thanked: 1 time
Subform Inserts Blank Row
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?
Re: Subform Inserts Blank Row
Vario,
I can't say exactly but what have you got in the sql for your subform?
Steven
I can't say exactly but what have you got in the sql for your subform?
Steven
You do not have the required permissions to view the files attached to this post.
-
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 Inserts Blank Row
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).
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).
Re: Subform Inserts Blank Row
Maybe 'enable' checkboxes but then hide them, like this..
http://forums.nubuilder.cloud/viewtopic.php?f=6&t=7606
Steven
http://forums.nubuilder.cloud/viewtopic.php?f=6&t=7606
Steven