Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to create Remote Views.
Message
De
20/11/2001 03:34:29
Wilfred Chan
Bnp Paribas Hong Kong Branch
Hong Kong, Hong Kong
 
 
À
20/11/2001 03:23:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00583785
Message ID:
00583787
Vues:
25
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
Fil
Voir

Click here to load this message in the networking platform