I know of SET STATUS MESSAGE and SET PROGRESS but from what I can understand from the manual these can only be "wrapped round" a statement so if you have something like

SELECT ... FROM CallList WHERE ...;
CREATE INDEX  "Priority-Contact" ON "CallList" (_Priority,_Surname,_Forename);
CREATE INDEX  "Priority-Company" ON "CallList" (_Priority,_CompanyName);
CREATE INDEX  "Random" ON "CallList" (_Random);
CREATE INDEX  "Contact" ON "CallList" (_Surname,_Forename);

The best I can achieve is something like

Doing select
Creating index priority-contact
...
...
Creating index Contact

I'd like to have a progress bar for the individual statements (eg the select may take 15 secs) - is there a way to do this?

Roy Lambert

Roy,

<< I'd like to have a progress bar for the individual statements (eg the
select may take 15 secs) - is there a way to do this? >>

This is on the list already, but not scheduled.  Robin Joseph asked for this
a few months ago, and I suspect that it will be done in the manner of
providing a different progress event and/or statement for enabling it in the
SQL scripts/procedures/functions.

--
Tim Young
Elevate Software
www.elevatesoft.com