Mike, I checked and I use insert for the data Tom Hart
________________________________ From: Dennis McGrath <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, June 22, 2011 11:56:37 AM Subject: [RBASE-L] - Re: Weird problem USE INSERT rather than APPEND to get your data into the table. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave ItascaIL 60143 630-980-8461begin_of_the_skype_highlighting 630-980-8461 end_of_the_skype_highlighting [email protected] ________________________________ From:[email protected] [mailto: [email protected] ] On Behalf Of TOM HART Sent: Wednesday, June 22, 2011 11:54 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Weird problem No, the data is inserted into the perm table then tag printed, and the data never gets to the perm table when it fails. Tom ________________________________ From:" [email protected] " < [email protected] > To: RBASE-L Mailing List < [email protected] > Sent: Wed, June 22, 2011 11:36:57 AM 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
