Thank you for your response yesterday.
After focused repeated testing, I am unable to "get" a property value
from an RBG11 DB Date and Time Edit control into a target TEXT variable.
Stripped to its essence, in a bound form:
Within EEPs On Before Design and On Before Start:
SET VAR vtest_open_TEXTVALUE TEXT = NULL
SET VAR vtest_func_TEXTVALUE TEXT = NULL
RETURN
DB Date and Time Edit control named:
cid_dbdte_eventDate
On Exit EEP of cid_dbdte_eventDate:
GETPROPERTY cid_dbdte_eventDate TEXTVALUE 'vtest_open_TEXTVALUE'
SET VAR vtest_func_TEXTVALUE =
(GETPROPERTY('cid_dbdte_eventDate','TEXTVALUE'))
RECALC VARIABLES
RETURN
Results:
Usually, I'm missing something screamingly obvious. What am I not
getting?
Best, Bruce
Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond 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 12:26:28 PM
Subject Re: Re[2]: [RBASE-L] - Forms | Accessing a DBcontrol value
BEFORE it is saved.
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
[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 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
<https://groups.google.com/d/msgid/rbase-l/emc84fa026-5a10-453c-9f26-52e32366e449%40a4e8a7e3.com?utm_medium=email&utm_source=footer>.
--
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
<https://groups.google.com/d/msgid/rbase-l/976935309.5530528.1711182265965%40email.ionos.com?utm_medium=email&utm_source=footer>.
--
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
<https://groups.google.com/d/msgid/rbase-l/emb34e8309-8ef0-4ed0-9e3f-b98b631ea681%40a4e8a7e3.com?utm_medium=email&utm_source=footer>.
--
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
<https://groups.google.com/d/msgid/rbase-l/159552756.5515309.1711221989001%40email.ionos.com?utm_medium=email&utm_source=footer>.
--
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/emae5271ba-0b8d-455b-8c39-3108fc8ff088%40a4e8a7e3.com.
