SmartRefresh blocks thread...

[Flub]

Hi there,

I wanted to use the SmartRefresh feature of TSmartQueries into one of my project, but I have a trouble using it... (w/ Registered 5.70.1.33) :

What happens is exactly the same as w/ the demo project so my guess is that it comes whether from the ODAC component or from my Oracle configuration itself... Maybe you can help?

When I launch the SmartRefresh demo (I have just changed the SQL in the TSmartQueries to connect to a table of mine instead... [SELECT * FROM MY_TABLE]), the software hangs with the TSmartQuery.Open method (The SQL hourglass waiting but other applications still runs properly [No freeze]...).

It never comes back from this method... Snif.

As soon as I change the property SmartRefresh to False and start the project again, then the queries opens instantly.

Do you know where it might come from?

Thank you very much

Olivier

[Alex]

We cann't reproduce your problem.
Please specify versions of Oracle client and server you use and IDE version. Send to ODAC support address a sample that demonstrates the problem (SmartRefresh demo with your corrections).

[Flub]

Hi,


I have moved to another workstation and now it everything works... Very strange.

Trouble was with an Oracle 9i database, XP, Delphi 7 SP1... The same config as on the computer I use now, so I guess it must be dependant of some registry error or like (If you don't hear the same problem from somebody else).

Thanks anyway.