Hi, normally the precompiler reparse the SQL command three times to solve the error -8. Please send me a precompiler trace from this situation. You can activate the Precompiler trace by setting the environment variable SQLOPT=-X or by using the irtrace tool.
Regards Burkhard > -----Original Message----- > From: Claus-Thomas Buhl [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 18, 2004 3:07 PM > To: [EMAIL PROTECTED] > Subject: Occasional error message in ESQL/C application doing > select,update,select on a table row > > > Running SAP DB 7.3.0.32, I have an ESQL/C application that > establishes a > connection to a database, does a SQL 'select *' to get one row in a > table x, does an SQL update on the row and then again does a SQL > 'select *' on the row. Table x has 23 columns, 12 being LONG columns. > > For some database records in table x, I get the following > error message: > > Execution failed, parse again(29) Errorcode = -8, ISAM = 0 > > when the second select is done. Note that the update does NOT alter > the table definition. > > On other database records, the application works fine. > > Any ideas, explanations? > > Regards, > > CTB > -- > _______ > \o/|\o/ Claus-Thomas Buhl > | Diplom-Informatiker > \_____/ mailto:[EMAIL PROTECTED] > > H.E.I. GmbH | Wimpfener Strasse 23 | D-68259 Mannheim > Fon: +49-(0)621-795141 | Fax: +49-(0)621-795161 | mailto:[EMAIL PROTECTED] > http://www.h-e-i.de && http://www.hei.biz && http://www.radpage.com > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
