SELECT no,date1,count1 FROM emp into CURSOR crsTemp WHERE date1=DATE() &&will take a looong time
ldDate=date() SELECT no,date1,count1 FROM emp into CURSOR crsTemp WHERE date1=ldDate && Will be fast, especially if you have an index tag on date12. Never select directly into the cursor which controls the grid! Use this solution
ldDate=date() SELECT no,date1,count1 FROM emp into CURSOR crsDummy WHERE date1=ldDate Select crsTemp && Which controls the grid zap append from dbf('crsDummy') yourgrid.refresh()3. Try to remember the tips we give you...! :-)
>&& myform-->event-->activate >SELECT no,date1,count1 FROM emp into CURSOR crsTemp WHERE date1=DATE() >brow&& ok >****mygrid1.ControlSource=crsTemp.no,count1,date1 >thisform.grid1.refresh && empty grid >>thanks