Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to create Remote Views.
Message
De
20/11/2001 04:04:55
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
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:
00583792
Vues:
19
>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.

Mike,
When you do that in designer a lot off db and cursor properties are written for you. Create one in designer first. Then run home()+'tools\gendbc\gendbc' to get programmatic version of your dbc in which your view reside. Strip code that defines your connection and view.

You could make hardcoded view and connection names be parametric and call 70 times (palcing into an array perhaps) with your new names.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform