Re: Capture INSERT statement from DEV2000??
From: mjc <cavett_at_globalnet.co.uk>
Date: 1997/03/30
Message-ID: <01bc3d2d$3dcb7d60$a9567ec2_at_cavett.globalnet.co.uk>#1/1
Date: 1997/03/30
Message-ID: <01bc3d2d$3dcb7d60$a9567ec2_at_cavett.globalnet.co.uk>#1/1
Have you tried using the 'show error' key? Then cutting and pasting the reported code into a SQL*Plus session. (On a VT200 layout this used to be PF3 - use 'Show Keys' for your layout)
-- - Martyn Cavett Senior ORACLE Analyst LGT Asset Management London, England. home: cavett_at_globalney.co.uk Clyde Taeger <clyde.taeger_at_sympatico.ca> wrote in article <01bc3bb9$a5949d20$0bf9acce_at_clyde.taeger.sympatico.ca>...Received on Sun Mar 30 1997 - 00:00:00 CET
>
> 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 <snip>
> 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.
>
> Thanks.
>
>