Access boolean field with SQL
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=10053
Printed Date: 30 March 2026 at 5:57am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Access boolean field with SQL
Posted By: Semikolon
Subject: Access boolean field with SQL
Date Posted: 19 April 2004 at 12:37pm
|
I am making an install script for my ASP Portal wich will create the
tables, indexes, relationships and stored procedures and insert values.
Almost everything is working fine with both Access and SQL Server, only
one problem. When using "bit" as datatype (Field_name bit NOT NULL) a
"Yes/No" Field is created but with a blank format.. All other data types workes fine (as far as I have seen) but I have problems with the booleans.. so, is there any other "boolean datatypes" I can use? EDIT: thank you for the help!  |
Replies:
Posted By: zaboss
Date Posted: 19 April 2004 at 12:40pm
|
Boolean fields are always tricky. I always use a numeric field with 0 and 1. ------------- Cristian Banu http://www.soft4web.ro - Soft 4 web |
Posted By: Semikolon
Date Posted: 19 April 2004 at 12:43pm
|
I was thinking of that as one of two other solutions (the third is to
use the tables scripts only on SQL Server and have the Access database
already installed) but a real boolean field would absolutely be the best thanks for the answer anyways |