Concurrency violation



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: Concurrency violation
    ... oAdapter.UpdateCommand.CommandText is like: "update aTable set ... The database is Sybase ASA 9.0. ... There are multiple descriptions of how to handle ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Database does not take time value
    ... there is no time value in a database. ... So you would use a string or a datatime field where you know that you have ... Cor ...
    (microsoft.public.dotnet.languages.vb)
  • Re: ASA unload/reload question
    ... Sybase ASA 9 database using the unload/reload technique. ... Has your usage pattern changed enough that you are sure it won't ...
    (comp.databases.sybase)
  • ASA unload/reload question
    ... Sybase ASA 9 database using the unload/reload technique. ...
    (comp.databases.sybase)
  • Re: ASA unload/reload question
    ... Sybase ASA 9 database using the unload/reload technique. ... Has your usage pattern changed enough that you are sure it won't ...
    (comp.databases.sybase)