Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Handling 1:M:M with views
Message
From
06/02/1999 21:04:49
Kenneth Downs
Secure Data Software, Inc.
New York, United States
 
 
To
05/02/1999 18:10:04
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00184085
Message ID:
00184772
Views:
22
Dragan,

>> Just a WAG: why not do an implicit TableUpdate() on all the views, and wrap it all in a transaction - so if the user changes his
mind and abandons the whole three-generation-dynasty stuff, simply rollback. <<

Do TRANSACTIONS lock tables and/or records or generally do things we don't like to worry about any more with Optimistic buffering?

Also, although I am native VFP right now, will my BEGIN/END TRANSACTION be respected by Oracle or SQL Server when I upsize?
Previous
Reply
Map
View

Click here to load this message in the networking platform