Re: Re[2]: [RBASE-L] - Forms | Accessing a DBcontrol value BEFORE it is saved.

Sat, 23 Mar 2024 12:26:34 -0700

Bruce,
 
It is the TEXTVALUE that will provide the current value.
 
Here's how:
 
GETPROPERTY <Component ID> TEXTVALUE 'varname'
 
Have fun!
 
Very Best R:egards,
 
Razzak
 
 
On 03/23/2024 1:19 PM EDT Bruce Chitiea <[email protected]> wrote:
 
 
Thank you, Razzak. An elegant solution, to be sure.
 
Comes the question: "Which PROPERTY holds the the control's current value? Despite extensive testing, I seem incapable of finding it.
 
(Note: I continued working yesterday within a variable form to keep momentum, and have the same issue.)
 
 
So I've experimented with a number of possible PROPERTY names for a Variable Date and Time Edit control in both GETPROPERTY structures. These have been placed alternately in the On Exit EEP of the VDTE control, and the On Entry EEP of the following control.
 
 
(Courier New font, below)
 
 
Within On Before Design and On Before Start EEPs:
SET VAR vtest TEXT = NULL
SET VAR vdate DATE = NULL
 
Tested, as noted above:
SET VAR vtest = (GETPROPERTY('cid_vdte_date','VALUE')) ...... returns no value
 
SET VAR vtest = (GETPROPERTY('cid_vdte_date','VARNAME')) .... returns string 'vdate'
SET VAR vtest = (GETPROPERTY('cid_vdte_date','AUTOSELECT')) . returns no value
 
 
GETPROPERTY cid_vdte_date VALUE 'vtest' ...... returns no value
 
 
GETPROPERTY cid_vdte_date VARNAME 'vtest' .... returns string 'vdate'
GETPROPERTY cid_vdte_date AUTOSELECT 'vtest' . returns no value
 
 
Note that neither 'VALUE' nor 'VARNAME' are listed PROPERTYs within R:Docs for either the Variable or DB version of the control (implying undocumented properties. ) AUTOSELECT is of interest because R:Docs reports that it "Specifies the data within the field will be selected, when the focus lands on it." Presumably, focus lands when the date is clicked upon.
 
Clearly, I'm missing something screamingly obvious. What am I missing?
 
Thank you, Bruce
 
Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203
 
(909) 238-9012 m

 
------ Original Message ------
From "Razzak Memon" <[email protected]>
To [email protected]; "Bruce Chitiea" <[email protected]>
Date 3/23/2024 1:24:25 AM
Subject Re: [RBASE-L] - Forms | Accessing a DBcontrol value BEFORE it is saved.
 
Bruce,
 
Consider using the GETPROPERTY command to capture the control's current value in a variable. Then, use that captured variable to extract anything you see fit. That is as simple as it gets.
 
Razzak
On 03/22/2024 6:32 PM EDT Bruce Chitiea <[email protected]> wrote:
 
 
RBG11
 
Bound form.
 
Is it possible to access a value just entered into a DB control for processing, BEFORE the record being entered is saved to the table?
 
For instance, once a date value is selected from a DB Date Time Edit control, how might one grab the year to a variable within the control's On Exit EEP like:
 
SET VAR vYear = (IYR4(selectedDate)) {for use in constructing a down-stream value }
 
I mean, the selectedDate value hasn't yet been entered to a table ... and it's not a variable, so ... what would I target?
 
Thanks much

 

--
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/emc84fa026-5a10-453c-9f26-52e32366e449%40a4e8a7e3.com.

 

--
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/976935309.5530528.1711182265965%40email.ionos.com.

 

--
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/emb34e8309-8ef0-4ed0-9e3f-b98b631ea681%40a4e8a7e3.com.

--
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/159552756.5515309.1711221989001%40email.ionos.com.

Reply via email to