Re: Forms 4.5 error!!

Jody Lewis wrote:
>
> What is the proper way of being able to query up, enter, and modify records in
> Forms 4.5?
>
> We keep encountering an 'Unable to INSERT record' error and cannot dtermine what
> is going wrong.
>
> Can anyone give me a place to check to see what is coded wrong in this form??
>
> Also, could you please email me the response along with posting it??
>
> Thank you in advance.
>
> Jody Lewis

Jody,
After the error occurs, Click the Help menu item, then Display Error. This will usually show the statement causing the error. 'Unable to insert record' could mean that the user does not have insert permission on the table, or the table does not exist. If it does exist, then perhaps a (public) synonym is necessary. Another possibility is that you are trying to insert data that does not meet come constraint of the table. For instance, I once got this error when trying to insert text into a varchar2(2000) field that was more than 2000 characters. When I deleted some text, the insert worked.

Martin Bronstein Received on Sun Jun 22 1997 - 00:00:00 CEST