Re: Temp Tables

If your temp table is created inside a transaction the a 'rollback work' will also rollback the creation of the temp table. Since the user(s) were gone for an extented period, Online would think they are a 'long transaction' and abort them. It's possible that this is your problem. ---- original message from uunet!kmart!jregep@warlok ---- ++ ++ Has any one heard of this: ++ ++ I have a program that creates a temp table, the user is in an input statement ++ then goes to lunch. Another user (at another terminal) is running the same ++ program and is in an input statement then goes to meet the first user for ++ lunch. They have a good time and are gone for 3 hours. When they return ++ they find that the temp table has been cleared of information - wiped out. ++ ++ We are using Online 4.10 - will 5.13 fix this? ++ ++ thanks ++ || ======= **** **T* ======= ||John Regep ++ || **** **** ||Store Systems Developement ++ || **** *R** ||Kmart Corporation ++ || =========== ********* =========== ||3100 West Big Beaver ++ || ***A* **** ||Troy, MI 48084 ++ || **** **** ||(810) 643-5078 ++ ||=============== *M** **** ===============||uunet!kmart!jregep ++ ++ -- Jerry M. Denman -- Director of Special Projects Sherwood Systems (a division of Sherwood Mfg Co. Inc.) jerry@sherwood.com ------------------------------------------------------------------------------ The manner in which one endures what must be endured is more important than the thing that must be endured. - DEAN ACHESON