>Your right, aerror() is looking at old errors, however I ran it again and z = .T. also I modified my update string to following to get different results each time I looped:
>
>

>	    lnRes = CURSORSETPROP( "Buffering", 5, "lcCursor" )
>	    *** Update the display
>	    .counter = .counter + 1
>	    lcSql = " update UDFields set firstname = '"+ STR(.counter) +"' where UDFields.SSNo = '"+g+"'"
>    z = TABLEUPDATE(.t.,.t.,"lcCursor")
>		lnRes = .oCon.CloseConn(.nCon)

>
>and it still didn't update my table. I'll play around with it some more. Thanks
>
>Nick Patel

Nick,

The following line doesn't execute update, it assigns string to variable lcSql.

lcSql = " update UDFields set firstname = '"+ STR(.counter) +"' where UDFields.SSNo = '"+g+"'"

I believe you want to modify records in lcCursor.

Thanks,
Aleksey.