RE: Prepared statement failed or was not executed
"Bryce Stenberg" <[email protected]>
| Newsgroups | gmane.comp.lang.4gl.fourjs.user |
|---|---|
| Message-ID | <[email protected]> |
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 > > > >