Home Forums SQL Server 2005 SQL Server 2005 General Discussion VB boolean to SQL bit conversion? RE: VB boolean to SQL bit conversion?
David A. Long
SSCrazy Eights
Points: 8421
More actions
April 2, 2007 at 2:18 am
#698036
Actually the VB6 boolean is True = -1 and False = 0, so to convert the myVB6Bool variable to SQL bit would be Abs(myVB6bool), which returns 1 or 0 instead of -1 or 0.
Andy