Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Stored procedure for edit log
Message
 
À
19/11/2008 12:45:09
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro et .NET
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01361756
Message ID:
01362872
Vues:
9
>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).
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform