Yes, I can see that that should be the principle, but in practice it is not
that simple.

I will figure it out.



RBS



_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Kjell Rilbe
Sent: 25 October 2007 11:39
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Retrieve query plan with SQL?



Have a look at how external functions are declared in VB:s API text
viewer. Based on that, try to figure out how the Firebird API:s would
map to such VB function declarations. It shouldn't be too hard I hope.

Kjell

bartsmissaert@ <mailto:bartsmissaert%40blueyonder.co.uk> blueyonder.co.uk
wrote:

> Yes, I know about Google and had a good go at that, but no progress. I
> thought maybe somebody on this forum who codes in VB may have done this.
>>
>>>OK, so how would I do that from VB? I am not familiar with the FB API.
>>>
>>>>One thing though, you cannot get it by using "sql", you need to retrieve
>>>>the actual plan by using an API call.
>>>>
>>>>>Is it possible in FB 2.0 to retrieve the query plan of a query in SQL,
>>>>>without actually running that query? If not is there any way to do
>>>>>this from VB?

--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@datadia. <mailto:kjell%40datadia.se> se
Telefon: 08-761 06 55
Mobil: 0733-44 24 64





[Non-text portions of this message have been removed]