Claudine,
I have an Enhanced DB Grid on several forms in the current database I’m working on. I don’t have an dropdown fields but I have the code below in the On Exit EEP for the grid. See if this helps. PROPERTY TABLE tablename 'POST' PROPERTY TABLE tablename 'REFRESH' Good luck, Paul Buckley From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Claudine Robbins Sent: April 10, 2018 7:04 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Enhanced DBGrid Refresh Actually, I think I’ll use closing and reopening the form as a work around for now. Claudine From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> [mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins Sent: Tuesday, April 10, 2018 3:31 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Subject: RE: [RBASE-L] - Enhanced DBGrid Refresh Armin, Upon returning to the Enhanced DBGrid, the row in the lookup table has been saved but is not available to the dropdown. A refresh command of some sort needs to be applied to the DBGrid, like the closing and reopening of the form does. Thanks, Claudine From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> [mailto:rbase-l@googlegroups.com] On Behalf Of Armin Thoma Sent: Monday, April 02, 2018 1:35 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Subject: AW: [RBASE-L] - Enhanced DBGrid Refresh Claudine SAVEROW might do it. Armin _____ Von: <mailto:rbase-l@googlegroups.com> rbase-l@googlegroups.com < <mailto:rbase-l@googlegroups.com> rbase-l@googlegroups.com> im Auftrag von Claudine Robbins < <mailto:crobb...@iexgroup.com> crobb...@iexgroup.com> Gesendet: Montag, 2. April 2018 20:33 An: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Betreff: RE: [RBASE-L] - Enhanced DBGrid Refresh Thank you Razzak. I don't think I made it clear that there are two tables involved here. One underlies the Enhanced DBGrid, the other underlies the expression lookup of one of its columns, the one I'm using in the grid to provide a dropdown. Claudine -----Original Message----- From: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Monday, April 02, 2018 1:02 PM To: rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com> Subject: Re: [RBASE-L] - Enhanced DBGrid Refresh Claudine, Please try the following and see what you get ... -- Start PROPERTY TABLE endbgridtablename 'CLOSE' PROPERTY TABLE endbgridtablename 'OPEN' RETURN -- End Very Best R:egards, Razzak At 01:53 PM 4/2/2018, Claudine Robbins wrote: >I don't know how to refresh an Enhanced DBGrid. I have an expression >lookup on a DBGrid column (dropdown) and a button on the form to edit >its underlying table but changes are not reflected when I use PROPERTY >TABLE tablename 'POST' >and PROPERTY TABLE tablename 'REFRESH' after editing the records. -- For group guidelines, visit <http://www.rbase.com/support/usersgroup_guidelines.php> 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 <mailto:rbase-l+unsubscr...@googlegroups.com> rbase-l+unsubscr...@googlegroups.com. For more options, visit <https://groups.google.com/d/optout> https://groups.google.com/d/optout. -- 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 <mailto:rbase-l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- 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 <mailto:rbase-l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- 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 <mailto:rbase-l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- 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 <mailto:rbase-l+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- 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. For more options, visit https://groups.google.com/d/optout.
