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

Not necessary. At the VFP command prompt

st = "public gcEmployee + chr(13) + chr(10) + gcEmployee = [don]"
execscript(st)                 && fails

st = "public gcEmployee" + chr(13) + chr(10) + "gcEmployee = [don]"
execscript(st)                 && works

I think this illustrates the problem.