>When I do:
>
> =SQLEXEC(ThisForm.r_nHandle,l_cSQL,'temCursor')
>
>
>The cursor comes back with 2 fields (cause that's how many I called) but I want to add one more field to that cursor to keep track of user's changes to it.
>If I create a cursor beforehand with the same name (tempCursor) that will be replaced with my =SQLEXEC
>How do I add another field ?
You could CREATE CURSOR permCursor (tmpCursor Field1,TmpCursor Field 2 , permCursor Field 3)
then ..
=SQLEXEC(ThisForm.r_nHandle,l_cSQL,'temCursor')
select permCursor
append from tempCursor
HTH