> > SelectCommand="SELECT * FROM rtp_projects WHERE (rtp_id = ?)" > ConflictDetection="CompareAllValues" > DeleteCommand="DELETE FROM rtp_projects WHERE keyid = ? " > InsertCommand="INSERT INTO rtp_projects (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) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" > OldValuesParameterFormatString="original_{0}" > > 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.
UpdateCommand="Public employee\n employee ...."
or if it is VB.NET some vb constants like vbCRLF (not sure at all if something like this exists).