Hi All,

I have a cursor where I can add records, replace info in the fields but thats it. I would like to know how to add a field to this cursor. I have tried the following.

nconhandle = sqlexec(nhandle, csqlstatement, 'temp_cursor')

IF nconhandle < 0
THISFORM.bad_connect
RETURN
ENDIF

IF USED('empl_cursor')
SELECT empl_cursor
USE
ENDIF

USE DBF('temp_cursor') AGAIN IN 0 ALIAS empl_cursor

SELECT empl_cursor
* Here I need to add an undetermined number of fields.
FOR nfld_cntr = 1 TO (ALEN(specprojarray) / 2)
ctemp_fld = ALLTRIM(spec_proj_array(nfld_cntr, 2))
ALTER TABLE DBF('empl_cursor') ADD COLUMN &ctemp_fld N(8,2)
ENDFOR

What is it that I am missing here? Any help is apreciated.

TIA
Mike