My SQL 2000 was unable to update

Asked By Matteo Weston 10 points N/A Posted on - 03/21/2012

I have made a database that consists of product codes with their corresponding prices. I encoded the product codes and then tried to update the database but when running the MDF file, it is still showing the updated product codes. Does anyone knows how to avoid this permanently?

 

• Status: Open
• Question Views: 838
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Gideon Yasti 15 points N/A #119449

My SQL 2000 was unable to update

Probably you don’t want to show your product code in your output stage. You should check your SQL table’s data value carefuly. You can not give the original value o there in your table. You should design you SQL table again with proper value and the function. Specially table format is very important for match with value. So i recommend you to enter your database again and delete the previous table and then create design again with proper structure. Your current table structure may fragment. So its so important to rebuild or customize it again for get actual output from that.

Thanks

About Gideon Yasti

Questions
3

Answers
316

Best Answers
69

• Vote Up 0 Vote Down

• Posted on - 04/19/2012
• Question Category: MySQL Server