Re: Record not found or changed by another user


Hi,
The problem was indeed in the date stored in the datetime field. I have a datetime field in MSSQL which filled with the GetDate() function. By using the CONVERT (SMALLDATETIME , GetDate(),101) the problem was corrected. I'm not sure but I think by setting the pfInWhere ProviderFlag for the datetime field to false didn't solve the problem.

Thanks

"Bill Todd" <no@xxxxxx> wrote:
Set the pfInWhere ProviderFlag for the datetime field to false and see
if that solves the problem. Converting a SQL Server datetime value to a
Delphi TDateTime value and back frequently results in a different
number of milliseconds so the record is not found by the UPDATE
statement.

--
Bill Todd (TeamB)

.

Relevant Pages

  • Re: Record not found or changed by another user
    ... Set the pfInWhere ProviderFlag for the datetime field to false and see ... Converting a SQL Server datetime value to a ... Delphi TDateTime value and back frequently results in a different ...
    (borland.public.delphi.database.ado)
  • Re: java-dates
    ... > worth of milliseconds, then converting back. ... in places where "daylight savings time" or similar seasonal ...
    (comp.lang.java.programmer)
  • Re: getting milliseconds from a DATE
    ... Robert Klemme wrote: ... and convert it to milliseconds that have elapsed since Jan. 1, 1970, 12 ... You cannot obtain more precision out of a value in one datatype by converting it to a different datatype. ...
    (comp.databases.oracle.misc)
  • Re: java-dates
    ... converting to milliseconds since epoc, ... worth of milliseconds, then converting back. ...
    (comp.lang.java.programmer)