Recent

« previous next »
Pages: [1]

Author Topic: Can I store the value of a checkbox in a dataset / DB and tie it to DBNavigator  (Read 326 times)

CrazyRam

  • New Member
  • *
  • Posts: 13
Can I store the value of a checkbox in a dataset / DB and tie it to DBNavigator
« 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.
Logged

CrazyRam

  • New Member
  • *
  • Posts: 13
Re: Can I store the value of a checkbox in a dataset / DB and tie it to DBNavigator
« Reply #1 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.

Logged

madref

  • Hero Member
  • *****
  • Posts: 696
  • ..... A day not Laughed is a day not Lived !!
    • Nursing With Humour
Re: Can I store the value of a checkbox in a dataset / DB and tie it to DBNavigator
« Reply #2 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
Logged
You treat a disease, you win, you lose.
You treat a person and I guarantee you, you win, no matter the outcome.

Lazarus 2.0.2 / FPC 3.0.4
Lazarus Trunc / FPC 3.0.4
Mac OS X Mojave

CrazyRam

  • New Member
  • *
  • Posts: 13
Re: Can I store the value of a checkbox in a dataset / DB and tie it to DBNavigator
« Reply #3 on: July 22, 2019, 01:26:03 pm »
Thanks madref.
Logged
Pages: [1]
« previous next »