Subject Re: requery problem From Ken Mayer <dbase@nospam.goldenstag.net> Date Wed, 8 Jan 2020 08:01:40 -0800 Newsgroups dbase.getting-started 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 -- *Ken Mayer* 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