Just a stab at this. Does the original "edit using" command have a Where clause on it? After doing your work on the data, does that Where clause still evaluate correctly?
I always do the PROPERTY TABLE tablename 'REFRESH' first99% of the time that works for me. When it doesn't then I do the CLOSE followed by the OPEN There shouldn't be any reason for this to happen, but the last thing you can try is constructing a one-table view and basing the grid on that and refreshing it Karen -----Original Message----- From: Stuart Hellman <[email protected]> To: '[email protected]' <[email protected]> Sent: Wed, Jun 24, 2020 11:47 am Subject: [RBASE-L] - Need help with an Enhanced DB Grid <!--#yiv1643373173 _filtered {} _filtered {}#yiv1643373173 #yiv1643373173 p.yiv1643373173MsoNormal, #yiv1643373173 li.yiv1643373173MsoNormal, #yiv1643373173 div.yiv1643373173MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", sans-serif;}#yiv1643373173 a:link, #yiv1643373173 span.yiv1643373173MsoHyperlink {color:blue;text-decoration:underline;}#yiv1643373173 a:visited, #yiv1643373173 span.yiv1643373173MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv1643373173 span.yiv1643373173EmailStyle17 {font-family:"Times New Roman", serif;color:windowtext;font-weight:normal;font-style:normal;text-decoration:none none;}#yiv1643373173 .yiv1643373173MsoChpDefault {font-family:"Calibri", sans-serif;} _filtered {}#yiv1643373173 div.yiv1643373173WordSection1 {}-->The application is building a Bill of Materials on the fly. Make a selection, delete all rows in the table (in case a previous selection was changed), rebuild the B.O.M., adding new parts. When this is done, display the temp table in a DB Grid. The problem is that the data won’t display. The table is getting built. I can see the control flicker on the form when something is updating the table. I’ve tried different combinations of table properties, like POST/REFRESH and CLOSE/OPEN, but to no avail. Made a quick and dirty form of just the DB Grid and opening this form, the data displays as soon as it opens. I have another form that displays existing data in a grid with no problems. Would like to know if the setting for the DB grid (took the default options, selected the columns to be displayed) are incorrect or the refreshing of the table is not being done correctly. Thanks in advance for your help. Stu Hellman | | | | | Stuart Hellman | | Software Designer | | | | Email: | [email protected] | | | | | Toll Free: | 800‑446‑2500 | | International: | 01 630‑529‑7111 | | | | | Extension: | 1029 | | | | | | | | | www.qmiusa.com | | | | This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies | | -- 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 on the web visit https://groups.google.com/d/msgid/rbase-l/DM5PR16MB183619BDF0D559901FA6C076BB950%40DM5PR16MB1836.namprd16.prod.outlook.com. -- 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 on the web visit https://groups.google.com/d/msgid/rbase-l/292783977.2506292.1593019136703%40mail.yahoo.com.
