RE: Prepared statement failed or was not executed

We had exported and imported the database with no results.

The problem does not occur everytime the program is executed. One day it
occurs 2 times and another day it occurs 30 times. This happens only in one
of our client's and all of them work with the program to make invoices.

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


-----Mensagem original-----
De: [email protected] [mailto:[email protected]]Em
nome de Nuno Godinho
Enviada: segunda-feira, 5 de Setembro de 2005 18:41
Para: [email protected]
Assunto: RE: [fourjs-users] 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