Nope I set up a DBCheckBox (NOT Variable) for a column PaidAccr with a on check EEP:
GETPROPERTY CheckPaidAccr TEXTVALUE ePaidAccr PAUSE 1 USING .ePaidAccr RETURN It shows as NULL How can we capture the value of the db checkbox for the eep? David David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Dawn Oakes" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, November 10, 2004 3:03 PM Subject: [RBG7-L] - Re: Another Property question David, I remember something about GETPROPERTY <component id> TEXTVALUE varname as an option that became effective with a recent release (77 I think). I haven't tried it yet so I'm not sure if it would work any better than the RBTI_Form_colvalue. Dawn -----Original Message----- From: David M. Blocker [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 10, 2004 2:53 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Another Property question Jan I'm sure there is a way to do it using the 'On click EEP' for the dbcheckbox. In my preliminary tests I haven't been able to find any way to capture the value of the DBcheck box column - I tried setting a var to the RBTI_Form_ColValue but that returned the DBEDIT with focus. I tried setting a form variable to the columns value, but that didn't re-evaluate when I clicked. If someone can help you find a way to capture the value of the checkbox column, it would then work like this: Let's say that you have a DBEDIT control for the field "SomeData". And that the DB Checkbox is for the column "SomeCheck". If SomeCheck is A, show SomeData, if not don't 1. Create an EEP that runs on entry to the row (in forms, select Tables/ Add/Remove tables / Table Settings / ON ROW ENTRY - enter and create a file name that does this: PROPERTY SomeData VISIBLE 'False' 2. Create an EEP that runs "on click" from the DBEDIT control. IF eSomeCheck = 'A' THEN PROPERTY SomeData VISIBLE 'True' ELSE PROPERTY SomeData VISIBLE 'False' ENDIF The issue is how to get the columns' value into eSomeCheck! See if that helps David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Jan Johansen" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, November 10, 2004 11:38 AM Subject: [RBG7-L] - Another Property question > Is there a way to use a property based on information in a DB-Edit or > DBCheckbox? > > Specifically, my desire is to show another DBEdit based on cliking a > DB Checkbox. > However I cant figure out how to do this. > > Do I set a variable or is there an &where or something like that so I > can evaluate in an eep? > > I know how to do the property command just cant figure out what is available > to me to do an if statement. > > Jan > >
