Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Lose Default Procedure when copying from one DBC to anot
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00300939
Message ID:
00301167
Views:
19
>I am trying to copy a table from one DBC to another DBC. The table has a default value on the Primary Key of NEWKEY('mytable'). When I do the copy: COPY TO tablename DATABASE newdb WITH PRODUCTION I thought that would do it. Am I going to have to recreate the DEFAULT after I copy the table, or is their a better way?

YOur NewKey routine is not a part of your table, it is part of the dbc, and so does not go with the table. You will have to recreate the routine in the new database. There are ways you can do this programmatically, but they are not easier than cut and paste...
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform