>>>>>UpdateCommand="Public employee + chr(13) + chr(10) + employee = [Viv] + chr(13) + chr(10) + UPDATE
>> rtp_projects SET rtp_id = ?, tip_id = ?, lead = ?, st_name = ?, termini = ?, project = ?, length = ?, detail_des = ?,
>>category = ?, system = ?, subsystem = ?, existlanes = ?, newlanes = ?, est_start = ?, est_finish = ?, newbikelan = ?,
>>multiuse = ?, newwalks = ?, study = ?, design = ?, rw = ?, const = ?, operations = ?, total_cost = ? WHERE keyid = ? ">
>>
>>>>>The UT message handler doesn't like all the code even though its in the PRE tags.
>>>>
>>>>Remove all " " from it. See changes I made
>>>
>>>OK I can see where that is better. It solves the syntax issue but produces an 'Unhandled Exception' error when the UPDATE is performed. The message code for these is so complex I can never make any sense out of it.
>>>:(
>>
>>I didn't follow the whole thread, but why you need employee variable?
>>You didn't use it in your update command anyway.
>>I should check the old messages.
>
>This has gotten to be pretty convoluted. The employee (user) is a public variable in the desktop app that is stored in the changelog audit table when edits are made. The UPDATE triggers a stored proc containing code that references the employee name to perform this save. So when we move it to the web the stored proc needs to have a variable with the username to complete the transaction. Its explained a bit more fully in the original post.

Start a new thread with the error you're getting.