On 01/24/13 16:14, Gopala Krishna Gundeboyina wrote: > @Alex: I embedded standalone Firebird Server (not embedded Firebird server)
It's just different names for same thing. Be sure - each embedded server can query outer world. > 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 We had no such release:) 2.0, 2.1 and next 2.5. > 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) > In such case you will have to deal with BLR in one or other way. ------------------------------------------------------------------------------ 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
