Hi Karol,
Thanks for the reply.
My application is not a relational database but a library and hence I
cannot use execute statement.
This application stores data in binary format on disk with a complex
business logic applied and has c++ apis to access data. I embedded the
Firebird Server (v2.5) within this application and mapped firebird external
table interface to c++ apis to get all the benefits of a database mainly
the SQL interface.
Hope this helps. Please let me know if you need more information on my
requirement from first mail.
Thanks,
Gopala
On Wed, Jan 23, 2013 at 10:13 PM, liviusliv...@poczta.onet.pl <
liviusliv...@poczta.onet.pl> wrote:
> HI,
> first of all wrong group this is not support list.
>
> But you doing somethink what is supported by execute statement, and you do
> mot need to modify external table intf. Execute statement in Fb2.5 can run
> query against external database
>
> Regards,
> Karol Bieniaszewski
>
>
> ----- Reply message -----
> Od: "Gopala Krishna Gundeboyina" <f2001...@gmail.com>
> Do: "For discussion among Firebird Developers" <
> firebird-devel@lists.sourceforge.net>
> Temat: [Firebird-devel] SQL Hint
> Data: śr., sty 23, 2013 15:32
>
>
> Hi All,
>
> I have modified Firebird External Table interface to retrieve data from a
> proprietary database basically to take advantage of the SQL interface.
>
> I have been using it for some time and most of the standard SQL statements
> work great. But there are some additional attributes (call them as HINT)
> that I want to pass along with the SQL queries which basically makes sense
> to proprietary database but are non SQL standard.
>
> I was looking for a clean solution and the first thing I tried was to
> embed them as comments (HINT) in SQL statements extract them while
> executing it. I was able to extract them from plain SQL statements but
> obviously it doesn't work with parametrized queries, stored procedures and
> views as they are ignored in BLR form.
>
> Can someone please suggest me a workaround or a better way to achieve
> this? Any alternate options that I have?
>
> Thanks in advance!!
>
> -Gopala
>
>
>
> ------------------------------------------------------------------------------
> 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
