Re: Forms 6.0 : Problem inserting record

On Fri, 30 Jun 2000 07:53:18 GMT, Guillaume Serre <guillaumeserre_at_hotmail.com> wrote:

>Hi,
>
>I have a forms 6.0 form based on an Oracle 7.3.4 table.
>Insert sometimes fails with the error FRM-40508 : Unable to insert
>record.
>Shift F1 displays unreadable characters in "SQL Statement in error",
>and the Error box displays "ORA-01403 : No data found". It doesn't
>happen every time, if I close the form and reopen it the insert works.
>I'm sure the PK constraint isn't violated (I use a sequence), and the
>table has no other constraints. It really looks like a bug, but is it a
>bug in the server 7.3.4 (AIX) or in forms 6.0 (NT) or in server 7.3.4 +
>Forms 6.0 ?
>
>I hope you understand my english. Any help is greatly appreciated.
>
>Guillaume Serre (Clermont Ferrand, France)

In my case the problem is solved.
In my form (workbook with a context canvas), the field 'demande_object' is display 3 times (demande_object_ctx, demande_object and demande_multi). One is the main (demande_object) and the 2 other are synchronize with. BUT the field demande_object_ctx was set as database item = YES and column_name = DEMANDE_OBJECT but the synchronize with was not set. After the correction of this property, the form work correctly.
So if you have mirror item check carefully this property.

Morality: if you have an ORA-01403 with unreadable message, the reasons could be various.

-- 
Luc Bosman
DEV/2000 Software Engineer
Database and Network Administrator
l.bosman_at_wanadoo.be
ICQ 37011625          http://users.skynet.be/kobukai/
 ---------------------------------------------------- 
|  -°)                                          (°-  |
|  /\\  Linux the choice of the GNU generation  //\  |
| _\_v                                          v_/_ |
 ----------------------------------------------------