![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
![]() |
Fri, Mar 26 2010 10:02 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 |
Fri, Mar 26 2010 2:22 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
Fri, Mar 26 2010 2:54 PM | Permanent Link |
Rita Tipton | 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 > > |
Sat, Mar 27 2010 10:00 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
OK I'll just pop up one of those "something is happening even if we don't know what" displays then. Roy Lambert |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |