>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?
To clarify, the PK field is on the server. I meant to say that the data in the PK fields are not on the server yet so it is not a problem with duplicates.
Richard DeZeeuw
DeZeeuw Software Inc.