Thank you for the response. It seems there should be a way to update
the form data set. I know I have done it with list views on occasion
without issue. But this DB Grid is being contrary!
-Bob
On 4/15/2025 11:45 AM, 'Karen Tellef' via RBASE-L wrote:
Hi Bob! That's interesting, I change columns in 2 tables frequently
but have never tried changing the common column. I wonder if your
assumption is correct, I don't have a suggestion
If you end up not finding a solution that allows you to stay in the
table, you might have to exit and come back in. Something like this:
SET VAR vChanged TEXT = "YES"
WHILE vChanged = "YES" THEN
EDIT USING formname
ENDWHILE
In the "before start eep" of the form, set vchanged = "NO". In your
speed button, change it to "yes", make the changes, then do a
Closewindow.
Karen
On Tuesday, April 15, 2025 at 11:28:00 AM CDT, 'Robert Thompson' via
RBASE-L <[email protected]> wrote:
This is driving me a bit crazy...
I have a simple form that is based on Table A
The form has a Enhanced DB Grid based on Table B
Table A and Table B have two common columns. MO_ID and LOC
On the form is an Enhanced Speed button to change the value of the
common column LOC. It then POSTS the two tables and refreshes using
the PROPERTY command.
When the table is called up, the DB grid shows properly.
When the value for LOC is changed, the corresponding rows in the DB Grid
disappears.
If you change the value back to the original value, the DB Grid data
shows back up.
Viewing the data in table B from another session, it indeed shows the
value LOC is being changed and updated via the Speed button. The form is
refreshing as when I change the LOC value back to the original value,
the data reappears.
I am assuming that the forms lookup function is not getting updated.
I.E. When first called, the common columns must match. When the column
LOC is changed, the forms DB Grid is not seeing the new value.
I have used about every combination of PROPERTY command I can think of,
but to no avail...
In the speed button eep:
PROPERTY TABLE A POST
PROPERTY TABLE B POST
Property table A refresh
property table B refresh
-- And I have tried dozens of variations of other property commands
such as
Property RBase_Form POForm refresh
property POGRID refreshlist 'true'
Any suggestions?
Thank you,
Bob Thompson
--
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 [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/a0013192-2511-4f5b-888b-66212eff84ac%40comcast.net.
--
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 [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/1990142208.1776224.1744735516900%40mail.yahoo.com
<https://groups.google.com/d/msgid/rbase-l/1990142208.1776224.1744735516900%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
Robert Thompson
TTC. Inc.
219-363-7441
--
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 [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/fd1e0791-f202-473a-bf15-5aa8b49a0579%40comcast.net.
