Check the return value of TABLEUPDATE(). Assuming it's returning .F., use AERROR() to see what error is being returned.

You say the PK field is not in the SQL Server table. I assume that there is a PK in the SQL table. You really can't use TABLEUPDATE() without a PK, though you might get away with it if you're only appending records.

>I am using Visual FoxPro 6 and SQL Server 6.5.
>
>I am attempting to issue a tableupdate command as follows:
>
> =TABLEUPDATE(1,.T.)
>
>If I have eight records, it works.
>If I have nine records, it fails.
>
>All of the records are identical except for a unique PK field.
>The PK fields do not exist in the SQL Server table.
>
>Any ideas?