@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
i believe.
With that I think I can now put my requirement in detail.Lets say I have a
SQL query:
- 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)
Thanks,
Gopala
On Thu, Jan 24, 2013 at 9:47 AM, Alex Peshkoff <peshk...@mail.ru> 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,
> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
> MVPs and experts. ON SALE this month only -- learn more at:
> http://p.sf.net/sfu/learnnow-d2d
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnnow-d2d
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
