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 = <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<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 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-<mailto:rbase-l+unsubscr...@googlegroups.com>l+unsubscr...@googlegroups.com<mailto: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<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<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.

Reply via email to