Hey all
I am trying to write a prog that converts a MS Access 97 DB to SQL Server 7 DB. However I need to conevert some of the data from one trype to another. To do this i have used the convert function within my SQL string (I am using VB6 by the way). How ever when I try to convert TRUE/FALSE to Binary it won't do it !
Here is the string :
Update PRemp_Employee set PRempSupPrintingRDO = " & " convert(Binary(10), '" & temp & "' ) where PRempEmployeeCode = ('" & code & "')
Can any1 help me !
Andrew
I am trying to write a prog that converts a MS Access 97 DB to SQL Server 7 DB. However I need to conevert some of the data from one trype to another. To do this i have used the convert function within my SQL string (I am using VB6 by the way). How ever when I try to convert TRUE/FALSE to Binary it won't do it !
Here is the string :
Update PRemp_Employee set PRempSupPrintingRDO = " & " convert(Binary(10), '" & temp & "' ) where PRempEmployeeCode = ('" & code & "')
Can any1 help me !
Andrew