Select always empty
Posted: 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
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
