Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467

    Unanswered: FRM-40356: Invalid number in example record

    Setup: forms 9i, db 9i (9.2.0.4.0)

    I am getting the following error:
    ----------------------------------------------------------
    FRM-40356: Invalid number in example record. Query not issued.

    Cause:__In Enter Query mode, you entered an invalid number in the example record.

    Action:__Correct the entry and retry the query.
    ----------------------------------------------------------
    I am getting this error as the result of a master detail population trigger which of course means there is no "entry" for me to fix. Any thoughts on what this might be caused by?
    NOTE: Please disregard the label "Senior Member".

  2. #2
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    I figured it out. One of those "the message was not even in the same timezone when it came to indicating the problem". The definition of the join fields did not match. The master was char the detail number (should have been char).
    NOTE: Please disregard the label "Senior Member".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •