Jump to content


Photo

mysql: tinyint (1) as NxDBCheckboxColumn


  • Please log in to reply
3 replies to this topic

#1 steki

steki
  • Members
  • 10 posts

Posted 22 August 2006 - 12:06 PM

Hi,

in mysql i use type tinyint(1) with values 0 und 1 as a boolean field.
now i want to use a NxDBCheckboxColumn with this field, but field ist always empty in DBGrid.
if i use a DBTextColumn instead i see values True, False.

which properties in NxDBCheckBoxColumn do i have to set?

best regards
stefan

#2 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,289 posts
  • Gender:Male

Posted 22 August 2006 - 12:48 PM

Hello,

You will need to set properties ValueChecked and ValueUnchecked to 1 and 0. Then it will work.

I hope that it help smile.gif

Best regards
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.

#3 steki

steki
  • Members
  • 10 posts

Posted 23 August 2006 - 12:57 AM

QUOTE (Boki (Berg) @ Aug 22 2006, 01:48 PM) <{POST_SNAPBACK}>
Hello,

You will need to set properties ValueChecked and ValueUnchecked to 1 and 0. Then it will work.

I hope that it help smile.gif

Best regards


no sorry does not help, what else can i try?

best regards
stefan

#4 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,289 posts
  • Gender:Male

Posted 23 August 2006 - 01:15 AM

Hello,

Try to set this properties to "True" and "False" instead.

Best regards
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users