Need Forms 5.0 help with inserting record

From: Ryan <"rrichards[NO>
Date: Wed, 27 Jan 1999 16:04:57 -0600
Message-ID: <36AF8D89.C48B4AD5_at_benham.com>



[Quoted] I have created a form from single table (just to get familiar with forms)
in forms 5.0 that does the following:

Takes an employee ID (actually this is not enabled. Its initial value is set to a sequence and it works fine).
Takes a first name, last name, job title, and phone number.

My problem is that even though I have verified the dataypes and sizes between the form and the table I cannot get the form to insert the data. If I have the item property set to Primary Key = Yes on Employee ID (which it is) then It keeps telling me record has already been inserted. THis is not true however. If I set the proprty to say Primary key = No then I get the FRM-40508 error. I have tried inserting the data manually in SQLplus as the SAME USER and it works fine. ANY HELP would be appreciated.

Ryan
  Received on Wed Jan 27 1999 - 23:04:57 CET

Original text of this message