Hi folks....

SqlState 42s22 is killing me slowly here.... I have 2 programs reading exactly the same table in the same database..... 1 program declares, opens, fetchs, updates cursor No problem..... The second program uses exactly the same code, but the declare cursor blows out on a 42s22 code..... I for thelife of me cannot figure out what is happening....... I copied and paste the code from the working program into the non working program to no avail,same error condition repeats..... Has anyone ever seen this before, or does anyone have any suggestions.....

Thank-you
Mike
__________________________________________________ _______________
Sympatico/MSN Autos wants to put YOU in a 2008 Eclipse! Click here to enter!
http://g.msn.ca/ca55/212

Hi Mike,

could you please be more precise?
What platform, language, versions are you using for the client application?
What o.s. and version are you using for mysql server?
Which is the code giving you problems?
The more information you give, the easier is to answer.

Aloha!

Claudio Nanni




-----Messaggio originale-----
Da: Michael Abbott [mailto:damysus@hotmail.com]
Inviato: lunedì 24 marzo 2008 2.36
A: mysql@lists.mysql.com
Oggetto: SqlState error code 42S22 driving me insane


Hi folks....

SqlState 42s22 is killing me slowly here.... I have 2 programs reading exactly the same table in the same database..... 1 program declares, opens, fetchs, updates cursor No problem..... The second program uses exactly the same code, but the declare cursor blows out on a 42s22 code..... Ifor the life of me cannot figure out what is happening....... I copied and paste the code from the working program into the non working program to no avail, same error condition repeats..... Has anyone ever seen thisbefore, or does anyone have any suggestions.....

Thank-you
Mike
__________________________________________________ _______________
Sympatico/MSN Autos wants to put YOU in a 2008 Eclipse! Click here to enter!
http://g.msn.ca/ca55/212


"Questo messaggio ed ogni suo allegato sono confidenziali e possono essere riservati o, comunque, protetti dall'essere diffusi. Se il ricevente non é il destinatario diretto del presente messaggio, é pregato di contattare l'originario mittente e di cancellare questo messaggio ed ogni suo allegato dal sistema di posta. Se il ricevente non é il destinatario diretto del presente messaggio, sono vietati l'uso, la riproduzione e la stampa di questo messaggio e di ogni suo allegato, nonché ladiffusione del loro contenuto a qualsiasi altro soggetto"
*****
"This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient,please contact the sender and delete this message and any attachment from your system. If you are not the intended recipient you must not use, copy or print this message or attachment or disclose the contents to any other person."