Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursors and Transactions
Message
From
23/10/2003 06:56:32
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
23/10/2003 06:06:21
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00841459
Message ID:
00841470
Views:
18
>Hi,
>
>On help is write :
>". Transactions are supported only for tables in a database. "
>
>Remote View support VFP Transactions ( are virtual tables in a database but with CREATEOFFLINE(ViewName [, cPath] they are true tables).
>
>The positive point is this:
>
>SPT cursors, are not within a DBC, and support transaction !
>
>
>Question: It is by design or no ?
>
>If it is by design, why VFP cannot support Transactions on local Cursors ?
>
>This seems useless because a cursor is exclusive;
>but is much profit in order to manage complex ( multicursors ) but partial modifications to cancel during one session of editing.
>
>Fabio

Fabio,
There isnt a difference between a cursor and a table other than VFP's housekeeping. Create a temp dbc and tables within it instead of cursors and there you go.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform