Re: FRM-41092 No records in block ...

[Quoted] Even though it is not a database block, ther can be many records within the [Quoted] block. Being a da5tabase blocvk means to Forms 'shall I generate DML statements at commit time?'. The block can still hold data.

In order to help determine the exact cause, we'll need a little more information. What buitling is being called to cause the error to appear, or [Quoted] what button are you pressing and from which field in which block etc etc. Any triggers firing as a result of that key press. At the end of the day it [Quoted] will be a line of PL/SQL or a stanadrd builting causing the error, whcih one is it?

[Quoted] Also, you didn;t answer the question of whether there is a record in the block or not. Try navigating to the record before you do whatever cause the [Quoted] problem. This will cause a 'new' record to be created in the block so the block will then have at least one record.

"iulian" <4spam_at_mail.com> wrote in message news:ZfRv9.105904$mxk1.78871_at_news04.bloor.is.net.cable.rogers.com...
> Hi Alan and thanks.
> What do you mean by having one record in the block?
> Like I said there is not a database block (Database Data Block = No) and
it
> did work before. Actually there are 2 more blocks in the module that
aren't
> database typed and I get the message only for this particular block. I
even
> select all three blocks and check for the properties and the only
different
> one is Name.
> I developed this application using Forms 6 and it worked,; now after I
> install Forms 6i no more working app. I must say it's a bit frustrating...
>
> iulian
>
>
> "Alan Mills" <Alan.Mills_at_nospamservices.fujitsu.com> wrote in message
> news:apoa60$2pe2$1_at_news.icl.se...
> > Ensure that you have at least one record in the block before you attempt
> to
> > use any of the buttons in it. If your display item(s) show some details
> > then you will have at least one record and so no problems that I can
> > foresee. What worries me is that it seemingly worked before. Arer you
> sure
> > you are performing the same test?
> >
> > "iulian" <4spam_at_mail.com> wrote in message
> > news:b3Lv9.103083$mxk1.76534_at_news04.bloor.is.net.cable.rogers.com...
> > > Hi guys. Can someone help me out with this?
> > > I have an application which ran okay with Forms 6 but when I try it in
> > Forms
> > > 6i I get an error FRM-41092 No records in block <a_block_name> The
block
> > > <a_block_name> isn't a database one and contains only command controls
> > > (buttons, display items, etc). I don't understand what might be error.
> > > Thanks for your time.
> > >
> > > iulian
> > >
> > >
> >
> >
>
>
Received on Wed Oct 30 2002 - 17:09:06 CET