@Alex: I embedded standalone Firebird Server (not embedded Firebird server)
in to my application as a Dll. So Firebird Server works as a standalone
most of the time but only for configured external tables it uses my library
for data retrieval.
I have this done on Firebird Server v2.3 at the time ExtDS is not availabe
With that I think I can now put my requirement in detail.Lets say I have a
- select * from VISITLOG /*+ USERCATEGORY='cat1' */
>From the above query, I want to get data for a group of users which the
underlying API understands and uses it as an index for data retrieval . I
can extract this comment in a sql statement, but as you said the problem is
I cannot see it once it is translated to BLR. (I do not want to parametrize
hint I just meant this happens in SP, VIews and parametrized queries)
On Thu, Jan 24, 2013 at 9:47 AM, Alex Peshkoff <peshkoff@...> wrote:
> On 01/24/13 12:53, Dmitry Yemanov wrote:
> > 24.01.2013 12:44, Alex Peshkoff wrote:
> >> You did not understand Karol's answer. It does not matter how is
> >> organized your application - as soon as firebird engine starting with
> >> v.2.5 is embedded into it you can use execute statement to access
> >> external datasources.
> > But not data sources that are not databases / tables, which was the
> > intention to hack the external table access code.
> Why not? One can create external data source provider just implementing
> a set of interfaces from ExtDS.h. And what he writes inside that virtual
> functions may be absolutely unrelated with databases and tables.
> >> On the other hand, I do not see how can execute statement help to
> >> transfer non-standard hints to external datasource. If you still want to
> >> use external tables than the only 'absolute' way to transfer hints to it
> >> is adding own blr code(s) for that purpose.
> > AFAIU, the problem is that he needs to pass different data for different
> > invocations of the same prepared statement. I don't see how BLR is going
> > to be a solution here.
> In this case BLR definitely not a solution, probably I've misunderstood
> initial letter. It seemed to me that a problem is lost hint (i.e. sql
> comment in mentioned implementation) when SQL is translated into BLR.
> Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
> MVPs and experts. ON SALE this month only -- learn more at:
> Firebird-Devel mailing list, web interface at