1 Set rs = Database.Get( "SELECT * FROM CTUSER.NETWLOCATION CT " _
2 & "WHERE EXISTS " _
3 & "(SELECT SITECODE FROM NETWLOCATION " _
4 & " WHERE CT.LOCATIONID = SITECODE ) ")
5 Do While Not rs.EOF
6 Call AddSQL( "UPDATE NETWLOCATION SET SITECODE = " & rs.LOCATIONID _
7 & "LOCATIONNAME = "& rs.LOCATIONNAME _
8 & "LOCATIONADDRESS = "& rs.LOCATIONADDRESS _
9 & "LOCATIONCODE = SITECODE" )
10 Call execSQL()
11 rs.Next
12 Loop
als ik de script run krijg ik foutmelding stringconstant not properly terminated line 6 position 4
kan iemand mij uitleggen waar het probleem aan ligt?
2 & "WHERE EXISTS " _
3 & "(SELECT SITECODE FROM NETWLOCATION " _
4 & " WHERE CT.LOCATIONID = SITECODE ) ")
5 Do While Not rs.EOF
6 Call AddSQL( "UPDATE NETWLOCATION SET SITECODE = " & rs.LOCATIONID _
7 & "LOCATIONNAME = "& rs.LOCATIONNAME _
8 & "LOCATIONADDRESS = "& rs.LOCATIONADDRESS _
9 & "LOCATIONCODE = SITECODE" )
10 Call execSQL()
11 rs.Next
12 Loop
als ik de script run krijg ik foutmelding stringconstant not properly terminated line 6 position 4
kan iemand mij uitleggen waar het probleem aan ligt?