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
