Have you tried a statement like 'recalc tables' Normally this will refresh the content of the tables
Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring Sent: dinsdag 4 oktober 2011 14:52 To: RBASE-L Mailing List Subject: [RBASE-L] - DBGrid not loading table values. I have a form which after 2 variables are entered loads data into a temp table then makes a dbgrid visible. I have verified that the data is in the table but when the dbgrid is made visible, there is no data in the grid. Here is the code in an on exit eep for the 2nd variable field; set v vcount int=null sel count InspectId into vcount vi1 fro InsSchedules if vcount=0 the goto theend endi set error message 2038 off drop TABLE tInsSchedules CREATE Temporary TABLE `tInsSchedules` + (`tInspectID` INTEGER , + `tInsStart` DATE , + `tInsEnd` DATE , + `tInsSchDate` DATE , + `tInsBuildId` integer , + `tInspectionsComplete` TEXT (1) ) insert into tInsSchedules + (tInspectID,tInsStart,tInsEnd,tInsSchDate,tInsBuildId,tInspectionsComplete) + sel InspectID,InsStart,InsEnd,InsSchDate,InsBuildId,InspectionsComplete + fro InsSchedules whe InspectionFreqId=.vInspectionFreqId and InsBuildId=.vBuildId + order by InsStart property dbg_tInsSch visible 'true' ret label theend clear variable vcount,vi1 ret Both variables have values. The form has 2 tables Menutab and tInsSchedules. The dbgrid based on the Temp table tInsSchedules is displayed with NO DATA. Can anyone suggest a resolution ? Thanks, Bill Eyring
