error 243

Hi Guyz, i have a select statement in a 4gl program. select * into variable_record.* from table_name where table_name.primary_key = integer_value The sqlca.sqlcode check gives an error of 243. However when I do the same select in query language, no error occurs. I know i don't need a declare cursor because it is a singelton select, any ideas. I would really appreciate a speedy response - I have a deadline. Thanx austin