Re: SP Temp Tables

Posted in 2003

Jean Sagi — Sat, 25 Oct 2003 03:01:52 -0500 — source: Usenet: comp.databases.informix

As you could see there are some "ways" to lead to this "issue"... What I wondwer is: Why this happen? Why a delete delay to delete? Funny... Chucho! navdeep virk wrote: > Hi All, > > I am creating temp tables and dropping them after the processing is done > in a stored procedure , however if users abort and try to run again we > get the error " t_temp etc.. already in the database" . Is there any > workaround to check if this temp table exists then drop it and create > the temp table again . > > > Navdeep > > _________________________________________________________________ > See when your friends are online with MSN Messenger 6.0. Download it now > FREE! http://msnmessenger-download.com > > sending to informix-list > > -- Atte, Jes's Antonio Santos Giraldo jeansagi@myrealbox.com jeansagi@netscape.net sending to informix-list