Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Insert Where.... it fits!
sSql = "Insert Into PRadd_Address (PRaddAddressLine1, PRaddAddressLine2)" _ & "Values ('" & Line1 & " ', '" & Line2 & "') Where PRaddPersonId = " & temp2 & " " can any1 tell me whats wrong with this ! I am using it in VB6 to access an SQL... -
Convert this and win ..... well nothing
Hey Thanks for that... After having a close look I was wrong... I am sorry, had support calls all over the place. The field is YES/NO and I need to convert it to BINARY.... Any advice ?- awalli6i
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Convert this and win ..... well nothing
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...- awalli6i
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Insert Where
I am trying to do a Access to SQL convert. I need to pull information into the new database but to do it need to make sure that the information is for that person... sSql = "Insert into PRemp_Employee (PRempDateOfBirth) Where PRempEmployeeCode = " & code & " values ('" &...
