Javier, I do remember setting up one of my views the way you described and it may be you are the one helping me to do that. I was hoping to not have to go the VIEW route but that may be what I end up doing. Or I may go to the Enhanced DBGRID route you alluded to earlier.
Sometimes problems pushes us to try new, and in many instances, better ways to do something. This may be one of those times. James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Thursday, March 05, 2015 9:01 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: negative highlighted in scrolling region Jim, You have mail. Feel free to contact me if you need additional information. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Thursday, March 05, 2015 7:00 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: negative highlighted in scrolling region Javier, Thanks for looking. My user has a tendency not to correct things like this. This will help. James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Thursday, March 05, 2015 6:07 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: negative highlighted in scrolling region Jim, I know exactly what you want and I do have solution that makes the background of the entire row on the scrolling region red or whatever color you want; actually, you can have as many colors as you want depending on values. Once Enhanced Grids became available I switched to those and what you need can be easily done there. I will see if I can find an old form with a scrolling region that has that feature and prepare a sample for you. I know I have sent samples before on this subject so I will look this evening in my old e-mails and maybe it is ready to go. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Thursday, March 05, 2015 3:36 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: negative highlighted in scrolling region That may be the way I need to go but I would rather have a way the guilty row itself would be pointed out. Thanks for the suggestions. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Thursday, March 05, 2015 3:31 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: negative highlighted in scrolling region You could design form expressions modelled like what I had below and locate the variables on the row, maybe in bold red. Variable labels have the ability to blink, so you could add that too! Karen -----Original Message----- From: Jim Belisle <[email protected]<mailto:[email protected]>> To: RBASE-L Mailing List <[email protected]<mailto:[email protected]>> Sent: Thu, Mar 5, 2015 3:23 pm Subject: [RBASE-L] - Re: negative highlighted in scrolling region Karen, I have been away from the computer for a while. What I want is if any of the rows, not just the focused row, are negative then: 1) A warning box would come up. I have this completed. 2) The cursor focuses on the detail section. I have this completed. 3) The offending row in the scrolling region would do something to get the attention of the user. Number three is what I need. It would be great if the cursor would not only jump to the detail section but to the offending row. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]<mailto:[email protected]>] From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]?>] On Behalf Of Karen Tellef Sent: Wednesday, March 04, 2015 4:56 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: negative highlighted in scrolling region When I have to do something like that, I try to use a form variable since they are evaluated only for the focused row. Would it be good enough to put a red variable with the word "negative" or 2 red parenthesis around the field if it is negative? Something like: set var vNegText = (IFLT(column, 0, 'NEGATIVE', ' ')) Karen -----Original Message----- From: Jim Belisle <[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]?>>> To: RBASE-L Mailing List <[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]?>>> Sent: Wed, Mar 4, 2015 4:15 pm Subject: [RBASE-L] - negative highlighted in scrolling region Scrolling region with a variable vemptime that calculates the time for a process. The driving table of this form is different than the scrolling region. Sometimes when importing into this table, the times are messed up and this var becomes negative. (The variable is based on the punch in punch out times). My code shows a PAUSE clause then forces the cursor into the scrolling region if the punch out time is less than the punch in time. What I want now is the offending var field to change color because it is negative. Since there are multiple rows and many of them will be fine, I only want to var field that is negative to change. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]?>>]
