Don’t we all! Glad I could help. James Belisle
Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of Patti Jakusz Sent: Tuesday, January 20, 2015 12:36 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Need a skip pattern suggestion Hi Jim, I had the "Ah Ha" moment as you were writing this. Thank you. Patti ________________________________ From: Jim Belisle <[email protected]<mailto:[email protected]>> To: RBASE-L Mailing List <[email protected]<mailto:[email protected]>> Sent: Tuesday, January 20, 2015 1:31 PM Subject: [RBASE-L] - RE: Need a skip pattern suggestion Patti, I am not authoritative on this but I believe this is how it works. The number in the code simply is RBASE being able to find the specific button you are dealing with. You do not have to have that number in the caption. In any Radio Group, your first button will be zero. Then for each one you add, the numbering is in sequence. I might be wrong on this and would love instruction from others more knowledgeable than me. 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 Patti Jakusz Sent: Tuesday, January 20, 2015 12:01 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Need a skip pattern suggestion Oh, dear - about the radiobuttons number. That number was in the "Caption" slot, which I wiped out of every one of the DBRadioGroups I already have on the form. It doesn't appear to be anywhere else in the object properties. Is there anywhere else I can find that? No, I don't have RDocs. Patti ________________________________ 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: Tuesday, January 20, 2015 12:10 PM Subject: [RBASE-L] - RE: Need a skip pattern suggestion Patti, I am not an expert on this so if there are others on the list that can help you, I hope they chime in. Not sure if you have RDOCS but that would help you in using the PROPERTY GETPROPERTY commands. If you are grabbing a value from a component ID then the proper syntax is as follows: GETPROPERTY BiiAdd_DENTKID TEXTVALUE ‘.vdentkid’ This will grab the text value of your component and put it into the variable. You got the error because you did not tell what property you were getting from the component. As for the PROPERTY error, I believe you did not use the correct syntax You showed property BiiAdd_Cribcard radiobuttons visible 'True' I believe you need to have both the number of the button you are changing as well as the -> sign Example: PROPERTY comp_custtype radiobuttons[5]->VISIBLE 'FALSE' You also may need the RECALC VAR code somewhere. I hope that helps some. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>] From: [email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>> [mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>] On Behalf Of Patti Jakusz Sent: Tuesday, January 20, 2015 10:56 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Need a skip pattern suggestion Based on another email of yours I saw, I tried to add the following before the switch statement, to see the value of column DENTKID or variable .vdentkid, before I use it in the switch statement. I added the following: set v vdentkid INT getproperty BiiAdd_DENTKID .vdentkid That didn't work. I got error 2045: Syntaz is incorrect for the getproperty command. Patti ________________________________ From: Patti Jakusz <[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>>> To: "[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>>" <[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>>> Sent: Tuesday, January 20, 2015 11:20 AM Subject: Re: [RBASE-L] - RE: Need a skip pattern suggestion Hi Jim, I've been playing with this for a long time. For testing, I just used a form that I was currently creating, so my field names are different than previously mentioned. Form name: BiiAdd. I'm entering data into a DBRadioGroup named DENTKID. If DENTKID=1 send to DTest, else if DENTKID = 7 or 8, send to DentBAD I defined a variable named vdentkid=DENTKID (I think this is a problem. It many not compute this until after I get off the field.) I filled in the Component ID for DTest as BiiAdd_DTest I filled in the Component ID for DentBAD as BiiAdd_DentBAD I added this eep "On Exit" from DENTKID. SWITCH (.vdentkid) Case 1 property BiiAdd_DTest visible 'True' Break Case 7 property BiiAdd_DTest visible 'False' property BiiAdd_DentBAD visible 'True' Break Case 8 property BiiAdd_DTest visible 'False' property BiiAdd_DentBAD visible 'True' Break ENDSW return It kind of works, but only after I try to click on a different set of radio buttons. That's too late. I tried putting it "On Click" instead of "On Exit" but it didn't define .vdentkid until after I clicked off the field and came back again, and then it held the old value from the first iteration. If I want it to work "On click", do I have to go back and set up my DBRadio Group as a variable instead of a column in a table? Or is there a way to compute vdentkid in the eep before the Switch statement. Also, any time I tried to add radiobuttons to the above eep, I got an error message. property BiiAdd_DTest radiobuttons 'False' gave me error 2045: Syntax is incorrect for the command property. I'm not sure what that statement would have done anyway. Did I even need it? Thanks, Patti ________________________________ From: Jim Belisle <[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>><mailto:[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]>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>>> Sent: Monday, January 19, 2015 8:43 PM Subject: [RBASE-L] - RE: Need a skip pattern suggestion Patti, I was off line for a while and just got back on. For CASE 1 and 2 you would have the same PROPERTY code since you want it to go to the same field. You could add a focus code as well if you wanted to so the cursor would go to the DBedit field. PROPERTY <componentID> SET_FOCUS ‘TRUE’ It is not necessary. It depends on how automated you want to get. The great thing about using the PROPERTY command is you can show just what you want. In my code for one of my forms, only the first radio group shows. Once a choice is made, then only the next radio group shows based on the choice in the first radio group. This continues until, on this form, a report is ready to generate. It does not have to be this way. Some forms have all radio groups showing and the code eliminates items no chosen. It really comes down to what your people want to do and the ease of understanding the form. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>>] From: [email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>> [mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>>] On Behalf Of Patti Jakusz Sent: Monday, January 19, 2015 6:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Need a skip pattern suggestion So, for example, I have a form named BiiAdd and a field named Outcome. If Outcome = 1, 2 or 3, I want it to go to Outdate (a DBedit field) If Outcome = 4, I want it to go to Cribcard (a DBRadio group) So I'm thinking this is what my Exit EEP will be for field Outcome Switch (Outcome) Case 1 Case 2 Case 3 property BiiAdd_Outdate visible 'True' break Case 4 property BiiAdd_Outdate visible 'False' property BiiAdd_Cribcard visible 'True' property BiiAdd_Cribcard radiobuttons visible 'True' break Endsw Is this correct? Thanks, Patti ________________________________ From: Jim Belisle <[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>><mailto:[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]>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>>>> Sent: Monday, January 19, 2015 4:06 PM Subject: [RBASE-L] - RE: Need a skip pattern suggestion Patti, I use radio groups all the time and you can control which radio buttons come up using the PROPERTY commands. It is not that difficult since I learned it. You can also include the SWITCH command with the CASE command. Below is an example. SWITCH (.vreportuse) CASE 'Distinfo' PROPERTY comp_reset VISIBLE 'TRUE' PROPERTY comp_custtype VISIBLE 'TRUE' PROPERTY comp_custtype radiobuttons[4]->VISIBLE 'FALSE' PROPERTY comp_custtype radiobuttons[5]->VISIBLE 'FALSE' BREAK CASE 'QuickOpen' -- Added this option on 5/18/2012 PROPERTY comp_reset VISIBLE 'TRUE' PROPERTY comp_custall VISIBLE 'TRUE' SET VAR vcusttype = 'DIST' SET VAR vctchoice = '(DIST,RES,DIR)' BREAK ENDSW James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>>>] From: [email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>>> [mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>><mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>>>] On Behalf Of Patti Jakusz Sent: Monday, January 19, 2015 2:05 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Need a skip pattern suggestion I have a form with lots and lots of DB Radio Groups. There are lots of skip patterns to follow, based on the answers to previous questions. Since you can't really use the "skip to" command in an eep for DB radio groups, I was thinking of placing a little DBedit field in front of each question that can be highlighted. If a previous question is answered in one way, I could skip to the little field in front of the question that should be next. I could have to "in focus" color be something bright. Is there a better control to use than DBedit? Is there an easier way to do it? I don't know how to use Get Property. (I learned Get Property in 2008 but didn't use it fast enough and I forgot it. Next time I go to a class, I'm going to record it.) Thanks, Patti
