Re: Forms4.5: How can I show the record position in the block?

[Quoted] [Quoted] Thank you! This is the nice solution.

But one more question.

Why Forms from Developer/2000 v1.5 dysplay current position in block like '3/?' in the status bar?
After fetching all records we can see, for example, '3/134'. Why Oracle cannot dysplay count all records immediately?

stevec_at_zimmer.csufresno.edu wrote:
>
> In article <35629751.C9F03DFB_at_dd.ru>,
> "Valery A. Sorokin" <vsorokin_at_dd.ru> wrote:
> > Eric Lyders-Gustafson wrote:
> > > > How can I show the record position in the Forms block like this:
> > > > '3/134'?
<snip>
> > May be is there a method to get internal Forms variable ?
>
> You CAN use COUNT_QUERY! Just use it in the Key-Exeqry or When-Button-Pressed
> trigger that you normally use to do the Execute_Query. Just call the
> Count_Query, trap the FRM-40355 message in the On-Message trigger, and store
> the results wherever you need. Then follow the Count_Query with the "do the
> right thing" command, Execute_Query.
>
> I have done this, so I know it works. You do not need to use dbms_sql.
>
> HTH,
> Steve Cosner
> http://members.aol.com/stevec5088

-- 
Valery A. Sorokin
ProSoft, Russia, Moscow