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