Unanswered: Problem with SAP DB stored procedures and Delphi
I am using SAP DB 220.127.116.11 on a Windows 2003 Server and Delphi 7 for an application. I have writen a stored procedure that returns a cursor based on some parameters, and it works fine. But if I try to edit or insert some data into the DBGrid that displays the results of the TADOStoredProc, I get a "Insufficient base table infomation for updating or refreshing".
It doesn't matter whether the dbproc returns data from one or more tables, whether it returns the primary key or not, I get the same result.
I don't have the same problem on MS SQL Server, so it must be because of the way SAP DB retrieves the cursor.