>I have installed a version of a program I have made on a machine. I have since added a stored procedure to this program on a different machine. I just want to copy the new executable over to the other machine. The executable that I make after this doesn't take the stored procedure with it. I know it is stored in the .DBC file, but there is data entered into the tables of the previous version. So I can't copy the .DBC file over. I was wondering how I could get the new stored procedure to be used by the old database without affecting old data.
>
>Thanks in advance,
>Tyler
If the rest of the database structure is exactly the same, you can copy the dbc, dct, and dcx files over- they don't hold any actual data, just metadata.
Make a backup first. If for whatever reason this doesn't work, you can copy the contents of the SP code field in the SP record in the dbc, and open the new dbc as a table, locate the SP record, and replace the contents. You will have to issue a COMPILE DATABASE afterwards (or copy the ObjCode field as well).
Erik Moore
Clientelligence