Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copying,Views from one project to another
Message
De
20/10/1999 06:18:37
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
20/10/1999 05:55:50
Napoleon Yam
Princess Cruises: Emerald Princess
Caribbean, Philippines
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00278661
Message ID:
00278672
Vues:
14
>Sir,
> I tried again but still nothing happens, I'm suppose to see that view in the project manager right?


Napoleon,
Does your project list your new DBC ?
Let's make it again.
Suppose the DBC that you want to copy from is "db1.dbc", and that you want to copy to is "db2.dbc".
modify database db1
* This would show tables and views right ?
* Dblclick on your view would pop it up in designer
* and you would copy the SQL - you have done this part
* suppose your select statement is :
* select * from db1!table1
open database db2
* With pasting your command would be :
create sql view myview as ;
   select * from db1!table1
modify view myview && You should see your view
This copies view between DBCs. If you mean you want to use same DBC in different projects then just add the DBC to project.
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform