Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving a view
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00064118
Message ID:
00064128
Views:
30
>Is there a way to copy a view from one database to another, assuming the second database has all the necessary tables with all the right fields?
You could this:
open your source .dbc as a table with USE mydatabase.dbc
browse the table and locate the record pointer on the view's record
SCATTER MEMVAR MEMO
open the destianation database with the database designer
create a bogus view
close it, open it as a table like above.
RELEASE m.objectid, m.parentid
browse the destination table and position the pointer on the new bogus view
GATHER MEMVAR MEMO

this will copy the view record from one .dbc to the other, but allow the destination .dbc to create its own parentid and objectid numbers.

There could be a built in function to do all this automatically, but it would be news to me.
BE SURE AND MAKE A BACKUP OF YOUR DBC FIRST!!!! Good Luck, and if you try this, let me know if it works.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform