Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replacing table in dictionary (DCT)

Status
Not open for further replies.

newtoclarion

Programmer
Jul 20, 2011
66
SA
Hello everybody,
I have a table in a dictionary which contains so many fields. Now I changed my Database driver from TPS to SQL.
What I want is to import the structure from SQL in place of the existing TPS without affecting the Application.

If I rename the old table, all the table names in all screens in the APP will be replaced with the new name and still using the TPS table.
Also deleting it and importing the new one for SQL will delete the table from the procedures in APP. Changing the structure manually is hard because I have many date fields that should be changed to group.

Any suggestions are highly appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top