Re: [Firebird-devel] READ BLOB / INSERT BLOB SQL commands

2012-02-06 Thread Alex Peshkoff
On 02/04/12 11:58, Mark Rotteveel wrote: > On 1-2-2012 18:57, Adriano dos Santos Fernandes wrote: >> BTW, how can isc_dsql_insert work, not considering the read/insert blob >> commands? >> >> This function is documented (in the sources) as "Insert next record into >> a dynamic SQL cursor", but is

Re: [Firebird-devel] READ BLOB / INSERT BLOB SQL commands

2012-02-04 Thread Mark Rotteveel
On 1-2-2012 18:57, Adriano dos Santos Fernandes wrote: > BTW, how can isc_dsql_insert work, not considering the read/insert blob > commands? > > This function is documented (in the sources) as "Insert next record into > a dynamic SQL cursor", but is not documented in IB 6 API guide, nor I > found a

Re: [Firebird-devel] READ BLOB / INSERT BLOB SQL commands

2012-02-02 Thread Alex Peshkoff
On 02/02/12 16:39, Adriano dos Santos Fernandes wrote: > On 02-02-2012 08:34, Alex Peshkoff wrote: > >> Looks like that when introducing cursors people wanted to follow some >> standard that existed that time. But from today POV this commands look >> useless and should better be removed - speciall

Re: [Firebird-devel] READ BLOB / INSERT BLOB SQL commands

2012-02-02 Thread Adriano dos Santos Fernandes
On 02-02-2012 08:34, Alex Peshkoff wrote: > > Looks like that when introducing cursors people wanted to follow some > standard that existed that time. But from today POV this commands look > useless and should better be removed - specially if they cause problems > with engine stability. But proba

Re: [Firebird-devel] READ BLOB / INSERT BLOB SQL commands

2012-02-02 Thread Alex Peshkoff
On 02/01/12 21:57, Adriano dos Santos Fernandes wrote: > On 01-02-2012 12:46, Dmitry Yemanov wrote: >> 31.01.2012 2:12, Adriano dos Santos Fernandes wrote: >>> There is two obscure SQL commands called READ BLOB and WRITE BLOB. >>> >>> The idea behind these commands is to make blob read/write using

Re: [Firebird-devel] READ BLOB / INSERT BLOB SQL commands

2012-02-01 Thread Adriano dos Santos Fernandes
On 01-02-2012 12:46, Dmitry Yemanov wrote: > 31.01.2012 2:12, Adriano dos Santos Fernandes wrote: >> >> There is two obscure SQL commands called READ BLOB and WRITE BLOB. >> >> The idea behind these commands is to make blob read/write using the >> cursor (fetch/insert) API. Why they exist is not so

Re: [Firebird-devel] READ BLOB / INSERT BLOB SQL commands

2012-02-01 Thread Dmitry Yemanov
31.01.2012 2:12, Adriano dos Santos Fernandes wrote: > > There is two obscure SQL commands called READ BLOB and WRITE BLOB. > > The idea behind these commands is to make blob read/write using the > cursor (fetch/insert) API. Why they exist is not something I know, maybe > it predates blob API funct

Re: [Firebird-devel] READ BLOB / INSERT BLOB SQL commands

2012-02-01 Thread Adriano dos Santos Fernandes
On 01-02-2012 11:00, Alex Peshkoff wrote: > On 01/31/12 02:12, Adriano dos Santos Fernandes wrote: >> All, >> >> There is two obscure SQL commands called READ BLOB and WRITE BLOB. >> >> The idea behind these commands is to make blob read/write using the >> cursor (fetch/insert) API. Why they exist

Re: [Firebird-devel] READ BLOB / INSERT BLOB SQL commands

2012-02-01 Thread Roman Simakov
2012/2/1 Alex Peshkoff : > I like the suggestion, but one question. How much are we sure that this > commands are not used in some popular client tool? Do you remember the > case with ibase.h cleanup which broken kinterbasdb stable build? Fix is > certainly trivial, done in SVN - but current stable

Re: [Firebird-devel] READ BLOB / INSERT BLOB SQL commands

2012-02-01 Thread Alex Peshkoff
On 01/31/12 02:12, Adriano dos Santos Fernandes wrote: > All, > > There is two obscure SQL commands called READ BLOB and WRITE BLOB. > > The idea behind these commands is to make blob read/write using the > cursor (fetch/insert) API. Why they exist is not something I know, maybe > it predates blob

[Firebird-devel] READ BLOB / INSERT BLOB SQL commands

2012-01-30 Thread Adriano dos Santos Fernandes
All, There is two obscure SQL commands called READ BLOB and WRITE BLOB. The idea behind these commands is to make blob read/write using the cursor (fetch/insert) API. Why they exist is not something I know, maybe it predates blob API functions? Currently there is problems related to some request