Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create Remote Views.
Message
From
20/11/2001 03:34:29
Wilfred Chan
Bnp Paribas Hong Kong Branch
Hong Kong, Hong Kong
 
 
To
20/11/2001 03:23:55
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00583785
Message ID:
00583787
Views:
24
Hi,

You can do as usual. First create a DSN.
e.g.
create connection test1 connstring
"Driver={Microsoft Visual FoxPro Driver};UID=;PWD=;SourceDB=test1.DBC;SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"

then, create Remote view
create view test1 remote connection "test1" as select * from ...

Is that what you want ?

Wilfred

Hi Guys!
>
>is there a way on how to create remote views which is bound to a .dbc file programmatically?
>
>I have this table, masterfile.dbf which is bound to myfiles.dbc. From this table, I would like to create a remote view named as masterfilerv which will be bound to myrvfiles.dbc.
>
>How will I do this programmatically? The main objective of this program is to create more than 70 remote views from tables which are bound to a database and bound those remote views to another database.
>
>I hope you will take interest on my question...
>
>Thanks in advance.
Previous
Reply
Map
View

Click here to load this message in the networking platform