Re: [Firebird-devel] Scrollable cursors in DSQL

2013-02-17 Thread Alex Peshkoff
>> BTW, what would be the new API methods to support it? > They will be added later, once Alex commits his changes detaching > cursor/resultset from the statement itself. That's done. A few words about API and related changes. Prior we had allocateStatement() function which was used to create em

Re: [Firebird-devel] Scrollable cursors in DSQL

2012-12-12 Thread Dmitry Yemanov
12.12.2012 17:40, Mark Rotteveel wrote: > In JDBC, scrollability is defined by specifying the resultset type at > statement creation with a parameter, and it should not be specified by an > option in the query text by the user. JDBC dictates that if an option is > exposed in the JDBC API, then a u

Re: [Firebird-devel] Scrollable cursors in DSQL

2012-12-12 Thread Dmitry Yemanov
12.12.2012 17:43, Adriano dos Santos Fernandes wrote: > > The SQL solution has more issues: > - No way to support scrollable EXECUTE BLOCK result (not sure if you > gonna to implement this, but is theoretically possible) It's not covered by the current implementation and, speaking honestly, I'd h

Re: [Firebird-devel] Scrollable cursors in DSQL

2012-12-12 Thread Adriano dos Santos Fernandes
On 12/12/2012 10:56, Dmitry Yemanov wrote: > All, > > Firebird v3 supports scrollable cursors in PSQL and I'm going to surface > them at the DSQL level as well. However, there's a question about how > they should be declared. In PSQL, this is done in the cursor > declaration, as per SQL spec: >

Re: [Firebird-devel] Scrollable cursors in DSQL

2012-12-12 Thread Mark Rotteveel
On Wed, 12 Dec 2012 16:56:54 +0400, Dmitry Yemanov wrote: > All, > > Firebird v3 supports scrollable cursors in PSQL and I'm going to surface > them at the DSQL level as well. However, there's a question about how > they should be declared. In PSQL, this is done in the cursor > declaration, as

[Firebird-devel] Scrollable cursors in DSQL

2012-12-12 Thread Dmitry Yemanov
All, Firebird v3 supports scrollable cursors in PSQL and I'm going to surface them at the DSQL level as well. However, there's a question about how they should be declared. In PSQL, this is done in the cursor declaration, as per SQL spec: DECLARE MY_CUR [SCROLL | NO SCROLL] CURSOR FOR () Howe