>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
Mike, ALTER TABLE requires exclusive use of the table.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison