Re[2]: [RBASE-L] - Forms | Accessing a DBcontrol value BEFORE it is saved. | Success
Javier: That totally works.
Control: DB Date and Time Edit
Column: eventDate
Form Variable Name: vf001_eventDate
Form Variable Definition: (CTXT(IYR4(eventDate)) )
EventDate value: 03/25/2024
Variable value: 2024
Nice, thank you.
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 javier.valen...@vtgonline.com
To rbase-l@googlegroups.com
Date 3/22/2024 10:56:31 PM
Subject RE: [RBASE-L] - Forms | Accessing a DBcontrol value BEFORE it is
saved.
Can you define a form variable making it equal to the form field name?
Javier,
Javier Valencia, PE
14315 S Twilight Ln
Olathe, KS 66062
913-915-3137
From:rbase-l@googlegroups.com On Behalf Of
Bruce Chitiea
Sent: Friday, March 22, 2024 5:33 PM
To:rbase-l@googlegroups.com
Subject: [RBASE-L] - Forms | Accessing a DBcontrol value BEFORE it is
saved.
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
.
--
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/0bc101da7ce6%24db93cdb0%2492bb6910%24%40vtgonline.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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/ema8ceef07-1756-4cda-a998-41b0763905ba%40c5e2053b.com.
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 TEXTVALUE 'varname'
Have fun!
Very Best R:egards,
Razzak
On 03/23/2024 1:19 PM EDT Bruce Chitiea 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"
To rbase-l@googlegroups.com; "Bruce Chitiea"
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 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
Re: Re[2]: [RBASE-L] - Forms | Accessing a DBcontrol value BEFORE it is saved.
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
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
rby...@safesectors.com (909) 238-9012 m
-- Original Message --From "Razzak Memon" To
rbase-l@googlegroups.com; "Bruce Chitiea" 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 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.
--
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.
--
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.
--
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/384479626.588044.1711221492813%40mail.yahoo.com.
Re[2]: [RBASE-L] - Forms | Accessing a DBcontrol value BEFORE it is saved.
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"
To rbase-l@googlegroups.com; "Bruce Chitiea"
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
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
.
--
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
.
--
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.
