Re: Concurrency violation

Thank you for your reply. I think that it is something to do with the
datetime field and the dataset. When the dataset tries to save a row to the
database, it compares its "Original data"of the row with what is in the
database. This comparison always result in difference in the datetime field.
If there were a simple solution, there would be something in the dataset
configuration to set the rule of comparing two datetime values only upto
second. Any idea?

Thanks,
Zhuo


"Zhuo Li" <zli@xxxxxxxxxx> wrote in message
news:e8FG3VZGJHA.212@xxxxxxxxxxxxxxxxxxxxxxx
Hi, I get this error when I try to save a datatime field to the database
using OdbcDataAdapter.Update method.
oAdapter.UpdateCommand.CommandText is like: "update aTable set
effetive_from =? where primarykey=?"

The parameter related to this field is like:

oAdapter.UpdateCommand.Paramteres.Add(new OdbcParameter("effective_from",
Odbctype.datetime, 8, "effective_from");

The database is Sybase ASA 9.0. The column effective_from's type is
datatime in the database.

Any suggestions/ideas?

Thanks, Zhuo



.

Relevant Pages

  • Re: Date vs DateTime
    ... The reason why the WHEREs will not handle our DateTime is that the database ... holds accurate information down to the 6th sig decimal figure on the ... and a DateTime field was set by the other application, ... it does make a difference when you are specifing them as ...
    (microsoft.public.dotnet.framework)
  • Re: Extracting Time from the SQL DateTime field.
    ... > Any help on extracting the time part from the datetime field in SQL ... > even though i had entered only the time part in the database when i ... > Visit Topic URL to contact author (reg. ...
    (comp.databases.ms-sqlserver)
  • Re: Concurrency violation
    ... datetime field and the dataset. ... the database, it compares its "Original data"of the row with what is in ... datetime values only upto second. ...
    (microsoft.public.dotnet.languages.csharp)
  • Extracting Time from the SQL DateTime field.
    ... Any help on extracting the time part from the datetime field in SQL ... even though i had entered only the time part in the database when i ...
    (comp.databases.ms-sqlserver)
  • Re: Static pages vs CMS and the effect on SEs
    ... your site locally, and upload all pages. ... The major con of a database if you really don't need it is that your ... My site consists of several XML files (one file can include zero or more ... A second program compares each file with a local copy of my site. ...
    (alt.internet.search-engines)