Your syntax is wrong. It would be something like this:
GETPROPERTY Sum1BalCurr VALUE vTBalCurr
The "vTBalCurr" would be the variable that gets the value of the cell with that
componentID.
Karen
On Saturday, March 23, 2024 at 12:19:59 PM CDT, 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 = NULLSET
VAR vdate DATE = NULL
Tested, as noted above:SET VAR vtest = (GETPROPERTY('cid_vdte_date','VALUE'))
...... returns no valueSET 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 valueGETPROPERTY
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. ChitieaSafeSectors, Inc.1142 S Diamond Bar Blvd # 442Diamond Bar CA
91765-2203
[email protected] (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 AMSubject 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/384479626.588044.1711221492813%40mail.yahoo.com.
