Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
Error 1103. |
Fri, Feb 14 2020 6:46 AM | Permanent Link |
Steve Gill | 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 PM | Permanent Link |
Steve Gill | 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 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |