I do always drop and recreate temp tables on all apps Tom
________________________________ From: Kenny Camp <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, June 22, 2011 12:24:18 PM Subject: [RBASE-L] - Re: Weird problem Drop and recreate temp tables instead of deleting rows over and over. This stopped temp table corruption for me. From:[email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, June 22, 2011 11:37 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Weird problem Tom: Is your label based on the temp table or the perm table? It doesn't happen very often, but occasionally I have had temp tables go corrupt and seem to "lose" the data. If your label is based on the temp table and you want to keep it that way, maybe put something like this in the program right before the print: output table.txt select all from <temptable> where <same where as your label> output screen Then as soon as they have a problem you can dial in and look at table.txt to see if RBase thought there were rows in the table. Karen In a message dated 6/22/2011 11:24:47 AM Central Daylight Time, [email protected] writes: >enter data into a temp table >append this to perm table >print labels >exit
