This is how I see it working
"Before startup eep"
SET VAR vDate = .#DATE
On your for have a form variable for the Rows ID
vRowID = RowID
Have the Varible Date/Time picker in your scrolling Region and using the
onclick eep update the row.
UPDATE Table Set DateField = .vDate WHERE RowID = .vRowID
You could also do something like this with a second form with the
variable Calendar control on it.
First steps the same on the first form but instead
Create a no table form with variable calendar control on it and no
predefined var in it. All that comes for the first form.
In your scrolling region put a button in it (I don't care which one)
and a DB label next to it and set it up on you datefield
EDIT USING CalendarForm
UPDATE TableName Set DateField = .vDate WHERE RowID = .vRowID
PROPERTY TABLE <FormTableName> 'REFRESH'
It would work something like this. Now that I have written this email I
like the second way better.
________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Ed
Rivkin
Sent: Thursday, July 23, 2009 8:31 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Change Date/Time Picker to last keyed entry
Victor,
Thanks for the quick reply but I am a bit confused about how to use
update in this example.
Are you suggesting I update the variable by using the update command in
an EEP executed
when leaving the variable field. The entry is occuring in a scrolling
region so I need to limit the
update to the specific row in which the entry is occuring.
Ed
Jul 23, 2009 04:14:16 PM, [email protected] wrote:
Use the variable date/time picker. That and a update command should do
the trick.
________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Ed
Rivkin
Sent: Thursday, July 23, 2009 10:55 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Change Date/Time Picker to last keyed entry
Hi folks,
The majority of the data entry into my rent application involves
entering two dates;
postal date and bank date per line. I thought my user would like the
date/time picker
for these fields but it always defaults back to the system date.
This presents some extra effort because many of the entries in a
particular session
have the same postal and/or bank date.
I would like to have the date picker work as follows:
a) default to system date when the form is started for postal and bank
date.
b) display the last entered date after the first date is entered for
each field.
Is there an easy way to change the date picker to accomplish this. I am
using
R:Base 7.6
Thanks in advance.
Ed
