Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Making database readonly
Message
From
29/04/2002 13:27:06
Walter Meester
HoogkarspelNetherlands
 
 
To
29/04/2002 11:51:47
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00649739
Message ID:
00650488
Views:
22
Hi doug,

>Assuming you're not using offline view (which would need a writable DBC), the only thing I can think of that could possibly be an issue is transactions. I haven't tested this, so it might not be an issue at all, but I think the DBC is used to temporarily store information while a transaction is in progress.

I've done a little test on the command window. Just typed BEGIN TRANSACTION, did a cascade delete and cascade update in various tables and type ROLLBACK. The changes rolled back perfectly, so I guess this would be safe.

I've noted the TransactionLog record (2nd record) in the database too. But since on the network several transactions can be active at the same time, I don't think this record is use for this, unless the record is buffered and the changes in the log only exist in memory.

Walter,
Previous
Reply
Map
View

Click here to load this message in the networking platform