Insert and DTS

#1

Hi,

I would like to ask what is the syntax error in this:

sql = "UPDATE Weeks SET WeekStart = "& ww &"" & vbCrLf & _
"FROM CurrentWeek WHERE Weeks.WkNo = CurrentWeek.Wkno + 1"

ww is a global variable

Thanks in advance

Riri

#2

Dont worry I found my error after a minute.

Thanks

#3

I found the error

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Insert and DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Insert and DTS - 02-09-2005 , 08:25 AM

Re: Insert and DTS - 02-09-2005 , 08:27 AM

Re: Insert and DTS - 02-09-2005 , 08:28 AM