The value of AERROR() is as follows:
Test(1) N 1526
Test(2) C Connectivity error Microsoft ODBC SQL Server Driver Invalid pararmeter number
Test(3) C Microsoft ODBC SQL Server Driver Invalid parameter number
Test(4) C S1093
Test(5) N 0
Test(6) N 1
Test(7) C
The SQL Line from the View is:
SELECT * ;
FROM dbo.arshipline Arshipline;
WHERE Arshipline.rol_rohfk = ?lcrol_rohfk
Other important stuff from the view:
Key and Modified Fields is selected
SQL Update is selected
Send SQL Updates is selected
Key Field is rol_pk
Timestamp is not selected for update
Remember that it works if I am updating 8 records.
It fails if I am updating 9 records.
All records are identical except for the rol_pk field.
The value of the rohfk is the same for all 9 records.
Any ideas?
>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?
Richard DeZeeuw
DeZeeuw Software Inc.