Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create Remote Views.
Message
From
20/11/2001 04:04:55
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
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:
00583792
Views:
18
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform