>>>>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.