Bill Does your temp table have a common column with Menutab table? If so the common columns have to match.
Buddy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bill Eyring Sent: Tuesday, October 04, 2011 8:52 AM 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,tInspectionsComple te) + 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 --- RBASE-L =======================3D=======================3 D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D=======================3 D=
