>>>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.