Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Begin..End Transaction in RVs
Message
From
11/03/2002 04:01:52
 
 
To
11/03/2002 03:41:13
Czarina Joyce Villanueva
Innovision Systems International
Manila, Philippines
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00630837
Message ID:
00630840
Views:
22
Hi!

VFP transactions work only for updating changes in RV at the VFP side (client-side). To revert changes completely in RV, issue TableRevert() function. To use transactions at the server side, you require to use appropriate commands for database backend you used to connect by remote view. For example, for SQL Server transactions are automatic, but there are also appropriate commands that use can send using SQLEXEC(). Take a look to such functions as SQLCommit(). Handle for these functions you can get just from the remote view - using CursorGetProp("ConnectHandle","RemoteViewAlias").

HTH.

>It seems to me that Begin..End Transaction does not work with Remote Views. If this is true, how to implement Transactions in RVs?
>
>TIA
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform