Re: SQL EXCPETION PROBLEM

[Sajida Kalsoom]

Title: SQL EXCPETION PROBLEM

hi atif       its due to result set's cursor variable. if you are using sql server cursor will always move forward . try to fetch values in column in the same order as they appear in results e.g if do following     select name , company,designation from  TableCompany.   name=get(name) designation=get(designation) company=get(company)   it will results in Invalid Descriptor Index.   fetch values as   name=get(name) company=get(company) designation=get(designation)     regards sajida.     ----- Original Message ----- From: Syed Atif Ali Kazmi To: [EMAIL PROTECTED] Sent: Wednesday, February 02, 2000 8:53 PM Subject: SQL EXCPETION PROBLEM Hello ALL,         I am having an SQL EXCEPTION         "java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index"         If anyone can tell me whats the remedy then please tell me         Thanks in Advance Regards, Syed Atif Ali Kazmi Analyst Programmer Systems Private Limited, Karachi. Voice:  (Off.)  092-021-4549385-88                 (Res.)  092-021-404148 Fax No.:  092-021-4549389 Email:  [EMAIL PROTECTED] & [EMAIL PROTECTED]