Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Backlinking a table from a program?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Backlinking a table from a program?
Miscellaneous
Thread ID:
00193557
Message ID:
00193557
Views:
49
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
Next
Reply
Map
View

Click here to load this message in the networking platform