CODEWITHSUNDEEP
sql-servervb.netbulkinsertsqlbulkcopy
Ezi
Ezi

Reputation: 2210

Update is being executed before BulkInsert

I wrote a program to insert some records using sqlCopy for faster processing, and then the code executes and update statement [on an other table] based on the newly inserted records.

Problem is that the update almost always executes before the insert! [about 2 seconds before.. according to the time-stamps of the insert and update rows.] the only way I could make the update execute after the insert is to put the code asleep for 2-3 seconds.. Is there a better way to make sure the insert completes before the code continues?

I even captured the RowsCopied event, the rows are instantly copied 'before' the update. but in the database the update gets in earlier.

     bulkCopy.WriteToServer(table)

     Dim Sql = "Update tbl Set Total = (select sum(qty) from Inserttbl where inId = ID)"
     ExecuteSQL(Sql)

Upvotes: 2

Views: 53

Answers (1)

Ezi
Ezi

Reputation: 2210

Found the problem... the insert timestamp was provided by the client, while the update timestamp came from the server. The clients time is 2 seconds earlier then the servers time..

I changed both should use the servers getDate function. problem solved.

Upvotes: 1

Related Questions