• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 874
  • Last Modified:

SQL bit v Access boolean True False

Hi

I have a VB.net project where I have to do the same Insert statement to both an Access and a SQL table. For True or False: in Access I have used the same True and False, but in SQL this doesn't work. Should I use -1 for True and 0 for False.

Thanks
0
Murray Brown
Asked:
Murray Brown
1 Solution
 
CodeCruiserCommented:
Use 1 for true and 0 for false.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now