Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored procedure for edit log
Message
From
19/11/2008 12:45:09
 
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:
01362870
Views:
10
>>
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform