Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yad93fr
Starting Member
5 Posts |
 Posted - 2013-12-17 : 06:20:35
|
| hi all,I'm in challenge for make a change in a application that use :SQL server 2005 on win2000 server computer. It is a private commercial saled products management application write in VB ( iam not the creator..) with vb studio 2005.My job today is to change the Taxe applied built in it.I got access to the source code.the problem is that I localize the table contained taxe's datas.One taxe table with 3 field: keyTaxe, CodeTaxe and TaxeValue.This table contening only one registration : 1 , 1 , 19.6All other field in the database seem like referencied to this taxes table.So I try and change value of the TaxeValue field using sql statements. the new value is 20.00 making a query and the value seem to be update in this taxe table.But when use my application create a new invoice report with new articles no change is effective. the invoice report fields stay with old taxe value (19.6).report are used Crystal report features and create report dataset in xml file. The xml field do not match also the db change taxe value??where can I search for fix this? Is someone can help please... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-17 : 08:02:35
|
| You need to rerun process which will update xml document with latest value from the table. Then your xml should reflect latest value.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
my app do not matched the changes make in my DB