Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 08-04-2009
Member
 
Join Date: Feb 2009
Posts: 84
Unable to keep transaction data updated in VB

Hi,

I created a transaction file in vb with data control and access that from backend. My problem is when customer enter transaction details of customer there is a chance of making wrong entry. If this wrong data try to modified , the dependent data is not going to modify.

I used the following formulas for maintaining balances of customer :
closing balance = openbal - payment + receipt
openbal = closingbal

like this , if user found that there is wrong entry in fist or second transaction if it modified the depending fields are to me modified, but it is not possible ,
so is there any program in vb to solve my problem.
Reply With Quote
  #2  
Old 08-04-2009
Member
 
Join Date: Mar 2008
Posts: 258
Re: Unable to keep transaction data updated in VB

Well, I havent worked with named instances before, but I don't see why it would work any different between linking two sql servers on different machines. As long as you link the second instance to the first instance, you can do what you need to do on the first instance, then from the first instance you can insert into the 2nd instance...

The thing is I don't know what to do to get the data from the first instance to the second instance when the first instance is changed... to keep it simple lets say the first instance holds the database for an accounting application and the table in question holds Customer address records.

The second instance holds the database for another application and has a table to hold the same data as the table from the first instance. How do I go about making the table in the second instance automatically reflect changes or additions to the table in the first instance?
Reply With Quote
  #3  
Old 08-04-2009
Member
 
Join Date: Dec 2008
Posts: 183
Re: Unable to keep transaction data updated in VB

How do u create the tables and other things...using the "Server Explorer" on VS IDE(Left hand side tool window next to toolbox).
And now here is one problem, we have MDF file attached with the server. You have to close that window prior to run it for the test.

If this doesn't work, then As you are facing problem, "Server does not allow remote connections", you need to follow some steps to enable that.
Reply With Quote
  #4  
Old 08-04-2009
Member
 
Join Date: Jan 2006
Posts: 211
Re: Unable to keep transaction data updated in VB

The application you have suggested here need to have some more explanation as well as what you need to have in the future that also should be suggested clearly,and the things about the program you want will have very lengthy code.which can not be explained overhere.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Unable to keep transaction data updated in VB"
Thread Thread Starter Forum Replies Last Post
Can?t login to Google mail in Opera 12, getting error ?Unable to complete secure transaction? PPandey Technology & Internet 2 20-09-2012 06:52 PM
Unable to complete transaction while buying Age of Empires Online (aoeo) Premium Greek AbiCgail Video Games 10 24-09-2011 11:57 PM
System failed to flush data to the transaction log Kaylynn Windows Software 3 14-08-2010 05:54 AM
Super Box gone off and popping up that data being updated archer Portable Devices 6 18-06-2010 07:13 AM
Transaction Methods From Sql Data Provider Adrina_g Software Development 5 21-01-2010 01:07 PM


All times are GMT +5.5. The time now is 04:00 PM.