Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FLUSH TABLES
Message
From
14/10/2009 21:07:25
 
 
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:
01429449
Views:
49
>Hi
>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 ?

FLUSH Tables is for visual foxpro tables that using buffering mode :)
MYSQL,M$ SERVER ..&.etc...you are sending data+command for tht RDBMS to handle itself :)
Previous
Reply
Map
View

Click here to load this message in the networking platform