Devart Forums

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

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).

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.