trigger to fire when navigating records

[Aaron V]

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@spamdamenquery.com> wrote in message
news:1cSdna8Kt-PgKF2iRVn-sw@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@hotmail.com> wrote in message news:pPTvb.81853$Dw6.391391@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. | |

[Steve Cooper]

"Aaron V" <Tinkerist@hotmail.com> wrote in message news:<WWoJb.719437$HS4.5228893@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@spamdamenquery.com> wrote in message news:1cSdna8Kt-PgKF2iRVn-sw@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@hotmail.com> wrote in message news:pPTvb.81853$Dw6.391391@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.

[Aaron V]

Steve,
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@blackburn.ac.uk> wrote in message
news:2cd89d54.0401050520.13fe9aa0@posting.google.com... "Aaron V" <Tinkerist@hotmail.com> wrote in message
news:<WWoJb.719437$HS4.5228893@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@spamdamenquery.com> wrote in message news:1cSdna8Kt-PgKF2iRVn-sw@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@hotmail.com> wrote in message news:pPTvb.81853$Dw6.391391@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.

[Steve Cooper]

Aaron,

Your right I misunderstood your initial question.....This is a tricky
one, but other than your timer solution I can't really think of any
other way to do this thats not going to be messy.

Steve


"Aaron V" <Tinkerist@hotmail.com> wrote in message news:<mEjKb.758853$Fm2.705095@attbi_s04>... Steve, 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@blackburn.ac.uk> wrote in message news:2cd89d54.0401050520.13fe9aa0@posting.google.com... "Aaron V" <Tinkerist@hotmail.com> wrote in message news:<WWoJb.719437$HS4.5228893@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@spamdamenquery.com> wrote in message news:1cSdna8Kt-PgKF2iRVn-sw@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@hotmail.com> wrote in message > news:pPTvb.81853$Dw6.391391@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.

[Fred van Nimwegen]

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


"Aaron V" <Tinkerist@hotmail.com> schreef in bericht
news:WWoJb.719437$HS4.5228893@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@spamdamenquery.com> wrote in message news:1cSdna8Kt-PgKF2iRVn-sw@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@hotmail.com> wrote in message news:pPTvb.81853$Dw6.391391@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. | |

[Aaron V]

"Fred van Nimwegen" <fred.vannimwegen@wanadoo.nl> wrote in message
news:400700b3$0$35149$1b62eedf@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@hotmail.com> schreef in bericht news:WWoJb.719437$HS4.5228893@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@spamdamenquery.com> wrote in message news:1cSdna8Kt-PgKF2iRVn-sw@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@hotmail.com> wrote in message news:pPTvb.81853$Dw6.391391@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. | |