Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Backlinking a table from a program?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Backlinking a table from a program?
Divers
Thread ID:
00193557
Message ID:
00193557
Vues:
50
I think I already know the answer to this one, but I'm hoping I missed something. Is there anyway to programmatically create a backlink from a table to a database? The table already exists in the database, so ADD TABLE isn't going to work.

Just to give some background, I've got a web page that uses data that has been compiled the night before. Every night around 11:30pm the information is transferred to our web server (ie. just using COPY). Now one of those tables copied over needs to be part of a database (I've got a bunch of views based on the table). The way it's looking right now, I'll have to remove the table from the database, copy over the new table, ADD TABLE to get it back, then manually recreate all the views. A nice one line command would be preferred ;-)
-Paul

RCS Solutions, Inc.
Blog
Twitter
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform