ms-access to SQL Server converted yes/no fields.

Article View: bit.databases.mssql-l

Article #191

Back to bit.databases.mssql-l Previous Next

#191

From: Ben
Date: Tue, 09 Apr 2002 15:05

7 lines
1269 bytes

We are upsizing from ms-access to SQL Server and have a substantial
amount of application code (in C++ and VB I believe)  on "yes/no"
fields coded with  "where myfield = yes".   Is there any good way to
not have to recode these queries to "where myfield <> 0".   So far I
can make it work by adding columns called "yes" and "no" to my SQL
Server table,  and defaulting "yes" to 1 and "no" to 0.   Sure,  it
works,  but it's kinda tacky.   Anybody got anything better?

Technical Details

Message-ID: <c077b979.0204090705.5c0e239a@posting.google.com>

Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,596fe21d8d84b9cb,start
X-Google-Attributes: gidf6611,public
X-Google-ArrivalTime: 2002-04-09 08:05:25 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail
From: Ben.Binder@ispat.com (Ben)
Newsgroups: bit.databases.mssql-l
Subject: ms-access  to SQL Server converted yes/no fields.
Date: 9 Apr 2002 08:05:24 -0700
Organization: http://groups.google.com/
Lines: 7
Message-ID: <c077b979.0204090705.5c0e239a@posting.google.com>
NNTP-Posting-Host: 156.144.107.21
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1018364725 14539 127.0.0.1 (9 Apr 2002 15:05:25 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 9 Apr 2002 15:05:25 GMT