USE INSERT rather than APPEND to get your data into the table. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [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
