I think this is my first question here.
My web application uses an Access database and I'm getting some strange behaviour which might be related to that. Here's the issue:
At the end of processing a users request (during which a lot of calculations are done), a record is updated with a status value indicating the success of the calculations. At the same time an error message and date/time are updated.
The web page uses a FormView to display the results of the calculations but I sometimes don't see the correct value for status and date.
So for example, the calculations could fail but the web page shows the values in the database before they were just updated.
This doesn't always happen, it seems to be an intermitent problem.
I have tried putting a delay in after the record is updated and that seemed to help but it didn't eliminate it.
sql = "UPDATE QuoteDetail SET" sql &= " Status = " & status & ", ErrMsg='" & Utilities.fixSingleQuotes(errMsg) & "', CalcDate = NOW()" sql &= " WHERE RevisionID=" & revisionID cmd.CommandText = sql cmd.ExecuteNonQuery() System.Threading.Thread.Sleep(0)
Any help/ideas greatly accepted as this is causing my customer a major headache!
Oh, yes we will move to SQL Server one day but not right yet