Karen: Thank you. I had hoped that my example would show the results of
the two approaches to GETPROPERTY, as I understand them. "Open", meaning
the GETPROPERTY standalone, "func" meaning the GETPROPERTY function
approach. Each approach relied upon variables created within the On
Before Design and On Before Start EEPs, anticipating that the DB Date
and Time Edit (dbDTE) control does, in fact, have a TEXTVALUE property.
Each of these was then targeted in the On Exit EEP of the dbDTE control,
the output being shown in Variable Labels, as shown in the sample form
below. Put them together:
The "Open" approach:
SET VAR vtest_open_TEXTVALUE TEXT = NULL
GETPROPERTY cid_dbdte_eventDate TEXTVALUE 'vtest_open_TEXTVALUE'
... which mirrors your recommended syntax, and:
The "Func" approach:
SET VAR vtest_func_TEXTVALUE TEXT = NULL
SET VAR vtest_func_TEXTVALUE =
(GETPROPERTY('cid_dbdte_eventDate','TEXTVALUE'))
... which follows the example within R:SYNTAX.
Note that no error is thrown by either syntax. It is possible that
TEXTVALUE does not exist as a property within the dbDTE control. R:Docs
displays neither VALUE nor TEXTVALUE.
'Tis a mystery. I'll try it with TEXT.
Always appreciate your help, Karen.
Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203
rby...@safesectors.com
(909) 238-9012 m
------ Original Message ------
From "'Karen Tellef' via RBASE-L" <rbase-l@googlegroups.com>
To "rbase-l@googlegroups.com" <rbase-l@googlegroups.com>
Date 3/25/2024 5:19:26 AM
Subject Re: Re[4]: [RBASE-L] - Forms | Accessing a DBcontrol value
BEFORE it is saved. | Fail
Your syntax for 'SET VAR vtest_func_textvalue' is incorrect. That will
never work. You don't use "set var" with a "getproperty"
I use the getproperty often and don't have an issue. Brought up one of
my apps and I see that I've done it a couple different ways and
apparently both of them work! But I don't think I've ever used on a
date/time edit
SET VAR fTOldQty TEXT = NULL
GETPROPERTY units TEXT 'fTOldQty'
SET VAR vText TEXT = NULL
GETPROPERTY NoUnitsSell TEXTVALUE vText
Karen
On Sunday, March 24, 2024 at 01:04:55 PM CDT, Bruce Chitiea
<rby...@safesectors.com> wrote:
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
rby...@safesectors.com
(909) 238-9012 m
------ Original Message ------
From "Razzak Memon" <raz...@rbase.com>
To rbase-l@googlegroups.com; "Bruce Chitiea" <rby...@safesectors.com>
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 <rby...@safesectors.com>
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
rby...@safesectors.com
(909) 238-9012 m
------ Original Message ------
From "Razzak Memon" <raz...@rbase.com>
To rbase-l@googlegroups.com; "Bruce Chitiea" <rby...@safesectors.com>
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 <rby...@safesectors.com>
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 rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/emae5271ba-0b8d-455b-8c39-3108fc8ff088%40a4e8a7e3.com
<https://groups.google.com/d/msgid/rbase-l/emae5271ba-0b8d-455b-8c39-3108fc8ff088%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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1085618155.933291.1711369166699%40mail.yahoo.com
<https://groups.google.com/d/msgid/rbase-l/1085618155.933291.1711369166699%40mail.yahoo.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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em87031368-218a-4c3a-a4b2-53195b9f9cbf%40c5e2053b.com.