• Replies 4 replies
  • Subscribers 336 subscribers
  • Views 90 views
  • Users 0 members are here
Related

Custom Tab Not Allowing Updates to Data

Sheila Collins
$organization

Good Day,

I've created a custom tab to enter data into local table - it lets me add, but we better get it right the first time because it will not let us update... The error:

Row changed between retrieve and update.

Comes up. Security seems correct, tr_custom_tab looks good (at least I think so).... any help appreciated.

Thank you.

  • $organization

    you can google this error.(Row changed between retrieve and update.)

    it is a standard powerbuilder error.

    I pick up something here:

    gajender_99:
    When the table has identity column, the column is marked as key-column but it is not marked as identity column in datawindow update properties:
    When You insert a new column and update it succesfuly, the row is inserted, but its new identity value is not got from the database.

    When You will change this row immediately an update, then update() function generates update or delete command with ".. where identity_column is null".

    The identity_column has got a new value, but datawindow does not know about it. You have to mark this column as "identity" in datawindow painter update properties.

     

     

    So, my suggestion is open a sql profiler try to catch the T-sql statement. I think it should have something to do with id_key. Customer tab must have these two fields "customer_no, id_key".

    have fun

    :-):-);-)

     

  • $organization in reply to Ben Gu

    Thanks Ben.  It was my identity key and I’ve corrected it. 

     

    Fun? Yeah that’s it…. J

     

    Sheila

     

    From: Ben Gu [mailto:bounce-bengu4278@tessituranetwork.com]
    Sent: Monday, May 18, 2009 1:52 AM
    To: Sheila Crossman
    Subject: Re: [Tessitura Technical Forum] Custom Tab Not Allowing Updates to Data

     

    you can google this error.(Row changed between retrieve and update.)

    it is a standard powerbuilder error.

    I pick up something here:

    When the table has identity column, the column is marked as key-column but it is not marked as identity column in datawindow update properties:
    When You insert a new column and update it succesfuly, the row is inserted, but its new identity value is not got from the database.

    When You will change this row immediately an update, then update() function generates update or delete command with ".. where identity_column is null".

    The identity_column has got a new value, but datawindow does not know about it. You have to mark this column as "identity" in datawindow painter update properties.

     

     

    So, my suggestion is open a sql profiler try to catch the T-sql statement. I think it should have something to do with id_key. Customer tab must have these two fields "customer_no, id_key".

    have fun

    :-):-);-)

     

    From: Sheila Crossman <bounce-sheilacrossman3944@tessituranetwork.com>
    Sent: 5/7/2009 10:27:32 AM

    Good Day,

    I've created a custom tab to enter data into local table - it lets me add, but we better get it right the first time because it will not let us update... The error:

    Row changed between retrieve and update.

    Comes up. Security seems correct, tr_custom_tab looks good (at least I think so).... any help appreciated.

    Thank you.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • $organization in reply to Sheila Collins

    Hi

    Sorry to hijack. I'm having this same issue and having googled the problem it seems I can fix it by going to the datawindow's Update Properties. How do I get to this? I can't find it anywhere!

    Thanks

    Siobhan

  • $organization in reply to Siobhan Parker (Past Member)

    No problem. For me it turned out to be a problem with my custom table, I didn’t have an identity key.  Then  when I went to add it and redo a couple of things, I ran into a bunch of weird stuff (nice word for it), so I started over.

     

    I ended up recreating my local table with the identity key correct from the beginning, recreating the window and haven’t had that problem. I didn’t have to do anything special in Infomaker’s datawindow property.

     

    Hope this helps.

     

    Sheila

     

    From: Siobhan Bennetts [mailto:bounce-siobhanbennetts3867@tessituranetwork.com]
    Sent: Friday, May 22, 2009 8:52 AM
    To: Sheila Crossman
    Subject: Re: [Tessitura Technical Forum] RE: Custom Tab Not Allowing Updates to Data

     

    Hi

    Sorry to hijack. I'm having this same issue and having googled the problem it seems I can fix it by going to the datawindow's Update Properties. How do I get to this? I can't find it anywhere!

    Thanks

    Siobhan

    From: Sheila Crossman <bounce-sheilacrossman3944@tessituranetwork.com>
    Sent: 5/18/2009 7:09:49 AM

    Thanks Ben.  It was my identity key and I’ve corrected it. 

     

    Fun? Yeah that’s it…. J

     

    Sheila

     

    From: Ben Gu [mailto:bounce-bengu4278@tessituranetwork.com]
    Sent: Monday, May 18, 2009 1:52 AM
    To: Sheila Crossman
    Subject: Re: [Tessitura Technical Forum] Custom Tab Not Allowing Updates to Data

     

    you can google this error.(Row changed between retrieve and update.)

    it is a standard powerbuilder error.

    I pick up something here:

    When the table has identity column, the column is marked as key-column but it is not marked as identity column in datawindow update properties:
    When You insert a new column and update it succesfuly, the row is inserted, but its new identity value is not got from the database.

    When You will change this row immediately an update, then update() function generates update or delete command with ".. where identity_column is null".

    The identity_column has got a new value, but datawindow does not know about it. You have to mark this column as "identity" in datawindow painter update properties.

     

     

    So, my suggestion is open a sql profiler try to catch the T-sql statement. I think it should have something to do with id_key. Customer tab must have these two fields "customer_no, id_key".

    have fun

    :-):-);-)

     

    From: Sheila Crossman <bounce-sheilacrossman3944@tessituranetwork.com>
    Sent: 5/7/2009 10:27:32 AM

    Good Day,

    I've created a custom tab to enter data into local table - it lets me add, but we better get it right the first time because it will not let us update... The error:

    Row changed between retrieve and update.

    Comes up. Security seems correct, tr_custom_tab looks good (at least I think so).... any help appreciated.

    Thank you.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!