Select always empty

erikfandersen · Post by **erikfandersen** » Thu 28 Sep 2006 09:25

Hello!

From the Delphi IDE I first open a TOraSession to my Oracle 10g database and then I activate a TOraQuery component with a "select * from xxx" statement in the SQL property. The query component is attached to a TDataSource and the result is displayed in a TDBGrid.

My problem is that the grid is always empty when the query is activated in the designer. I don't understand this because if I use SQL*Plus Worksheet there are 3 rows. The column names are displayed correctly in the grid however so something is going on.

I attach to the database with the same username/password/server in both cases.

I have tried the same approach as above on another Oracle 10g database and here there are no problems. Records are displayed in the grid.

What am I doing wrong? I have not configured any of the Oracle serveres myself and I really don't know anything about the server side of things.

Regards,
Erik

Challenger · Post by **Challenger** » Thu 28 Sep 2006 12:07

Please specify the version of Delphi and ODAC you use. Send us script to create table you are openning.
And try our Query demo on your server.

erikfandersen · Post by **erikfandersen** » Fri 29 Sep 2006 14:02

Hmmm, I don't know what went wrong but today it works perfectly. Maby Oracle needs to sleep on it

Anyway, sorry for the intrusion.

/Erik