Problem deleting rows from tables if ID field a GUID

Discussion in 'ASP .Net Web Services' started by hbennett, Aug 31, 2005.

  1. hbennett

    hbennett Guest

    If I try to delete a row from a table using the uniqueidentifier in the ID
    field it will not delete the first one. On the second try to delete a row it
    reports back that "This row has been removed from a table and does not have
    any data. BeginEdit() will allow creation of new data in this row." but the
    row really deletes and then the deletes work from that point on. I can
    reproduce the problem using a text delete sql command or using a stored
    procedure. I do not have the same problem if the ID field is an integer. I
    do not have the problem if I use SQL Analyzer or connect directly using
    Access with the same user privileges as the user. SQL Server 2000 (SP4) and
    the latest updates on Server 2003.

    Any suggestions
     
    hbennett, Aug 31, 2005
    #1
    1. Advertising

  2. hbennett

    u260044 Guest

    Problem solved. Added instead of removing event handler
    --
    Eagle Eye


    "hbennett" wrote:

    > If I try to delete a row from a table using the uniqueidentifier in the ID
    > field it will not delete the first one. On the second try to delete a row it
    > reports back that "This row has been removed from a table and does not have
    > any data. BeginEdit() will allow creation of new data in this row." but the
    > row really deletes and then the deletes work from that point on. I can
    > reproduce the problem using a text delete sql command or using a stored
    > procedure. I do not have the same problem if the ID field is an integer. I
    > do not have the problem if I use SQL Analyzer or connect directly using
    > Access with the same user privileges as the user. SQL Server 2000 (SP4) and
    > the latest updates on Server 2003.
    >
    > Any suggestions
    >
     
    u260044, Sep 3, 2005
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. John Doe
    Replies:
    0
    Views:
    373
    John Doe
    Mar 6, 2005
  2. Patrick.O.Ige
    Replies:
    0
    Views:
    678
    Patrick.O.Ige
    Nov 3, 2005
  3. Harry Barker
    Replies:
    2
    Views:
    521
    Alf P. Steinbach
    Apr 19, 2006
  4. James Edward Gray II

    RSS Guid Field

    James Edward Gray II, Jul 28, 2006, in forum: Ruby
    Replies:
    4
    Views:
    124
    James Edward Gray II
    Aug 1, 2006
  5. crea
    Replies:
    2
    Views:
    417
    Nobody
    Dec 28, 2012
Loading...

Share This Page