Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Add a field to a cursor
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement