Subject Re: GRID DISPLAY From Mervyn Bick <invalid@invalid.invalid> Date Wed, 18 Oct 2017 21:37:56 +0200 Newsgroups dbase.getting-started On 2017-10-18 8:52 PM, Mustansir Ghor wrote: > Dear Mervyn > > for both queries sql property is "select * from accsales.dbf'.  The use of 2 queries was first one to be set for grid setting and second one was to update the file accsales with update data. All works fine but grid fails to display update data. Initially accsales file becomes empty with zap. Later it has update data but it does not display on the grid. If you have two queries feeding from the same table dBASE creates two completely separate rowsets in memory.  If you change data in one rowset it eventually gets written to disk but the other rowset remains as it was. Once you have updated your table you need to requery() the query that displays the data in the grid.  This will fetch the newly updated data from the disk and pass it on to the grid. // code to update query2 // when that is complete   form.query1.requery() Mervyn.