Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored procedure for edit log
Message
From
19/11/2008 13:37:44
 
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01361756
Message ID:
01362883
Views:
7
>>>>
>>>>Second, I DID try putting the code directly in the aspx markup. That was the point of my last post. The syntax checker didn't like it and it wouldn't build.
>>>>:)
>>>
>>>Not at the moment.
>>>
>>>Post ASPX portion you tried in the meantime.
>>
>>Here's the full datasource definition
>>
>>
>>			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.
>
>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.
:(
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform