Re: HELP - Dev2000 newbie problem

Once you get an error, go to the Help menu and choose "Display Error"

This will show you the offending SQL and error message, from which you should be able to deduce the offending block, and whether the problem is with a FK or not null column etc.

Good luck

Paul Rosenthal
paul.rosenthal_at_fastrack-it.co.uk

knunes_at_sequenom.com wrote in message <35bdf294.69040204_at_news2.cts.com>...
>I have a form with 4 data blocks in it.
>If I enter data in the first/main block everything works fine.
>If I enter data in the first block and in any other block, the insert
>works but when I try to save the new data I get an error:
>
>FRM-40508: ORACLE error: unable to INSERT record.
>
>I think this is a problem with the other blocks not creating records
>because their foreign key fields are not being copied correctly. The
>first block has a primary key that gets its data off a sequence
>(Initial Value property is set to the sequence). the remaining blocks
>all have foreign keys linking to the first block. In their
>properties, I have set the Copy Value from Item to the primary key on
>the first block.
>
>Any clues?
Received on Tue Jul 28 1998 - 13:42:14 CDT