||Re: requery problem
Ken Mayer <email@example.com>
||Wed, 8 Jan 2020 08:01:40 -0800
On 1/8/2020 6:00 AM, charlie wrote:
> OK... .That sort of explains what is happening. For some unknown reason windows is causing dbase to shut down (not just the script I am working on). From what I can tell it seems that this is after 1 or 2 or 3 requeries. I am using dbase 11. Could this be a known bug in dbase? I only ran into this because I was testing the form several times. I might not have noticed it had I not been testing. But on my other script that is unrelated to this project, that does happen in regular use.
> I'm thinking this could be a bug with dbase or possibly dbase.
The problem for the crashes may be a lot of things. I was just pointing
out that when a crash occurs the _qsql???.dbf don't get a chance to be
cleaned up like they do when an app is closed properly and the BDE gets
a chance to clean up after itself.
I would focus on the cause of the crash in your code, which I see Akshat
and Mervyn are working with you on. You should be able to do multiple
requeries without a crash, so something is going on ...
Ken's dBASE Page: http://www.goldenstag.net/dbase
The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp
dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm
dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm