Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 8 of 8 total
Thread OnProgress of Session and Database doesn't fire in CS
Mon, May 16 2022 9:49 AMPermanent Link

Heiko Knuettel

Hi!

The OnProgress event of TEDBSession and TEDBDatabase doesn't fire in CS (haven't tried it local). In TEDBQueries it does.

What am I doing wrong?

Cheers,

Heiko
Tue, May 17 2022 4:47 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Heiko

>What am I doing wrong?

No idea. Can you share a little more info eg the code you're using.

Roy
Tue, May 17 2022 7:12 AMPermanent Link

Heiko Knuettel

Hi Roy,

I'm using derived components and a custom built server. Both shouldn't interfere with these events, but to be 100% sure I would have to create a demo project. Which I will do if needed, just thought maybe someone else could give it a try.

Maybe you already have a client/server database running? Then you just need to execute a query that does something, maybe a select. Anything, doesn't matter.

The OnProgress event of the query fires, but those on the session and database doesn't.
Tue, May 17 2022 8:52 AMPermanent Link

Heiko Knuettel

OK, sorry for being lazy. It's just a bit of a hazzle since I am usually not on the newest version, which requires a bit of uninstalling and reinstalling recompiling to get everything working again.

But I testest it now with the newest version.

I uploaded a Demo project in binaries: https://www.elevatesoft.com/forums?action=view&category=edb&id=edb_binaries&msg=107#107

The events don't fire. They don't even fire when you use a local database.
Tue, May 17 2022 10:02 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Heiko


I think you may be misunderstanding when the OnProgress event executes for database and session. From the pdf manual for TEDBSession

The OnProgress event is fired when an SQL statement is executed via the Execute method and that
statement generates progress. Assign an event handler to the OnProgress event to display the progress
in your application and to, optionally, abort the execution of the SQL statement by setting the Continue
parameter to False. The following SQL statements will generate progress:

I can see nowhere in your demo where the Execute method is called.

Roy Lambert
Tue, May 17 2022 10:13 AMPermanent Link

Heiko Knuettel

Goddammit...

...yeah. You are right. I confused the "Execute" method with the "ExecSQL" method and thought these events fire whenever a query is executed that is connected to said database/session.

Sorry!

And thanks!
Wed, May 18 2022 1:58 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Heiko

>Sorry!

No problem - I just love it when I can spot the bug so easily Smiley

Roy
Wed, May 18 2022 4:57 AMPermanent Link

Heiko Knuettel

I can relate. I also prefer the bugs to be sitting infront of the monitors owned by my customers^^
Image