I have been following and just by luck I am also in the same boat. So to speak -
I did notice that if you watch the form very carefully you will see a dotted line appear around that row when a row is referenced and then at that point the eep will work every time. Select somewhere not in a field but in the area around the field. Now if you mouse/float over to another row and column and hit in a db-edit field (most of mine are "Read-Only") the dotted line does not go around the row and the eep is in question then. Works or grabs another row id. I know somebody else is doing this and my knowledge is limited in 'Scrolling Regions' and behavior. So if I get the answer or somebody else has it cool, I am willing to try all ideas. I know it can be done and I am also missing that small little syntax somewhere. Sincerely, Paul D From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Monday, August 03, 2009 4:18 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Change Date/Time Picker to last keyed entry Ed, In your bit button try this; update rentroll set bankdate = .bankp where rowid = .vrowid recalc var PROPERTY TABLE rentroll 'REFRESH' RETURN Jan -----Original Message----- From: Ed Rivkin <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 03 Aug 2009 15:02:35 -0500 (CDT) Subject: [RBASE-L] - Re: Change Date/Time Picker to last keyed entry Karen, Thanks for setting me straight regarding the variable setting. In retrospect it seems pretty obvious. Unfortunately my working knowledge of R:Base is from the 4.5 days with the pieces added bringing me to 7.6. Overall the app conversion from 4.5 to 7.6 has gone pretty well thanks to everyone on this forum and the great folks at R:Base. I am enhancing the app where I can without burdening the forum. I also found the tutorial helpful. Also thanks to Victor about adding the variable in the form. I was already there but appreciate the extra care and guidance. I still have an issue and this may be my lack of knowledge about when eep's fire and/or variables. A little background about this form first. It's a three table form always in edit. The user is prompted for account code in the first table (Acctprom) and this brings up all of that account's rent records from the Rentroll table. The Rentroll table is my scrolling region. This is where I am adding the BankDate Bit Button. Finally I also display the account balance from a third table (Balate) which is also used throughout my application for report selections and other reasons. The account balance is dynamically updated in this form as the user applies rent receipts. Per Karen's advice, I removed Bernie's suggestions....i.e. component id in scrolling region and his suggested eep on the BankDate Bit button. It was replaced with: update rentroll set bankdate = .bankp where rowid = .vrowid recalc var return I also created the variable vrowid = rowid This is created in the rentroll section of my variables and is the 2nd variable created before some other processing that occurs using variables. If I click the Bit Button, nothing changes on the screen until I scroll down to the next line in the region at which point the bankdate field on the screen is updated as desired. Is there a way to make the bankdate field refresh and show the bankdate update after the Bit Button is pushed in the specific row. Thanks, Ed Aug 3, 2009 08:02:10 AM, [email protected] wrote: Ed: The reason your eep doesn't work is the first row -- your "set var" line gets the value of the first row in RentRoll, not the row you are on. If you set up a form variable vRowID = RowID then that's all you need for your "update" command to work properly. If you do that then you don't have to mess about with componentIDs. Karen Here's the custom eep code set var vrowid = rowid in rentroll update rentroll set bankdate = .bankp where rowid = .vrowid recalc var return
