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
formnameENDWHILE
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.
