ERR-"INSUFFICIENT KEY COLUMN INFORMATION FOR UPDATING OR REFRESHING"

[TNN]

I have opened a recordset with ADO as follows:

adoRsF2Screen.CursorLocation = adUseClient
adoRsF2Screen.CursorType = adOpenStatic
adoRsF2Screen.LockType = adLockOptimistic
adoRsF2Screen.Open Source:=strSQLF2, ActiveConnection:=adoConnection, _
Options:=adCmdText

strSQLF2 is a string containing a stored procedure DisplayF2 with parameter strEmployee_Number. See below.

strSQLF2 = "EXECUTE DisplayF2 " & (strEmployee_Number)

When I try to edit the recordset and update I get the following error: "INSUFFICIENT KEY COLUMN INFORMATION FOR UPDATING OR REFRESHING"

Can anyone point me to where the problem might be????
I have used this same scenario to edit and update other tables but having this problem on a particular table. Could it be my stored procedure???? Stored procedure below:

DisplayF2
PARAMETERS [Employee_Number] IEEEDouble;
SELECT DEDNAME, BASSDEDS.DEDNO, DEPT, TYPE, AMOUNT, MTD_AMT, QTD_AMT, YTD_AMT, EMPNO
FROM BASSDEDS INNER JOIN BASSDDED ON BASSDEDS.DEDNO = BASSDDED.DEDNO
WHERE EMPNO = [Employee_Number];

Thank You for any help. TNN, Tom
TNPAYROLL@AOL.COM



TOM

http://WWW.TNPAYROLL@AOL.COM

 

[foxdev]

It doesn't appear to be a SQL Server stored procedure.

Robert Bradley

http://www.foxdev.com/

 

[TNN]

Hi Robert,
Above procedure is right out of the schema for the datadbase.
Set adoRsFields = adoConnection.OpenSchema (adSchemaProcedures)

Do Until adoRsFields.EOF

Debug.Print adoRsFields!PROCEDURE_NAME
Debug.Print adoRsFields!PROCEDURE_DEFINITION & vbCrLf & vbCrLf
adoRsFields.MoveNext
Loop
TNN, Tom
TNPAYROLL@AOL.COM


TOM

http://WWW.TNPAYROLL@AOL.COM