Subject Re: requery problem (semi reason) From Mervyn Bick <invalid@invalid.invalid> Date Thu, 9 Jan 2020 14:35:13 +0200 Newsgroups dbase.getting-started On 09/01/2020 13:36, Mervyn Bick wrote: >> I am testing it an easy way by clicking on the erase all button on the >> form and cancel.  I did this twice two times in testing this and it >> failed the second time both times.  Here is my code for the erase button: >> >> function PUSHBUTTON3_onClick() >>        local nanswer >>         nanswer = msgbox( "Are you sure you want to erase sauc >> values?","Erase?" , 48+4 ) >>        if nAnswer == 6 // Yes >>            form.master9.rowset.first() >>           do while not form.master8.rowset.endofset > > master8 is a typo and it will make dBASE very unhappy. :-)  The > master8.rowset never gets to endofset.  Once your code gets to endofset > in master9.rowset it just keeps on trying until it dies either from > frustration or exhaustion. :-) > > What happens if you fix this? As dBASE crashed instead of giving a "read-only" error I assume you have change the master9 query by removing the ORDER BY clause and you have assigned an index to the rowset's indexName property. Fixing the type should allow the values in sauc to be erased. Mervyn.