>>Does it not work if you put the alias before each field (Ie, instead of myField always use myTable.myField to see what happens.
>
>So far, no luck with that. I put the alias on each field in the select command and manually specified the updatecmd preceeding each field with the alias.
>
>I've also tried changing fieldname in the selectcmd (select invalidfieldname1 AS validfieldname1..), letting VFP automatically generate the updatecommand and that still didn't work (AERROR shows syntax error).
>
>Nuts.

Could you post UpdateNameFields and Updateble FIeldList priperties?

If you have:
SELECT Fld1, InvalidFieldName AS ValidName ...
in SelectCmd
Then UpdatableFieldList should be:
Fld1, ValidFieldName
and UpdateNameList should be:
Fld1 TableName.Fld1, ValidFieldName TableName.InvalidFieldName

NOT TESTED AT ALL.