Lazarus

Programming => Databases => Topic started by: CrazyRam on July 17, 2019, 02:55:31 pm

Title: Can I store the value of a checkbox in a dataset / DB and tie it to DBNavigator
Post by: CrazyRam on July 17, 2019, 02:55:31 pm

Hi,

I have a CheckBox on my form, when checked I'd like to store its value in my DB / dataset (zmSQL) via the DBNaqvigator Post event. Is it possible?

Rgds
Ram.

Title: Re: Can I store the value of a checkbox in a dataset / DB and tie it to DBNavigator
Post by: CrazyRam on July 17, 2019, 04:00:13 pm

Ah, there is a DBCheckBox. Just need to create a new column in the DB and save its state.

Title: Re: Can I store the value of a checkbox in a dataset / DB and tie it to DBNavigator
Post by: madref on July 19, 2019, 05:40:35 am

But store it as a 0 or a 1 and not as a true or false.
This makes your database a bit more flexible

Title: Re: Can I store the value of a checkbox in a dataset / DB and tie it to DBNavigator
Post by: CrazyRam on July 22, 2019, 01:26:03 pm

Thanks madref.