Page 1 of 1

[Solved] Check in Check Box continues to next record in sub form

Posted: Mon Aug 22, 2022 11:12 pm
by Dalke55
I have added a BOOLEAN field to a sub form and attached a CHECK Box for that field. My issue is when I click the box for the check option and move on to the next record in the sub form the box in the next record already has a check in it. How would I set the check box to clear on the form after going to next record. The Table fields are correct for the last record entered.

Attached image of Check Box properties General & Data tab

Thank You!

Re: Check in Check Box continues to next record in sub form

Posted: Tue Aug 23, 2022 6:26 am
by UnklDonald418
Open your table in the Edit mode and select the field TNT-BLU X
Make sure Default value is set to No
Example attached
Screenshot_20220822.png
Screenshot_20220822.png (15.39 KiB) Viewed 10543 times

Re: Check in Check Box continues to next record in sub form

Posted: Tue Aug 23, 2022 6:14 pm
by Dalke55
Thank you, as soon as I get DBSchema to import my database schema I will make that change as the current setting is <none>. I cannot directly modify my HSQLDB ver2.3.2 with the editor.
Im currently waiting on DBSchema support so my result may be in a day or two.

Re: Check in Check Box continues to next record in sub form

Posted: Thu Aug 25, 2022 6:22 am
by UnklDonald418
You should be able to make the needed change at menu selection Tools>SQL by executing a command of the form

Code: Select all

ALTER TABLE "YourTableName" ALTER COLUMN "YourColumnName" SET DEFAULT 'SomeValue';
In your case substitute "TNT-BLU X" for "YourColumnName" and FALSE for 'SomeValue'

Tools>SQL bypasses Base and works directly with the back-end engine, in your case HSQL 2.3.2
To inform Base of the change(s) select TABLES from the main Base window
Then from the menu select View>Refresh tables

Re: Check in Check Box continues to next record in sub form

Posted: Thu Aug 25, 2022 1:30 pm
by Dalke55
Thank You! Before I saw this last post I had an issue with BASE EDITOR, FORM NAVIGATOR and looked up a link that said to reset the user profile which I did, and fixed Form Navigator. I also found the CHECK BOX functioned properly and cleared when going to next record.
Thanks again