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
