Forms 6 FRM-40350 Auto Query, All Detail Fields Occasionally Empty in 1st Tab Pane Data Block
Date: Tue, 11 Jan 2000 22:01:34 GMT
Message-ID: <387BA83B.B6B5BA72_at_musica.mcgill.ca>
[Quoted] 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?
It consistently generates a FRM-40350 error
"The current query fetched no records from the table.
The table is empty, or it contains no records that meet the query's
search criteria.
No action is necessary. "
In each of the seven cases encountered so far (out of ~100,000 records)
the data exists in the table and just doesn't show up in the form. The
table is
not empty. It contains all the needed values under the required search
criterion
which is a single key value.
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
Mike Rainville
McGill University
Montreal, QC
Canada
Received on Tue Jan 11 2000 - 23:01:34 CET