N/APosted 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?
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.