ADO & SQL 7.0 Bit Field


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: ADO & SQL 7.0 Bit Field

  1. #1
    Robert Guest

    ADO & SQL 7.0 Bit Field


    When retrieving a bit field from SQL 7, represented in SQL 7 by a 1 or a 0,
    ADO transforms the field into adboolean resulting in the words "true" or
    "false" when written out. It seems unnecessarily clumsy to have to manually
    convert that to a 1 or a 0 every time this data is retrieved, for my objects
    are placing those values in an XML string that mirrors the database. Do
    you have any alternative?
    Share on Google+

  2. #2
    Bill Vaughn Guest

    Re: ADO & SQL 7.0 Bit Field


    Nope, I'd have to play with it to see...

    b
    "Robert" <needguaranteeof@emailnotusedfor.soliciting> wrote:
    >
    >When retrieving a bit field from SQL 7, represented in SQL 7 by a 1 or a

    0,
    >ADO transforms the field into adboolean resulting in the words "true" or
    >"false" when written out. It seems unnecessarily clumsy to have to manually
    >convert that to a 1 or a 0 every time this data is retrieved, for my objects
    >are placing those values in an XML string that mirrors the database. Do
    >you have any alternative?


    Share on Google+

Similar Threads

  1. Replies: 1
    Last Post: 10-10-2001, 10:44 AM
  2. SQL Server migration from 6.5 to 7.0
    By Shantha Gowda in forum Database
    Replies: 1
    Last Post: 12-07-2000, 10:18 AM
  3. ADO Syntax, from DAO to ADO, from Access to SQL
    By T. Bradley Dean in forum VB Classic
    Replies: 2
    Last Post: 09-13-2000, 10:47 PM
  4. SQL 7.0 and UniqueIdentifier Field
    By Bill Hilburn in forum authorevents.vaughn
    Replies: 4
    Last Post: 06-01-2000, 12:13 PM
  5. Querying DB2 6.0 from SQL Server 7.0
    By Jamie C in forum Database
    Replies: 0
    Last Post: 03-27-2000, 04:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center