Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Error 1103.
Fri, Feb 14 2020 6:46 AMPermanent Link

Steve Gill

Avatar

Hi Tim,

After upgrading to 2.31 Build 11 I have started getting an error with a stored procedure:

"ElevateDB Error #1103 An invalid or unknown request was sent to the server"

If I run the stored procedure directly in ElevateDB Manager it works fine.

The SQL is very simple:

CREATE PROCEDURE "GetUserToDoList" (IN "PUserID" INTEGER)
BEGIN

  DECLARE Result CURSOR WITH RETURN FOR SQLStatement;

  PREPARE SQLStatement FROM
     'SELECT *
        FROM ToDoList
       WHERE UserID = ?';

  OPEN Result USING PUserID;

END


The error occurs on the Prepare:

     spGetUserToDoList.Prepare;
     spGetUserToDoList.ParamByName('PUserID').AsInteger := Global.UserDetails.UserID;
     spGetUserToDoList.Open;


= Steve
Fri, Feb 14 2020 3:21 PMPermanent Link

Steve Gill

Avatar

I restarted RAD Studio and now it's working fine.

Not sure what happened there.  Must have been something going weird with the IDE.

= Steve
Image