[RBG7-L] - RE: Add row property

[John Engwer]

I know what is happening now.  Since the new row is not saved prior to the table refresh the refresh just restores the data that was previously saved in the table.  Therefore the refresh table is working properly and should not be used in this circumstance.   Thanks all for your responses.   John Engwer   From: rbg7-l@rbase.com [mailto:rbg7-l@rbase.com] On Behalf Of John Engwer Sent: Monday, October 17, 2005 1:33 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Add row property   Dawn, You may be on to something there.  The table that I am using is a temporary table projected from another table.  During the project I use a where clause to limit the rows to edit. When I refresh It looks like it is re-projecting the original rows from the source table rather than refreshing the rows from the temporary table.  I can see the APPEND property create the new row when I trace but the new row disappears when the REFRESH property is executed.  When I check the temporary table there are no new rows added.   In any case it works fine without the REFRESH so that is what I will do.  When I get time, I will try it with 7.5 to see if I get the same results.   John Engwer   From: rbg7-l@rbase.com [mailto:rbg7-l@rbase.com] On Behalf Of Dawn Oakes Sent: Monday, October 17, 2005 12:55 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Add row property   John, You must have a where clause defined that is preventing the display of the blank row.  Property..'refresh', re-fetches the data from the table to refresh the display. You're appending a row to the table, but without any data in it, it may not meet the where clause criteria, so it doesn't get displayed with the refresh.  There's no need to do the refresh, unless that is your intent - to re-fetch the data from the table.  So my guess is, it really has been adding the rows, just not showing them - check your table for null value rows. Dawn   From: John Engwer [mailto:[EMAIL PROTECTED]] Sent: Monday, October 17, 2005 12:47 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Add row property I removed the PROPERTY TABLE PURCHASE 'REFRESH’ from the command list and now it works.  When I add it back in, it will not add a row.  ???     John Engwer   From: rbg7-l@rbase.com [mailto:rbg7-l@rbase.com] On Behalf Of Bill Eyring Sent: Monday, October 17, 2005 11:45 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Add row property   John   Make sure your table settings for table PURCHASE has Add New Rows to the Table  checked.   Then add the following to your ADD ROW button eep;   PROPERTY TABLE purchase 'APPEND'  then;   PROPERTY TABLE purchase 'LAST' will take you to the last added row in the scrolling region.     Bill Eyring    From: rbg7-l@rbase.com [mailto:rbg7-l@rbase.com] On Behalf Of John Engwer Sent: Monday, October 17, 2005 10:00 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Add row property I have a form that contains a region for editing data in a table named purchase. Outside of the region I have a Speed Button that when selected fires an EEP to add a new row.  I am trying to use the following property within the EEP to add the row and it is not working.   PROPERTY TABLE purchase 'APPEND' PROPERTY TABLE PURCHASE 'REFRESH'   If I use the predefined “Add Row” within the Speed Button it works OK.  However, I need to issue other property commands along with the Add Row so I need to do it from within a Custom EEP.   Am I using the wrong property command? (version 7.1 final build)    John Engwer