Cursor Problem
Posted in 1993
mark goldin — — source: Informix-list mailing list archive (1991-1998)
Can anyone help with this problem? We have a simple SQL math routine that enters the CASE statement (below). After 3 or 4 passes it returns a message, either COMMAND POINTER IS NULL or INVALID MESSAGE TYPE. The FREE statement does not work. The Informix is 5.0 on SCO, but 4.1 works! This is the relevant code: WHEN 3 OPEN cur_c3 WHENEVER ERROR CONTINUE FETCH cur_c3 INTO xcol IF status<0 THEN LET xcol = 0 END IF WHENEVER ERROR STOP CLOSE cur_c3 Thanks - Mark Goldin -- Elite Data Processing, Inc (elite.com) Ph: 310-398-4900 Fax: 310-398-4966