Subject Re: Delete (all) in a form From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Mon, 13 Aug 2018 20:14:37 +0530 Newsgroups dbase.getting-started On 13/08/2018 19:41, Charlie wrote: > I actually tried it with the remaining two and it deleted successfully one row.  I guess the problem is that it is skipping rows.  I'll try more rows later after work... Thanks!!!! Charlie please go through the entire reply. I had posted some corrections to your code also. Just comment out the p.next() and try again. It will work. The moment you delete the row the row pointer automatically moves to next row so you do not need p.next() The moment you delete row 1 rowset pointer moves to row 2 and then you issue p.next() which moves the pointer to row 3. So effectively you are deleting alternate rows. Regards Akshat > > Akshat Kapoor Wrote: > >> On 13/08/2018 18:09, Charlie wrote: >>> Hi Akshat... >>> >>> I think either the form or the table are haunted!!! >>> >>> I changed to a different form of delete in this: >>> >>> function PUSHBUTTON1_onClick() >>>         p=form.pictemp11.rowset >>>      //form.train1.emptyTable( "pictemp1" ) >>>         cnt=p.count() >>>         msgbox ( ""+ cnt ) >>>         p.first() >>>         do while cnt > 0 >>>            p.delete() >>>                 cnt = cnt-1 >>>                 msgbox( ""+CNT ) >>>                 p.next() >> I am not sure and do not have all the files to check but when you issue >> p.delete() rowset pointer should automatically move to next row so you >> probably won't be needing p.next() comment it out and try once again. >> >> >>>         enddo >>> >> >> You have tried with just 4 rows and hence found 2 left over had you >> tried it with more rows there would have been more left. >> >> Regards >> Akshat >> >