RE: Prepared statement failed or was not executed

Hi Jose,

Have you checked if the name of the cursor or the statement is conflicting with some Stored Procedure (with a cursor name or even a procedure name) in the database with problems ?

Florencia

> -----Mensaje original-----
> De: [email protected] [mailto:[email protected]]En
> nombre de José Costa
> Enviado el: Lunes, 05 de Septiembre de 2005 15:04
> Para: [email protected]
> Asunto: RE: [fourjs-users] Prepared statement failed or was not executed
> Importancia: Alta
> 
> 
> 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
> 
> 
> 
> 
> -- 
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.344 / Virus Database: 267.10.18/89 - Release Date: 02/09/2005
> 
>