Re: Forms 6 FRM-40350 Auto Query, All Detail Fields Occasionally Empty in 1st Tab Pane Data Block

[Quoted] If you have a list item in the detail block, it may be that the problem records have a value which is not present in the list and the "Other Values" property is not set. If this is the case then the record will not match and will not be returned.
So if you have a list item check it's values against the data actually in that table.

--
Regards
Duncan Mills
Oracle Enterprise Internet Tools - Product Management

Mike Rainville <ccre_at_musica.mcgill.ca> wrote in message
news:387BA83B.B6B5BA72_at_musica.mcgill.ca...


> 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

>