471,305 Members | 1,577 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,305 software developers and data experts.

Update a database

Hello, I have an application that sends a transaction across a Domain (on a
LAN) to another computer inside the domain that is functioning as a
Datastore. When the transaction is sent to the datastore it is always
successful, but 90% of the time the first 3 entries (Paramaters) are being
duplicated from the previous transactions.i.e.

InsertCommand.Text = "INSERT INTO Customers
Values(?,?,?,?,?,?,?,?,?............)"
Parameter(0).......
Parameter.Value= IDNumber
Parameter(1).......
Parameter.Value = CustomerAccountNumber.Text
Parameter(2)......
Parameter.Value = txtLastName.Text
etc.
etc.
etc (About 110 Parameters, Above example is not actual code just brief
idea to explain the problem)

when this command is wrapped in a transaction or simply sent to the
datastore. The querry is sucessful, but alot of the time the IDNumber will
be good, but the CustomerAccountNumber (Built on the fly) and the
txtLastName are being duplicated from the previous customer information. I
have noticed it is only happens to the first 3 or 4 fields. I am sure that
the form has different data but the database is showing (When I view it)
that there are multiple individuals with the same account number.

Could this have something to do with the network?

The network is using DHCP and the DSN for each computer on the network are
routed to the Datastore IP and the Domain Computer's IP.

Any suggestions will be greatly appreciated.

Thanks,

Chuck
Jul 21 '05 #1
0 954

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Mark | last post: by
reply views Thread by Vijay Balki | last post: by
8 posts views Thread by Zorpiedoman | last post: by
3 posts views Thread by Michel Esber | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.