got strange error by using

The_Rebel · Post by **The_Rebel** » Tue 11 Jan 2005 14:08

hi!

ODAC: 5.10.4.13
Borland C++ Builder: 6 (Build: 10.161)

i sended the following statement (after setting parameter to a valid value) to a oracle 9.2.0.4.0 server in use of TSmartQuery Component:

SELECT p.*, a.*, lp.* FROM userscheme.table1 p JOIN
userscheme.table2 a ON a.Nr = p.Nr JOIN
userscheme.table3 lp ON p.SNr = lp.sNr AND lp.PK = :PrimaryKOfTable3
ORDER BY p.Nr, p.SNR

my programm hangs after the query->open() command.
If I run an senseless query like "SELECT NULL FROM dual" before that the query works fine... STRANGE!

Ps.:CRDBGrid is not able to sort fields that are computet in a Sqlstatement (to solve i had to change there names with "AS newName")

Alex · Post by **Alex** » Wed 12 Jan 2005 15:10

Sorry but we can't reproduce your problem, please send us a small demo project to demonstrate the problem and include script to create server objects to ODAC support address.

As to TCRDBGrid Ps. - we fixed this problem. This fix will be included in the next ODAC build.