Is there any way of getting meaningful progress information (eg to update a progress bar) from sql with derived tables? eg

SELECT
_Forename + ' ' + _Surname + ' ('+X1+')',
_Surname + _Forename + CAST(COALESCE(_fkCompanies,0) AS VARCHAR(10)) +CAST(COALESCE(_fkSites,0) AS VARCHAR(10))
FROM (SELECT _Surname, _Forename, _fkCompanies, _fkSites, CAST (COUNT(*) AS VARCHAR(3)) AS X1
     FROM Career C1
     LEFT OUTER JOIN Contacts Who ON Who._ID = _fkContacts
     WHERE _Left IS NULL AND _Surname IS NOT NULL AND _Forename IS NOT NULL
     GROUP BY _Surname, _Forename, _fkCompanies, _fkSites
     HAVING Count(*) > 1) AS T1


Roy Lambert

Roy,

<< Is there any way of getting meaningful progress information (eg to update
a progress bar) from sql with derived tables? >>

Not really - they are implemented as temporary views, and the view
functionality in EDB does not make allowances for generating progress
messages.

I'll add it to the list, though.

--
Tim Young
Elevate Software
www.elevatesoft.com

There was a guy who did his own scripts and it ran a progressbar
in DBIsam 2 and Topaz + Halcyon and BDE tables.
I hear he went out of biz tho and all I can find on him is.
http://ftp.sunet.se/delphi/ftp/d30free/sqlscr.htm
The link on this page however bombs.
I stopped using it in V3 as it slowed DBIsam down. I no longer have it
unless its on an old HDD I pulled from my scrap machines.
I hear SQL 2005 allows for such a beast tho so when Tim finishes
chisseling away in his cave on SQL92 + SQL2003 you may get it

I never really had much time for SQL myself but since seeing some of
the power of the lingo posted on here by yourself + John + Robert and
others I'am taking a keen interest in it more and more when I should be
putting my feet up

Good luck and if u find a cheapy todo it let us know.
Rita

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:99755DF0-C876-4555-B418-E98130432770@news.elevatesoft.com...
> Is there any way of getting meaningful progress information (eg to update
> a progress bar) from sql with derived tables? eg
>
> SELECT
> _Forename + ' ' + _Surname + ' ('+X1+')',
> _Surname + _Forename + CAST(COALESCE(_fkCompanies,0) AS VARCHAR(10))
> +CAST(COALESCE(_fkSites,0) AS VARCHAR(10))
> FROM (SELECT _Surname, _Forename, _fkCompanies, _fkSites, CAST (COUNT(*)
> AS VARCHAR(3)) AS X1
> FROM Career C1
> LEFT OUTER JOIN Contacts Who ON Who._ID = _fkContacts
> WHERE _Left IS NULL AND _Surname IS NOT NULL AND _Forename IS NOT NULL
> GROUP BY _Surname, _Forename, _fkCompanies, _fkSites
> HAVING Count(*) > 1) AS T1
>
>
> Roy Lambert
>
>

Tim


OK I'll just pop up one of those "something is happening even if we don't know what" displays then.

Roy Lambert