Re: Capture INSERT statement from DEV2000??

On 28 Mar 1997 20:47:38 GMT, "Clyde Taeger" <clyde.taeger_at_sympatico.ca> wrote:

>
>I have a question related to Developer 2000 / Personal Oracle. Recently I
>wasted about 5 Hours trying to figure out why I was unable to save a record
>in a Form. When ever I tried to save a new record, I got the message:
>
>'FRM-40508 ORACLE error: Unable to INSERT record.'
>
> Try debugging this, where the heck do you start.
 

>Does anyone out there have any idea as to how I can capture the INSERT
>statement Dev2000 sends to the back end prior to the actual INSERT. It
>would have much easier to isolate the problem by taking that statement and
>passing it through SQL Plus instead.
>
Look (when you get the error-message) at the insert-statement in Help-menu --> Display error
There you will see the insert-statement that Forms (generated and) wants to send to the database.
May be you did have an item in the block that was a non-database item and you didn't turn the property "base-table-item" to FALSE? Forms generates the insert-statements (and updates and deletes...) by looking at the base-table-blocks and base-table-items in your form. So you need to set your properties correct. Hope this helps a bit.
Lucy Received on Mon Mar 31 1997 - 00:00:00 CEST