Re: trigger to fire when navigating records

"Fred van Nimwegen" <fred.vannimwegen_at_wanadoo.nl> wrote in message news:400700b3$0$35149$1b62eedf_at_news.euronet.nl...
> Try the when-mouse-click and when-mouse-move triggers on block level
> check the mouse position and when this is whithin the scrollbar you can
get
> the recordnumber of the top record and the cursor record and navigate in
the
> cursor to the new top record
>

I'm using Forms 6i and tried this approach, it wouldn't fire either of those triggers at the block or the the Form level. Maybe I'm doing something wrong, but it seems like it's a weird quirk of forms. Try it and see if you get different results.

--Aaron V

>
> "Aaron V" <Tinkerist_at_hotmail.com> schreef in bericht
> news:WWoJb.719437$HS4.5228893_at_attbi_s01...
> > I did get around to trying this out and it works great, except for one
> > thing. I can't seem to be able to find a trigger to fire when one is
> > navigating between records in some places, like when you have, 20
records
> in
> > a block and 10 are displayed, and the current record is the 12th record
> and
> > it is the 5th record from the top. The Scrollbar Indicator will be
> floating
> > somewhere in the middle of the scrolbar. If one where to click the up
or
> > down scrollbar buttons, the current record will change position, but it
> will
> > still be the current record(won't fire the when-new-record trigger, or
> > new-item-instance). So when this happens I have the formatting Item out
> of
> > Physical sync with the original Item(it stayed in the same position, but
> the
> > record moved up or down). I've tried this with every trigger I can
think
> > of, but none seem to fire in this scenario.
> > forms 6i/Oracle 9i
> >
> > Thank for any help,
> > --Aaron V
> >
> >
> > Thanks mcs for your reply,
> > this sounds like a great idea, especially because you could use this
> > technique for almost any of the Set_Properties that can't be set for the
> > instance. Thanks so much, and I'll give it a try.
> >
> > --Aaron V
> >
> > "mcstock" <mcstockspamplug_at_spamdamenquery.com> wrote in message
> > news:1cSdna8Kt-PgKF2iRVn-sw_at_comcast.com...
> > > i assume you're using forms, and assume you're at using at least
release
> > 6i
> > > (don't forget to be specific in you next post)
> > >
> > > 'when-validate-item' is the typical trigger for detecting change at
the
> > item
> > > level. see also when-validate-record and when-validate-form
> > >
> > > the SET_ITEM_INSTANCE_PROPERTY 'built-in' is the closest to what you
> want
> > to
> > > do as far as setting the attributes of one occurrence of a multi-row
> item,
> > > but it does not appear to support changing the format
> > >
> > > however, this can be simulated with a mirror ('synchronize with') item
> in
> > > the same block -- the implementation is not pretty but it can be made
> > > generic, and hence, reusable
> > >
> > > basic steps:
> > > 1) create a block item with its 'synchronize with item' property set
to
> > the
> > > number item
> > > -- no format mask in this item
> > > -- important: set its 'number of items displayed' property to 1
> > > -- position the item exactly on top of the number item (same x, y,
> width)
> > > 2) create a WHEN-NEW-RECORD-INSTANCE trigger on the block that
positions
> > the
> > > item (this code should be implemented in a reusable program unit, but
> see
> > > if you can get it working in the trigger first)
> > > -- set the y_pos based on:
> > > ---- the SYSTEM.TRIGGER_RECORD
> > > ---- block property TOP_RECORD
> > > ---- height of the item (can get dynamically with GET_ITEM_PROPERTY)
> > > ---- item property distance between records (must be hard-coded,
cannot
> > get
> > > with GET_ITEM_PROPERTY)
> > > 3) set 'keyboard navigable' property of the number item to 'No'
> > > 4) create a WHEN-NEW-ITEM-INSTANCE trigger on the number item to set
the
> > > focus to the edit item (using GO_ITEM)
> > >
> > > let me know if you need additional assistance, but if you know PL/SQL
> and
> > > can use on-line help this should give you enough to go by
> > >
> > > -- mcs
> > >
> > > "Aaron V" <Tinkerist_at_hotmail.com> wrote in message
> > > news:pPTvb.81853$Dw6.391391_at_attbi_s02...
> > > | Greetings,
> > > | Does anyone know a good way to exclude the commas when editing a
> number
> > > | field? I have a format mask that adds commas for readability on
long
> > > | numbers, but when I edit the number, I don't want the commas to be
> > there.
> > > | For instance, if I where to put the decimal point off by one
position
> > > | accidentaly on a long number, I would have to change the decimal
> > position
> > > | then remove all the commas or replace them where they should be. It
> > would
> > > be
> > > | easier to retype the number; yes, but I would prefer to have the
> option
> > to
> > > | edit it. The closest I could come up with was to Nullify the Format
> Mask
> > > on
> > > | a Pre-text-item trigger, then Replace it on a Post-text-item
trigger.
> > > This
> > > | would work fine if I were viewing only one Record, but I am not. So
> all
> > > the
> > > | numbers for that whole column lose their formatting when the focus
is
> on
> > > | that Item.
> > > | Also, is there a trigger that fires when an item is changed(at the
> same
> > > time
> > > | the Item_is_valid becomes False).
> > > |
> > > | Any help would be appreciated,
> > > | Aaron V.
> > > |
> > > |
> > >
> > >
> >
> >
> >
>
>
Received on Tue Jan 20 2004 - 04:14:55 CET