Again syntax error

shoakat · October 20th, 2004, 05:01 PM

Hello Guys, Again the problem in syntax
strUpdate = "update tblCustRate set dtRateFrom =" &ndateFrom&_ ",dtRateTo = " &ndateUntil&_ ",decHourlyRate=" &nHourlyRate&_ where "iEmpID =" &iEmpID_ and "itaskiD="

The problem is in the where statement it sometimes complains for mismatch string and expected end of statement. I get confused with these. Can you tell me what is the best way to learn these things. I will really appreciate comments and suggestions.
Thanks
shoakat

happygv · October 20th, 2004, 06:15 PM

Why is that you are using _??? That is used only when you want to continue the code on the same line to next line.

Code:

strUpdate = "update tblCustRate set dtRateFrom ='" & ndateFrom & "', dtRateTo = '" & ndateUntil & "', decHourlyRate="  & nHourlyRate & " where iEmpID =" & iEmpID & " and " itaskiD=" & variablename

Your statement is incomplete where it is marked red above.

Check that at your end.

_________________________
- Vijay G
Strive for Perfection