Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 5 of 5 total

Session.OnProgress event changed in edb2 ?

Mon, Nov 16 2009 5:18 AM	Permanent Link
Michael Reisch	I´m upgrading from edb 1.09 to edb 2.03. In edb 1 I use Session.OnProgress Event to show a ProgressBar for e.g. REPAIR TABLE. I call this command as: EDBDatabase.Execute('REPAIR TABLE ' + slTables[i]); When I change to EDBDatabase.OnProgress to show my ProgressBar then I see always 0% and 100% no steps between. The Session.OnProgress I use also to show progress of BACKUP DATABASE command - this works fine. Can anybody tells me which event is the right one for me? Michael Reisch
Mon, Nov 16 2009 3:56 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Michael, << I call this command as: EDBDatabase.Execute('REPAIR TABLE ' + slTables[i]); When I change to EDBDatabase.OnProgress to show my ProgressBar then I see always 0% and 100% no steps between. >> Does the REPAIR TABLE statement take longer than 1 second or so ? << Can anybody tells me which event is the right one for me? >> The TEDBDatabase OnProgress event is the right event for this. -- Tim Young Elevate Software www.elevatesoft.com
Fri, Dec 4 2009 5:12 AM	Permanent Link
Michael Reisch	Tim, All works fine if I have Local connection to the database, but if I have a Remote connection the Session.OnProgress is not fired. This is the way I do it. FEDBSession.OnProgress := frmDBState.DoDatabaseProgress; try EDBSession.Execute('BACKUP DATABASE "' + EDBDatabase.Database + '"' + ' AS "' + ExtractFileName(Result) + '"' + ' TO STORE "Backup"' + ' INCLUDE CATALOG'); finally FEDBSession.OnProgress := nil; end; frmDBState is my TForm with the ProgressBar. Best regards Michael "Tim Young [Elevate Software]" wrote: Michael, << I call this command as: EDBDatabase.Execute('REPAIR TABLE ' + slTables[i]); When I change to EDBDatabase.OnProgress to show my ProgressBar then I see always 0% and 100% no steps between. >> Does the REPAIR TABLE statement take longer than 1 second or so ? << Can anybody tells me which event is the right one for me? >> The TEDBDatabase OnProgress event is the right event for this. -- Tim Young Elevate Software www.elevatesoft.com
Tue, Dec 8 2009 6:27 AM	Permanent Link
Tymoteusz Paszun	Hello! I noticed the same problem in our application. We use remote connection (but server is on localhost) and OnProgress event isn't fired (I created completely new project and the result is the same). Few build earlier everything worked fine. Regards -- Tymoteusz Paszun Axence Software
Sat, Dec 12 2009 12:24 PM	Permanent Link
"Terry Swiers"	Tymoteusz, > I noticed the same problem in our application. We use remote connection > (but server is on localhost) and OnProgress event isn't fired (I created > completely new project and the result is the same). Few build earlier > everything worked fine. Same here. I've also noticed that the execution time for SQLs done against a remote connection is not being displayed from within EDB Manager either. I assume that this is related to the OnProgress information not being sent back to the client as well. -- --------------------------------------- Terry Swiers Millennium Software, Inc. http://www.1000years.com http://www.atrex.com Atrex Inventory Control/POS - Big business features without spending big business bucks! Atrex Electronic Support Options: Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp Email: mailto:support@atrex.com Newsgroup: news://news.1000years.com/millennium.atrex Fax: 1-925-829-1851 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific) ---------------------------------------