Announcement

Collapse
No announcement yet.

Record not found

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Record not found

    SC7_FormUpdateError2.jpg

    I have a form with several child records attached to it (either on Tabs or in blocks). When editing the form all child records can be added/deleted/updated with no problem.
    The parent table is an existing table with some data. When I try to update parent data on some fields I get an error message: RECORD NOT FOUND, although it doesn't happen always.
    There is a table called DISEASES with the structure like:;
    - ID
    - ComonName
    - ComonSubname
    - etc....



    It seems that I get this error only when I try to modify ComonName field. All other fields don't cause problems (when changed).
    When I try to change the field outside of SC App it works fine.
    Any idea what could have caused that ?

    Arthur
    Last edited by aka; 12-19-2013, 09:29 PM.
    -----------------------------------------
    Arthur Klisiewicz
    dATA POINT SOFTWARE
    www.datapointsoftware.com

  • #2
    It's because commonname is the keyfield and you can't change the keys in scriptcase. SC cannot generate a statment like update mytable set mykey={mykey} where mykey={myoldkey}.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment

    Working...
    X