RE: Prepared statement failed or was not executed

Hello Bryce

In fact, the cursor is declared in a function that returns documents number
and is linked in a large number of programs. This problem occurs only in one
of them. That's why i dont'n understand this.

Thank's, anyway.
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 Bryce Stenberg
Enviada: domingo, 4 de Setembro de 2005 23:56
Para: [email protected]
Assunto: RE: [fourjs-users] Prepared statement failed or was not
executed


Hi José,

A -410 sounds like it may be caused by sql problem?

Have you tried debugging by outputting the sql about to be prepared and then
copy/paste it into an sql editor to run against the same database?
In the past I have similar problem from working program when one field is
loaded from table but has unexpected data that breaks the sql, but I don't
know if it was a -410.

Sorry can't offer any other ideas?

Regards,
  Bryce Stenberg
  Harness Racing New Zealand Inc.
  IT Department.


> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of José Costa
> Sent: Saturday, 3 September 2005 4:53 a.m.
> To: [email protected]
> Subject: [fourjs-users] Prepared statement failed or was not executed
> Importance: High
>
> 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
>
>
>
>