"Statement already has a cursor assigned" error when trying to execute another SQL statement using different cursor name ------------------------------------------------------------------------------------------------------------------------
Key: CORE-4286 URL: http://tracker.firebirdsql.org/browse/CORE-4286 Project: Firebird Core Issue Type: Bug Affects Versions: 3.0 Alpha 1 Environment: 64-bit server fb30alpha1 (30761) classic on sles11 sp3, 32-bit fbclient.dll on winXPpro, IBObjects 5.2.0.6 (delphi XE2) Reporter: Paulius Pazera our application uses IBObjects, and it did not work with fb3. It was giving "Statement already has a cursor <cursorName> assigned". We are using the same TIB_Cursor object to execute different SQL statements. First statement is executed ok, second gives the error (showing cursor name from first execution). I checked IBObjects code and found that during unprepare they clear cursor name, and during prepare, if cursor name is empty then it generates random value. After I modified IBObjects unprepare code not to clear previous cursor name (as a work around) then it started to work with fb3 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel