|
Home > Archive > dBASE SQL Servers > October 2005 > Boolean/Logical Fields for MySQL
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Boolean/Logical Fields for MySQL
|
|
| Erich Zippel 2005-10-11, 7:27 am |
| I am currently in the initial evaluation for switching my dBase application
on the LAN with appr. 20 users and overall 1/2 GB of Data to a SQL-server
application and .
Basically up to now I only succeded to connect to MySQL 4.1. with ODBC v3.51
sucessfully.
As 'Booleans are 'Tinyint' in essence, I can not datalink them to
checkboxes.
I have of a lot of booleans and resp. chackboxes in my app at the moment,
and the users do prefer a checkbox represntation over any '0/1', 'Yes/No'
etc. represntation.
So I am looking for an easy to use and quick way (some general class) to
connect Tinyints to Checkboxes.
Erich Zippel
| |
| Robert Bravery 2005-10-11, 7:27 am |
| HI,
Use the BIT data type instead.
Robert
"Erich Zippel" <ezippel@oeti.at> wrote in message
news:oUvlC6LzFHA.1044@news-server...
> I am currently in the initial evaluation for switching my dBase
application
> on the LAN with appr. 20 users and overall 1/2 GB of Data to a SQL-server
> application and .
>
> Basically up to now I only succeded to connect to MySQL 4.1. with ODBC
v3.51
> sucessfully.
>
> As 'Booleans are 'Tinyint' in essence, I can not datalink them to
> checkboxes.
> I have of a lot of booleans and resp. chackboxes in my app at the moment,
> and the users do prefer a checkbox represntation over any '0/1', 'Yes/No'
> etc. represntation.
>
> So I am looking for an easy to use and quick way (some general class) to
> connect Tinyints to Checkboxes.
>
>
> Erich Zippel
>
>
| |
| Robert Bravery 2005-10-11, 7:27 am |
| Sorry It hought you said MSSQL.
The newer versions of MSSQL does have bit data types
Robert
"Robert Bravery" <me@u.com> wrote in message
news:ZrfbihOzFHA.1044@news-server...
> HI,
>
> Use the BIT data type instead.
>
> Robert
>
> "Erich Zippel" <ezippel@oeti.at> wrote in message
> news:oUvlC6LzFHA.1044@news-server...
> application
SQL- server[color=darkred
]
> v3.51
moment,[color=darkre
d]
'Yes/No'[color=darkred]
>
>
| |
| Erich Zippel 2005-10-11, 7:27 am |
| Yeah, I thoufht I had seen that one somewhere recently.
Thanks for the quick fix, I almost was on the hunt for a reason I can not
use it.
Erich
"Robert Bravery" <me@u.com> schrieb im Newsbeitrag
news:6%23cPcsOzFHA.1304@news-server...
> Sorry It hought you said MSSQL.
>
> The newer versions of MSSQL does have bit data types
> Robert
>
> "Robert Bravery" <me@u.com> wrote in message
> news:ZrfbihOzFHA.1044@news-server...
> SQL-server
> moment,
> 'Yes/No'
>
>
|
|
|
|
|