RE: Prepared statement failed or was not executed

usually this kind of error ocurs when you close and reopen the db after the declaration of the cursor.
If that's not the case then I would suggest you to test the same instruction on a simple program and see what happens. 
Another suggestions: since it seems to happen with only one of you DB why don't you export it and import it with another name to see how the program works with the new db ?
It's not much but it's the best I can figure out right now.
HIH
Nuno C. Godinho


-----Mensagem original-----
De: [email protected] [mailto:[email protected]]Em
nome de José Costa
Enviada: sexta-feira, 2 de Setembro de 2005 17:53
Para: [email protected]
Assunto: [fourjs-users] Prepared statement failed or was not executed
Importância: Alta


We have a prepared and declared cursor with status=0 that returns the SQL
statement error number -410 at the moment it his opened.

This cursor is prepared, declared and opened in a valid transaction and the
table is not corrupted.

We have a lot of databases and this is happening only with one of them.

We appreciate any help.

Thanks.

José Manuel Costa

D&C SOFTWARE, LDA.
Edifício Via Norte
Rua do Espido, 164 C 3º Sala 406
4470-177 Maia
Tel. +351 229 439 250
Fax  +351 229 439 251