Results 1 to 3 of 3

Thread: Boolean using SQL

  1. May 2nd, 2001, 09:23 AM #1
    Luis Moises Rojas
    Luis Moises Rojas is offline

    Thread Starter
    Fanatic Member
    Join Date
    Sep 1999
    Location
    Santo Domingo,D.N., Dom. Rep.
    Posts
    707

    Talking Boolean using SQL

    I have a .MDB database. Some fields are true/false and could be NULL. When i exported it to SQL fields are bit and NOT NULL ALLOW. Of course my APP doesnot work 'cos fields could not be NULL. WHY?

    1. How do i can say these fields MUST ALLOW NULL?
    2. Why i can not test TRUE or FALSE in VB as i do with ACCESS? I must use -1 or 1 or 0
    Reply With Quote Reply With Quote
  2. May 2nd, 2001, 01:21 PM #2
    ELampman
    ELampman is offline
    Addicted Member
    Join Date
    Oct 1999
    Location
    The Lone Star State
    Posts
    183
    In Access, the Required property for the field must be 'No'. In SQLServer, the 'Allow Null' property must be 'Yes' (or checked)
    !
    Reply With Quote Reply With Quote
  3. May 2nd, 2001, 01:27 PM #3
    henry_pimentel
    henry_pimentel is offline
    Member
    Join Date
    Mar 2001
    Location
    Dominican Republic
    Posts
    46
    You can use a SQL sentece for convert False/True values to 0/1/-1....
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width