>>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 >>>>