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

Right On!

         The valid salutations are Dr, Mr, Ms, Mrs but some have been entered with a period
I didn't notice.

From Developer/2000 Help

        "Any queried record that contains a value that does not match one of the values associated with an element in the list is SILENTLY REJECTED." (emphasis mine)

In case Oracle Corporation is listening:

    How about filling in the OTHER fields, the valid ones, and highlighting the INVALID ones.

That was a big help, Duncan
May God bless,
Thank-you!

Mike Rainville

Duncan Mills wrote:

> 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. "
> >
>
Received on Thu Jan 13 2000 - 00:31:41 CET