Forms 6 All Detail Fields are Occasionally Empty in 1st Tab Panel Data Block

Developer 6.0 (unpatched)
Forms [32 Bit] Version 6.0.5.0.2 (Production) on Windows 98 client

Oracle 7.3.4.4.5
on Solaris 2.5.1 server

In a master-detail tabbed canvas, the first detail block's data is filled in automatically, after the master key item is retrieved.
("Join" Relation with Deferred = No, Automatic Query = Yes)

It almost always works, but occasionally (1 in 10,000) all the fields in the first detail block are empty, except the primary key copied from the master record.
(Detail Record Status is NEW instead of QUERY.)

The detail record definitely exists in the detail table. It can always be found with PL/SQL directly.

Deleting and re-entering the detail row, with exactly the same values eliminates the problem for that particular detail row.

Does anyone have any experience with this or a similar problem?

Mike Rainville
McGill University

Montreal, QC
Canada Received on Fri Jan 07 2000 - 00:00:00 CET