RE: [RBASE-L] - Enhanced DBGrid Refresh
A simple oversight I'm sure :-) -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Wednesday, April 11, 2018 4:39 PM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - Enhanced DBGrid Refresh Hi Claudine, I know you do! However, my reply was intended for Karen Tellef who never mentioned nor acknowledged the help and support from the Development Team of R:BASE Technologies. Very Best R:egards, Razzak At 05:05 PM 4/11/2018, Claudine Robbins wrote: >Duly noted. And I do appreciate all the gracious and professional >help you and your team provide. > >Claudine > >-Original Message- >From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On >Behalf Of A. Razzak Memon >Sent: Wednesday, April 11, 2018 3:22 PM >To: rbase-l@googlegroups.com >Subject: Re: [RBASE-L] - Enhanced DBGrid Refresh > >It is recommended to reference the "actual" product documentation, >especially during >active development. > >In the Form's help, within the Enhanced DB Grid > Columns > Enhanced >Properties: > >When using a Lookup Expression field type, changes to the cell value >will display >the previous value after it is changed, and only updates when the >focus is moved to >another row. As the column change is known within memory (from moving >from cell to >cell within the row) and not yet passed to the engine (from moving >from row to row), >the Lookup Expression can be dynamically replaced with the current >in-memory value >before passing to the engine for evaluation by enclosing the field name within >"less than" and "greater than" characters; "<" and ">". > >Example: AccountName IN Account WHERE AccountType = > >You should appreciate and acknowledge the gracious, courteous, and >professional help >as well as private timely responses provided to you from the talented >development team >at R:BASE Technologies, Inc. > >Very Best R:egards, > >Razzak > > > >At 03:44 PM 4/11/2018, karentellef via RBASE-L wrote: > > >Yep, I had it noted in my "cheat sheet" document as a fix that was made > >in 2014 in version 9.5, but my print-screen example was still the > original one > >that RBTI had created! I replaced my print-screen with the updated screen, > >and now I'll never "forget" that new syntax again! Goes to show > that the eye > >looks immediately at a picture, and kind of ignores the text "please note" > >that's written right under it!! > > > >Karen > > > > > > > >-Original Message- > >From: A. Razzak Memon <raz...@rbase.com> > >To: rbase-l <rbase-l@googlegroups.com> > >Sent: Wed, Apr 11, 2018 2:01 pm > >Subject: Re: [RBASE-L] - Enhanced DBGrid Refresh > > > > > >FWIW ... > > > >It was the R:BASE Development Team who provided you with the insight > >as well as the correct > >syntax to use that technique of using Lookup Expressions in DB Grid control. > > > >Very Best R:egards, > > > >Razzak > > > >At 08:48 AM 4/11/2018, karentellef via RBASE-L wrote: > > > > >Claudine: Just yesterday (in 3/20 build) I designed a DBGrid that > > >had a lookup expression > > >designed to show the account's name, and a popup menu to select the > > >account from another > > >table. > > > > > > > > > >-- > >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 > >rbase-<mailto:l+unsubscr...@googlegroups.com>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>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+unsubscribe@go > oglegroups.com. > >For more options, visit > ><https://groups.google.com/d/optout>https://groups.goog
RE: [RBASE-L] - Enhanced DBGrid Refresh
Hi Claudine, I know you do! However, my reply was intended for Karen Tellef who never mentioned nor acknowledged the help and support from the Development Team of R:BASE Technologies. Very Best R:egards, Razzak At 05:05 PM 4/11/2018, Claudine Robbins wrote: Duly noted. And I do appreciate all the gracious and professional help you and your team provide. Claudine -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Wednesday, April 11, 2018 3:22 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Enhanced DBGrid Refresh It is recommended to reference the "actual" product documentation, especially during active development. In the Form's help, within the Enhanced DB Grid > Columns > Enhanced Properties: When using a Lookup Expression field type, changes to the cell value will display the previous value after it is changed, and only updates when the focus is moved to another row. As the column change is known within memory (from moving from cell to cell within the row) and not yet passed to the engine (from moving from row to row), the Lookup Expression can be dynamically replaced with the current in-memory value before passing to the engine for evaluation by enclosing the field name within "less than" and "greater than" characters; "<" and ">". Example: AccountName IN Account WHERE AccountType = You should appreciate and acknowledge the gracious, courteous, and professional help as well as private timely responses provided to you from the talented development team at R:BASE Technologies, Inc. Very Best R:egards, Razzak At 03:44 PM 4/11/2018, karentellef via RBASE-L wrote: >Yep, I had it noted in my "cheat sheet" document as a fix that was made >in 2014 in version 9.5, but my print-screen example was still the original one >that RBTI had created! I replaced my print-screen with the updated screen, >and now I'll never "forget" that new syntax again! Goes to show that the eye >looks immediately at a picture, and kind of ignores the text "please note" >that's written right under it!! > >Karen > > > >-Original Message----- >From: A. Razzak Memon <raz...@rbase.com> >To: rbase-l <rbase-l@googlegroups.com> >Sent: Wed, Apr 11, 2018 2:01 pm >Subject: Re: [RBASE-L] - Enhanced DBGrid Refresh > > >FWIW ... > >It was the R:BASE Development Team who provided you with the insight >as well as the correct >syntax to use that technique of using Lookup Expressions in DB Grid control. > >Very Best R:egards, > >Razzak > >At 08:48 AM 4/11/2018, karentellef via RBASE-L wrote: > > >Claudine: Just yesterday (in 3/20 build) I designed a DBGrid that > >had a lookup expression > >designed to show the account's name, and a popup menu to select the > >account from another > >table. > > > > >-- >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 >rbase-<mailto:l+unsubscr...@googlegroups.com>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>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+unsubscribe@go oglegroups.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. 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. -- 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.
RE: [RBASE-L] - Enhanced DBGrid Refresh
Duly noted. And I do appreciate all the gracious and professional help you and your team provide. Claudine -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Wednesday, April 11, 2018 3:22 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Enhanced DBGrid Refresh It is recommended to reference the "actual" product documentation, especially during active development. In the Form's help, within the Enhanced DB Grid > Columns > Enhanced Properties: When using a Lookup Expression field type, changes to the cell value will display the previous value after it is changed, and only updates when the focus is moved to another row. As the column change is known within memory (from moving from cell to cell within the row) and not yet passed to the engine (from moving from row to row), the Lookup Expression can be dynamically replaced with the current in-memory value before passing to the engine for evaluation by enclosing the field name within "less than" and "greater than" characters; "<" and ">". Example: AccountName IN Account WHERE AccountType = You should appreciate and acknowledge the gracious, courteous, and professional help as well as private timely responses provided to you from the talented development team at R:BASE Technologies, Inc. Very Best R:egards, Razzak At 03:44 PM 4/11/2018, karentellef via RBASE-L wrote: >Yep, I had it noted in my "cheat sheet" document as a fix that was made >in 2014 in version 9.5, but my print-screen example was still the original one >that RBTI had created! I replaced my print-screen with the updated screen, >and now I'll never "forget" that new syntax again! Goes to show that the eye >looks immediately at a picture, and kind of ignores the text "please note" >that's written right under it!! > >Karen > > > >-Original Message----- >From: A. Razzak Memon <raz...@rbase.com> >To: rbase-l <rbase-l@googlegroups.com> >Sent: Wed, Apr 11, 2018 2:01 pm >Subject: Re: [RBASE-L] - Enhanced DBGrid Refresh > > >FWIW ... > >It was the R:BASE Development Team who provided you with the insight >as well as the correct >syntax to use that technique of using Lookup Expressions in DB Grid control. > >Very Best R:egards, > >Razzak > >At 08:48 AM 4/11/2018, karentellef via RBASE-L wrote: > > >Claudine: Just yesterday (in 3/20 build) I designed a DBGrid that > >had a lookup expression > >designed to show the account's name, and a popup menu to select the > >account from another > >table. > > > > >-- >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 >rbase-<mailto:l+unsubscr...@googlegroups.com>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>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. 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.
Re: [RBASE-L] - Enhanced DBGrid Refresh
It is recommended to reference the "actual" product documentation, especially during active development. In the Form's help, within the Enhanced DB Grid > Columns > Enhanced Properties: When using a Lookup Expression field type, changes to the cell value will display the previous value after it is changed, and only updates when the focus is moved to another row. As the column change is known within memory (from moving from cell to cell within the row) and not yet passed to the engine (from moving from row to row), the Lookup Expression can be dynamically replaced with the current in-memory value before passing to the engine for evaluation by enclosing the field name within "less than" and "greater than" characters; "<" and ">". Example: AccountName IN Account WHERE AccountType = You should appreciate and acknowledge the gracious, courteous, and professional help as well as private timely responses provided to you from the talented development team at R:BASE Technologies, Inc. Very Best R:egards, Razzak At 03:44 PM 4/11/2018, karentellef via RBASE-L wrote: Yep, I had it noted in my "cheat sheet" document as a fix that was made in 2014 in version 9.5, but my print-screen example was still the original one that RBTI had created! I replaced my print-screen with the updated screen, and now I'll never "forget" that new syntax again! Goes to show that the eye looks immediately at a picture, and kind of ignores the text "please note" that's written right under it!! Karen -Original Message- From: A. Razzak Memon <raz...@rbase.com> To: rbase-l <rbase-l@googlegroups.com> Sent: Wed, Apr 11, 2018 2:01 pm Subject: Re: [RBASE-L] - Enhanced DBGrid Refresh FWIW ... It was the R:BASE Development Team who provided you with the insight as well as the correct syntax to use that technique of using Lookup Expressions in DB Grid control. Very Best R:egards, Razzak At 08:48 AM 4/11/2018, karentellef via RBASE-L wrote: >Claudine: Just yesterday (in 3/20 build) I designed a DBGrid that >had a lookup expression >designed to show the account's name, and a popup menu to select the >account from another >table. -- 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 rbase-<mailto:l+unsubscr...@googlegroups.com>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>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. For more options, visit https://groups.google.com/d/optout.
Re: [RBASE-L] - Enhanced DBGrid Refresh
Yep, I had it noted in my "cheat sheet" document as a fix that was made in 2014 in version 9.5, but my print-screen example was still the original one that RBTI had created! I replaced my print-screen with the updated screen, and now I'll never "forget" that new syntax again! Goes to show that the eye looks immediately at a picture, and kind of ignores the text "please note" that's written right under it!! Karen -Original Message- From: A. Razzak Memon <raz...@rbase.com> To: rbase-l <rbase-l@googlegroups.com> Sent: Wed, Apr 11, 2018 2:01 pm Subject: Re: [RBASE-L] - Enhanced DBGrid Refresh FWIW ... It was the R:BASE Development Team who provided you with the insight as well as the correct syntax to use that technique of using Lookup Expressions in DB Grid control. Very Best R:egards, Razzak At 08:48 AM 4/11/2018, karentellef via RBASE-L wrote: >Claudine: Just yesterday (in 3/20 build) I designed a DBGrid that >had a lookup expression >designed to show the account's name, and a popup menu to select the >account from another >table. -- 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. -- 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.
Re: [RBASE-L] - Enhanced DBGrid Refresh
FWIW ... It was the R:BASE Development Team who provided you with the insight as well as the correct syntax to use that technique of using Lookup Expressions in DB Grid control. Very Best R:egards, Razzak At 08:48 AM 4/11/2018, karentellef via RBASE-L wrote: Claudine: Just yesterday (in 3/20 build) I designed a DBGrid that had a lookup expression designed to show the account's name, and a popup menu to select the account from another table. -- 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.
RE: [RBASE-L] - Enhanced DBGrid Refresh
Paul, Karen, The POST/REFRESH combo didn’t work and I already have the external table as a slave in the form. My expression lookup is different. I’m populating a dropdown box for column CARRIER, not picking a value. And I can’t snip the resulting screen… Claudine [cid:image002.jpg@01D3D181.BF60B9D0] From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Wednesday, April 11, 2018 10:29 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Enhanced DBGrid Refresh One other thing. When you have your lookup defined, are you putting the second lookup value in <> ? That trips me up all the time. It helps with refreshing the lookup when you leave the row, so perhaps it also makes this dynamic? I mean: actname IN accounts WHERE acctno = Karen -Original Message- From: Claudine Robbins <crobb...@iexgroup.com> To: rbase-l <rbase-l@googlegroups.com> Sent: Wed, Apr 11, 2018 10:22 am Subject: RE: [RBASE-L] - Enhanced DBGrid Refresh Thanks. I’ll try and let you know. ~Claudine From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com?>] Sent: Wednesday, April 11, 2018 7:49 AM To: rbase-l@googlegroups.com<mailto:l...@googlegroups.com> Subject: Re: [RBASE-L] - Enhanced DBGrid Refresh Claudine: Just yesterday (in 3/20 build) I designed a DBGrid that had a lookup expression designed to show the account's name, and a popup menu to select the account from another table. Is that similar to what you're doing? [rbase.jpg] I just tried this. I brought the form up. On another session, I added a row to the account lookup table. In the form I did the popup menu and my new value showed up as one of the choices. If this is what you're trying to do and it isn't working, perhaps add the lookup table as an actual form slave table, and then maybe the 'table...refresh' command would work on it? Karen -Original Message- From: Paul C. Buckley <p...@buckleyandassoc.com<mailto:p...@buckleyandassoc.com>> To: rbase-l <rbase-l@googlegroups.com<mailto:l...@googlegroups.com>> Sent: Wed, Apr 11, 2018 7:17 am Subject: RE: [RBASE-L] - Enhanced DBGrid Refresh 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<mailto:l...@googlegroups.com> <rbase-l@googlegroups.com<mailto:l...@googlegroups.com>> On Behalf Of Claudine Robbins Sent: April 10, 2018 7:04 PM To: rbase-l@googlegroups.com<mailto: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: rbase-<mailto:rbase-l@googlegroups.com>l...@googlegroups.com<mailto:l...@googlegroups.com> <rbase-<mailto:rbase-l@googlegroups.com>l...@googlegroups.com<mailto:l...@googlegroups.com>> im Auftrag von Claudine Robbins <crobb...@iexgroup.com<mailto: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. [cid:image006.png@01D3D181.19264080] 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 se
Re: [RBASE-L] - Enhanced DBGrid Refresh
One other thing. When you have your lookup defined, are you putting the second lookup value in <> ? That trips me up all the time. It helps with refreshing the lookup when you leave the row, so perhaps it also makes this dynamic? I mean: actname IN accounts WHERE acctno = Karen -Original Message- From: Claudine Robbins <crobb...@iexgroup.com> To: rbase-l <rbase-l@googlegroups.com> Sent: Wed, Apr 11, 2018 10:22 am Subject: RE: [RBASE-L] - Enhanced DBGrid Refresh Thanks. I’ll try and let you know. ~Claudine From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Wednesday, April 11, 2018 7:49 AM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Enhanced DBGrid Refresh Claudine: Just yesterday (in 3/20 build) I designed a DBGrid that had a lookup expression designed to show the account's name, and a popup menu to select the account from another table. Is that similar to what you're doing? I just tried this. I brought the form up. On another session, I added a row to the account lookup table. In the form I did the popup menu and my new value showed up as one of the choices. If this is what you're trying to do and it isn't working, perhaps add the lookup table as an actual form slave table, and then maybe the 'table...refresh' command would work on it? Karen -Original Message- From: Paul C. Buckley <p...@buckleyandassoc.com> To: rbase-l <rbase-l@googlegroups.com> Sent: Wed, Apr 11, 2018 7:17 am Subject: RE: [RBASE-L] - Enhanced DBGrid Refresh 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 OfClaudine 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]On Behalf Of Claudine Robbins Sent: Tuesday, April 10, 2018 3:31 PM To: 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]On Behalf Of Armin Thoma Sent: Monday, April 02, 2018 1:35 PM To: rbase-l@googlegroups.com Subject: AW: [RBASE-L] - Enhanced DBGrid Refresh Claudine SAVEROW might do it. Armin Von:rbase-l@googlegroups.com <rbase-l@googlegroups.com> im Auftrag von Claudine Robbins <crobb...@iexgroup.com> Gesendet: Montag, 2. April 2018 20:33 An: 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] On Behalf Of A. Razzak Memon Sent: Monday, April 02, 2018 1:02 PM To: 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, visithttp://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 torbase-l+unsubscr...@googlegroups.com. For more options, visithttps://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 torbase-l+unsub
RE: [RBASE-L] - Enhanced DBGrid Refresh
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
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] On Behalf Of Claudine Robbins Sent: Tuesday, April 10, 2018 3:31 PM To: 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: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> <rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>> im Auftrag von Claudine Robbins <crobb...@iexgroup.com<mailto: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. [cid:image001.png@01D3D0F6.5CC76520] 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 --- 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.
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] On Behalf Of Armin Thoma Sent: Monday, April 02, 2018 1:35 PM To: rbase-l@googlegroups.com Subject: AW: [RBASE-L] - Enhanced DBGrid Refresh Claudine SAVEROW might do it. Armin Von: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> <rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>> im Auftrag von Claudine Robbins <crobb...@iexgroup.com<mailto: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. [cid:image001.png@01D3D0E0.E962BBD0] 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 --- 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.
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. [cid:image001.png@01D3CA87.26C9EE40] Claudine -Original Message- From: 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 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 --- 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.
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 --- 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.