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 = <shipper>
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+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
torbase-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
torbase-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
torbase-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
torbase-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
torbase-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.
