Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Moving a view
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00064118
Message ID:
00064128
Vues:
25
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform