Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IdleTimeout setting
Message
 
 
To
03/01/2003 16:54:05
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00737850
Message ID:
00738364
Views:
13
AFAIK, you are not opening the specified connection when you create it. You are simply adding information to the database to use when future items use the connection.

Using it to create a remote view may open the connection; however, I don't know if the timeout property is used in the development environment. It may only be valid during run-time.

HTH.

>Hi all,
>
>How does the IdleTimeout property work? Assume file paths are correct and they exist, consider the following code snippet:
>
>
>open database cMyTempDBC
>cDataDBC = 'myDataDBC.DBC'
>create connection cMyConn connstring "Driver={Microsoft Visual FoxPro Driver};UID=;PWD=;SourceDB="+;
>	cDataDBC+";SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"
>*-- set idle timeout to 5 seconds
>dbsetprop('cMyConn',"connection","idletimeout",5)
>*-- pause for 10 seconds
>wait window 'Please wait...' timeout 10
>*-- create a sql view, this works!
>create sql view rv_Table1 remote connection connect1 shared as ;
>	select * from Table1
>
>
>1. Did the IdleTimeout occur?
>2. Should I not be able to create the view after the connection has been deactivated?
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform