Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copying,Views from one project to another
Message
From
20/10/1999 06:18:37
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
20/10/1999 05:55:50
Napoleon Yam
Princess Cruises: Emerald Princess
Caribbean, Philippines
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00278661
Message ID:
00278672
Views:
15
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform