Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement