At 09:06 AM 18/03/2005 +0100, you wrote:

>Hi,
>
> for debug purposes I want to print the execution plan of a query.
> I've found a plan property in TIBODataset and but not in
> TIB_Cursor.
>
> Is there a way to get the plan for a TIB_Cursor statement?
>
> (As it's for debug purposes only I don't want to touch the object
> type in this situation and it would be very stupid to execute the
> query again in another component only for getting a plan....)
>

var
plan: string;
begin
....
if not ib_cursor1.Prepared then
ib_cursor1..Prepare;
plan := ib_cursor1.StatementPlan;
...
end

Helen