When I use a View for this, it is a TEMPORARY SINGLE TABLE VIEW.
The sequence is after the initial data is constructed and the Form is
opened:
1 If the data is changed then
PROPERTY TABLE tvwSomeTempView 'CLOSE'
DROP VIEW tvwSomeTempView
CREATE TEMP VIEWtvwSomeTempView AS SELECT WhatEverColumns FROM
SomeBaseTableForTheVIEW +
WHERE SomeWhereClauseIfAny
PROPERTY TABLE tvwSomeTempView 'OPEN'
This is All I do. You could add REFRESH I guess, but I do not.
On Thursday, June 25, 2020 at 10:58:42 AM UTC-4, Stuart Hellman wrote:
>
> Karen and Michael,
>
>
>
> To begin, no Where clauses being used; neither the from working or the one
> not displaying data. Tried using a view for the DB grid, but still no data
> being displayed.
>
>
>
> Thanks for the suggestions.
>
>
>
> Stu
>
>
>
> <https://www.qmiusa.com/>
> Stuart Hellman
> Software Designer
> Email: *shell...@qmiusa.com* <javascript:>
>
> Toll Free: 800‑446‑2500
> International: 01 630‑529‑7111
>
> Extension: 1029
>
>
> *www.qmiusa.com* <https://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
> *From:* rba...@googlegroups.com <javascript:> <rba...@googlegroups.com
> <javascript:>> *On Behalf Of *Michael Byerley
> *Sent:* Thursday, June 25, 2020 8:22 AM
> *To:* RBASE-L <rba...@googlegroups.com <javascript:>>
> *Subject:* Re: [RBASE-L] - Need help with an Enhanced DB Grid
>
>
>
>
>
> The reason escapes me, but several years back, the single table view
> became the pathway I used without fail.
>
>
>
> On Wednesday, June 24, 2020 at 1:19:01 PM UTC-4, Karen Tellef wrote:
>
> 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' first
>
> 99% 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 <shel...@qmiusa.com>
> To: 'rba...@googlegroups.com' <rba...@googlegroups.com>
> Sent: Wed, Jun 24, 2020 11:47 am
> Subject: [RBASE-L] - Need help with an Enhanced DB Grid
>
> 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
>
>
>
> [image: Image removed by sender.] <https://www.qmiusa.com/>
>
> *Stuart Hellman***
>
> *Software Designer*
>
> Email:
>
> *shell...@qmiusa.com*
>
>
>
> Toll Free:
>
> 800‑446‑2500
>
> International:
>
> 01 630‑529‑7111
>
>
>
> Extension:
>
> 1029
>
>
>
>
>
> *www.qmiusa.com* <https://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 rba...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/DM5PR16MB183619BDF0D559901FA6C076BB950%40DM5PR16MB1836.namprd16.prod.outlook.com
>
> <https://groups.google.com/d/msgid/rbase-l/DM5PR16MB183619BDF0D559901FA6C076BB950%40DM5PR16MB1836.namprd16.prod.outlook.com?utm_medium=email&utm_source=footer>
> .
>
> --
> 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 rba...@googlegroups.com <javascript:>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/1f45e4e0-cca6-4c89-bb63-2f93d8de935co%40googlegroups.com
>
> <https://groups.google.com/d/msgid/rbase-l/1f45e4e0-cca6-4c89-bb63-2f93d8de935co%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/75ee1d68-5461-48e7-b34f-d5f805ae3236o%40googlegroups.com.
