Subject | Grid cleared on insert |
---|---|
Author | skander_sp |
Post date | 2008-03-04T10:24:39Z |
I read in IBO FAQ:
I have a master-detail form, with both grids...
I only OPEN (both) querys on showform, and no close them until hide
Form, then ALWAYS must be open, not? (at leasr by myself)
But some times, may be not 10% but enough often, when inserting new
lines in detail, suddenly all dissapear and only news are showed.
Really (of course) only dissapear from the grid, still in database...
and I don't know what is wrong...
What I must do? I think if i make a "refresh" or "close-open" on after
insert will work, but I thinks it's a dirty solution.
Anyone had the same problem? and how was solved?
Tks in advance.
>>When I insert new record, sometimes (10% of cases) all my old recordsIt's MY CASE!!! but not for the answers.
>>disappear from grid - only new record shows ...
>> --It is possible to insert into a query that is not open. If you
>>want to take some action to avoid this possibility, check for Active
>>before calling Insert.
>> --In IBO4, I made it so that you can use Locate() on queries that
>>are not open so be careful with this, too, to avoid unexpected
>>results.
I have a master-detail form, with both grids...
I only OPEN (both) querys on showform, and no close them until hide
Form, then ALWAYS must be open, not? (at leasr by myself)
But some times, may be not 10% but enough often, when inserting new
lines in detail, suddenly all dissapear and only news are showed.
Really (of course) only dissapear from the grid, still in database...
and I don't know what is wrong...
What I must do? I think if i make a "refresh" or "close-open" on after
insert will work, but I thinks it's a dirty solution.
Anyone had the same problem? and how was solved?
Tks in advance.