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 <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 <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/0bc101da7ce6%24db93cdb0%2492bb6910%24%40vtgonline.com <https://groups.google.com/d/msgid/rbase-l/0bc101da7ce6%24db93cdb0%2492bb6910%24%40vtgonline.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/ema8ceef07-1756-4cda-a998-41b0763905ba%40c5e2053b.com.

Reply via email to