RE: stack overflow in NewEra

> -----Original Message----- > From: Ameerul@mesiniaga.com.my [mailto:Ameerul@mesiniaga.com.my] > Sent: 23 February 2000 09:02 > To: informix-list@iiug.org > Cc: cristian.bucur@rsb.ro > Subject: Re: stack overflow in NewEra > > > > Basically, search here means the select statement as in > select * . After the select statement, i> use "free" to free out the memomy. The NewEra version is 2.2 > on Windows 95. > > regards. > I have had similar problems with 7.2X Are you preparing the SQL and then executing in 2 different transactions. For some reason a simple prepare of "Select * from systables WHERE tabid = ?" will fail on execute if the execute occurs in a different transaction. We tried to prepare a similar statement when the app loaded. We were going to use it all over and only wanted to prepare it once. We eventually had to take the hit and "close and re-prepare before each commit" I think it was done to a bug with 7.2X Jo ___________________________________________________________________________ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema Group. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Sema Group Helpdesk by telephone on +44 (0) 121 627 5600. ___________________________________________________________________________