Information générale
Catégorie:
Codage, syntaxe et commandes
>>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,
This is not really a table. It is temporary cursor returned from SQL Server. There is probably a workaround. I would create a read/write cursor from the structure, add the new field, and then add the data to the new cursor.
Précédent
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