[RBASE-L] - RE: Change Date/Time Picker to last keyed entry

[Ed Rivkin]

Victor, Thanks for setting me straight. Yes...I do the same thing sometimes. Unfortunately I do not have a totally unique row identifier in this situation. I wonder if this could be done using variables within the form which will address only the row that is being updated in the region rather than the Update command. I also have a note into Jan asking if he can forward me what he used in the past. I'll slay this dragon one way or another. Ed Jul 27, 2009 09:52:39 AM, rbase-l@rbase.com wrote: I was assuming that you have some kind of id for the row that you’re trying to update. It could be CustomerID or EstimateID or what ever just something that identifies the row that needs updating as unique. Sorry if I was not clear, you know how sometime with you write something you know what you talking about but know one else does. Happens to me all the time. ;-) From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of Ed Rivkin Sent: Sunday, July 26, 2009 3:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Change Date/Time Picker to last keyed entry Victor, Thanks for the suggestions. For some reason I am missing a most basic step, i.e. setting the vRowID. When I try to define the variable in my form, I keep getting an error because RowID isn't a variable or column in the form. There must be something basic that I'm missing. Sorry for the continued questioning about this but I searched the archives as well as some sample apps and couldn't find anything that addressed this. BTW...Jan, if you also want to post your solution for this, I am using Edit Using in both forms. In each case I am trying to default two dates per row in a scrolling region. Thanks to you both for your assistance. Ed Jul 24, 2009 09:53:45 AM, rbase-l@rbase.com wrote: 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 'REFRESH'   It would work something like this. Now that I have written this email I like the second way better.   From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] 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, rbase-l@rbase.com wrote: Use the variable date/time picker. That and a update command should do the trick. From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] 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