Re: Temp Table not being deleted

We are using Informix 7.2 on HPUX 10.10. We have had some problems with a temp table not being dropped after a drop table statement is issued. We can still query off the temp table after the drop has been issued. Paul Mansfield (p.mansfield@motiv.co.uk.AntiSpamText) wrote: : Nils Myklebust wrote: : > : > Adam Sorati <adams@sgen.com.au> wrote: : > : > :Has anyone ever come across this situation or another situation : > :where a temp table is not being drop. : > :Has anyone ever come across this situation or another situation : > :where a temp table is not being drop. : > : > There have been problems with temp tables not beeing droped as they : > should, but I believed that not to be a problem any more in SE 7.1 : we use temporary tables in v7/SE, and they work fine, but the : table doesn't get dropped until either you specifically drop : it OR the connection to the database is disconnected. : Paul : -------------------------------------------------------------------------- : Paul Mansfield, Internet Consultant @ Motiv Systems Ltd : snailto:Orwell House.Cowley Road.Cambridge.CB4 4WY.UK : Webto: http://www.motiv.co.uk and http://java.motiv.co.uk : mailto:p.mansfield@motiv.co.uk phoneto:[+44+223] 576318 faxto:~319 : -------------------------------------------------------------------------- : 28.8:is it the IQ, or the typical modem speed, on Usenet? -- And I still use vi.........