SQL syntax problem

HI All,

This is the query i am using to update the records.
But when i am executing,getting sql syntax error.
Please correct the syntax of the query.
The variables holds the corresponding values.

Please Login or Register  to view this content.

Thanks for any help

Regards
Kumar

1) I believe it should end in a semicolon
2) You may have some improper formats for your queries. While in debug mode, and after sSQL has been defined by your code above, look and see what sSQL really says. You should be able to hover your mouse over it or trace it in debug or type '? sSQL' in the Immediate window.

Pauley