Automatically close unused cursor

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
delphi7
Posts: 15
Joined: Wed 12 Mar 2014 12:28

Automatically close unused cursor

Post by delphi7 » Sun 15 Feb 2015 07:05

Hello Alex,

is there a methode to close unused cursor,or to detect if a cursor is unused to close it after?

thanks

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Automatically close unused cursor

Post by AlexP » Mon 16 Feb 2015 09:06

Hello,

ODAC includes an option AutoClose, that closes the cursor after retrieving all data. See more details in the documentation:
http://www.devart.com/odac/docs/devart_ ... oclose.htm .

delphi7
Posts: 15
Joined: Wed 12 Mar 2014 12:28

Re: Automatically close unused cursor

Post by delphi7 » Mon 16 Feb 2015 15:27

Hello,
how can i assign this methode direcly to my query or my function()which return cursor to apply the the behavior autoclose after unused cursor.

thanks

delphi7
Posts: 15
Joined: Wed 12 Mar 2014 12:28

Re: Automatically close unused cursor

Post by delphi7 » Sun 22 Feb 2015 07:31

Hello , :D

i find the methode, its very simple haha, its located in options of query or storedprocedure component.

thank you

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Automatically close unused cursor

Post by AlexP » Mon 23 Feb 2015 06:13

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.

Post Reply