Thanks a lot Adriano.
This will definitely fit in my case very well. Let me take a look into this.
@Alex: Sorry that was v2.1.3 :)
Thanks,
Gopala
On Thu, Jan 24, 2013 at 1:50 PM, Adriano dos Santos Fernandes <
adrian...@gmail.com> wrote:
> On 24/01/2013 11:40, Gopala Krishna Gundeboyina wrote:
> > Hi Adriano,
> >
> > I have this implemented as an UDF and currently using it as
> > workaround. My queries look like this:
> >
> > * select * from VISITLOG where HINTUDF('USERCATEGORY=''cat1''') =1.
> >
> > I am parsing the blr to extract this information and also optmized it
> > to execute the HINTUDF udf only once instead for each row. But as you
> > said it is ugly and user has to take pain in escaping single quotes if
> > the hint involves sql queries or nested sql queries which is a
> > possibility.
> >
> > * select * from VISITLOG where HINTUDF('select * from USERS where
> > catogary=''cat1'') =1.
> >
> > But it works just fine. Moving this to comment section will be a neat
> > way and it is readable too in editors :)
> >
> Firebird 3 has an additional string encoding (it will not be backported
> by the project, but maybe you can do it for your version).
>
> q'{ ... ... ... ' ... ... ... }'
> q'[ ... ... ... ' ... ... ... ]'
> q'( ... ... ... ' ... ... ... )'
>
> The single quote inside it is not escaped. You can also open/close with
> the same character:
>
> q'# ... ... ... ' ... ... ... #'
>
>
> Adriano
>
>
>
> ------------------------------------------------------------------------------
> 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
