Data error with MSSQL and bcp

[Cole Davisson]

We are attempting to convert data from a client's installation of our old
package, to our new package written in Delphi. The old data is kept in
proprietary files, and we are converting it by dumping the contents of the
files into comma-delimited text files and then using bcp to copy the data
from the text files to a MSSQL server.

This scheme appears to work well, the data is transferred into MSSQL tables
without errors, and the data can then be viewed from within our software,
or from within database desktop.

The problem arises when an attempt is made to modify a record that was
transferred in. If the edit is made from within database desktop, or
within the posting module of our software (which uses TTables), then an
error message is displayed saying, "Couldn't perform the edit becuase
another user changed the record." I know that no other user has connected
to this database during my session, so this message is not being generated
by a legitimate problem. Also, if the edit is attempted by using an
'update' SQL statement in database desktop, the edit is performed without a
hitch.

Can anyone suggest what the source of this error might be, and how I can
avoid it. Unfortunately, doing all of the modifications via SQL is not
currently an option. We are working that direction, but I need to find a
workaround for the interim.

Thanks for any help.

Cole Davisson
Orion Microsystems, Inc.
nom...@orionca.com