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.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao