Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FLUSH TABLES
Message
 
 
To
13/10/2009 22:37:43
Hee Lim Wang
Fantasy Software Enterprise
Malaysia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01429299
Message ID:
01429316
Views:
62
What SQL tables are you referring to? If you're talking about MS SQL Server and such, than any changes will be visible to other connections as soon as transaction is committed.

>We always have to flush force after replace table fields with variables in VFP
>in order to retrieve data immediately from other pc
>
>Do we also need to FLUSH TABLES after insert or update in SQL tables ?
>Which is one better FLUSH TABLES; or FLUSH TABLES WITH READ LOCK; ?
>Or do we need to sqldisconnect() to close everything and reconnect again ?
>
>Can we set auto backup data with Windows Scheduled Tasks for every 3 hours ?
>Do we always need to lock tables during backup data ?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform