Re: trigger to fire when navigating records

Steve,
[Quoted] I tried the post-Record trigger, but it doesn't fire when you click on the scrollbar, or scrollbar up or down buttons. New records are shown at the top or bottom of the block, but the cursor_record moves up or down in the block, it would only fire if the cursor record was the top record and you were to click scroll up again(or down and down), then the cursor record would change, firing triggers.

Get this, mouse triggers don't fire on scrollbars, try a when-mouse-clicked, or even moved even at the Form level, it won't fire in a scrollbar, it's like it's not even on the form.

Although I did find a way to make it work, sort of, but it's not pretty. I created a timer when I navigated to the Item I want to stay in sync with the cursor record, set it for 100 ms, then when-timer-expired verified the location of the sync item, and that it was still the cursor_item, and synchronized them if needed, or deleted the timer if the sync item wasn't the cursor item. It's works so far, and looks to the user, like it responds to the scrollbar.

--Aaron V

"Steve Cooper" <coos02_at_blackburn.ac.uk> wrote in message news:2cd89d54.0401050520.13fe9aa0_at_posting.google.com... > "Aaron V" <Tinkerist_at_hotmail.com> wrote in message 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.
> > > |
> > > |
> > >
> > >

>
> Araon,
>
> Try Post-Record trigger at the block level, this should fire when ever
> you naviagte, either by arrow keys or scrollbar.