Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored procedure for edit log
Message
From
19/11/2008 13:34:04
 
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:
01362881
Views:
6
>>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.
>
>Don, if this is a .NET are you shure you can use CHR(13)+CHR(10)?
>isn't it:
>
>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).

I'm not sure I know the difference between VB.NET and ADO.NET and plain old .NET, etc. I am working with the visual web developer express and using VB as the basic code language. I know there are VB constants such as vbCRLF but this is in the markup and not the VB codebehind. I assume it should work as Naomi and Viv suggest since it the VFP driver that will be executing the code. Actually, I tried using the vbCRLF constant but then it would need to be encapsulated in the ASP markers < % % > and the intellisense didn't like that either.
Previous
Reply
Map
View

Click here to load this message in the networking platform