IB Objects allows you to view the user friendly presentation of BLR for
stored procedures.
There is a freeware tool called IB_SQL which has a place on it showing the
BLR sources.

I suggest you take a look at it. It is freeware and if you get IBO you can
get full source to it too.

I also have a BLR sample application that shows you how to write a BLR
client so you can take full advantage of Interbase capabilities. It's still
a bit rough though as I have not been able to figure out how the message
field alignment in the buffers works under certain combinations. We will
probably need to examine the sources to figure this out.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Alexander V.Nevsky" <alex_vnru@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, July 24, 2001 1:10 PM
Subject: [ib-support] How can I inspect BLR?


> Hi, All. Is there any tool or way to inspect BLR for query or SP?
> Or
> I must study sources to understand principles of it's buiding? I want
> to realize exactly what is the difference between
>
> 1.
> Select T1.<something>, T2.Column
> From T1 Left Join T2 On T1.Col1=T2.Col1
> 2.
> Select T1.<something>, (Select Column From T2 Where T2.Col1=T1.Col1)
> From T1
> 3.
> Create SP
> Returns (<something>, Column)
> As
> Declare Variable Col1;
> Begin
> For Select T1.<something>, T1.Col1 Into <something>, :Col1
> Do
> begin
> Select Column From T2 Where Col1=:Col1 Into :Column;
> Suspend;
> end
> End
>
> and what should be faster and why. Or someone wise will be so kind to
> explain?
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>