[Solved] Check box

Creating tables and queries
Post Reply
loudog
Posts: 13
Joined: Thu Jan 31, 2008 11:13 pm

[Solved] Check box

Post by loudog »

I have learned much from the tutorials :) but have not seen the application of check boxes covered. What type of data input selection (Varchar etc.) would i use for a checkbox field :?:

loudog
Last edited by Hagar Delest on Tue Jun 10, 2008 2:56 pm, edited 2 times in total.
Reason: tagged the thread as Solved.
User avatar
DrewJensen
Volunteer
Posts: 1734
Joined: Sat Oct 06, 2007 9:01 pm
Location: Cumberland, MD - USA

Re: check box

Post by DrewJensen »

You can use a checkbox control on a form for columns with datatypes of
Yes/No ( Bolean )
Text( fixed )
Text( varchar )
Numeric

In all cases other then Boolean Checked = 1 and unCheched = 0
For an embedded database Checked = TRUE ( Yes ) and unChecked = FALSE ( No )
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
loudog
Posts: 13
Joined: Thu Jan 31, 2008 11:13 pm

Re: check box

Post by loudog »

Nicely covered :D . Thank you ;)

loudog
Post Reply