Re: Cursor Problem.

BKR Should you not have an INTO clause, like so: select emp_desig_cd INTO $v_emp_desig_cd from pmm_designation where emp_desig_cd in (select post_cd from pmm_stn_strength) HTH Sujit "K. BHASKAR" <k.bhaskar@tatainfotech.com> on 06/09/99 10:13:39 PM To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Cursor Problem. Hi I have a query which works fine as a select statement. But when used in cursor gives an error. as in select emp_desig_cd from pmm_designation where emp_desig_cd in (select post_cd from pmm_stn_strength)The above select when declared as a cursor does not work. Informix version 7.21 Also how to get Sql version Thanks in advance BKR