General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only