Modifications to PRODUCTS database TABLES

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I have a need to modify the tables in the PRODUCTS database.  Specifically, I need to add columns to "Products" and/or "Manufacturers"  tables.  Has anyone done this?  Can it be done without messing up SALESCART?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
wesonline Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: August/25/04 Location: United States Status: Offline Points: 23	Post Options Post Reply Quote wesonline Report Post Thanks(0) Quote Reply Topic: Modifications to PRODUCTS database TABLES Posted: September/21/05 at 9:02am
	I have a need to modify the tables in the PRODUCTS database. Specifically, I need to add columns to "Products" and/or "Manufacturers" tables. Has anyone done this? Can it be done without messing up SALESCART?

Techno Geek Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Evil monkey living in my closet! Joined: March/11/04 Location: United States Status: Offline Points: 1206	Post Options Post Reply Quote Techno Geek Report Post Thanks(0) Quote Reply Posted: September/21/05 at 11:51am
	I think that would break the relationship in the database if you were to do anything with the Manufacturers table. If you change the column name in the products table and if the ASP page refers to the column name, then the page will not work. That is about the worst that can happen and even then you can modify your ASP script not to refer to the column name
	Techno Geek Customer Support Engineer ComCity and SalesCart Technical Support