Hi,
I have a problem with executing a select statement with CRecordset using Oracle's ODBC driver.
My environment is MSVS2008, Oracle 10g DB, Ora ODBC and CRecordset. I have a computed field in the statement like xxx_pck.funct(p1, p2, pn). There are other fields as well like ID, CUSTOMER, etc. in various types. If the first field is a function like SELECT xxx_pck.funct(p1, p2, pn), ID, ... FROM tablename
, then CRecordset::Open crashes with invalid identifier.
If the function is somewhere else like SELECT ID, xxx_pck.funct(p1, p2, pn),... FROM tablename
everything's fine! Have someone already got this strange error message? Grants, synonyms are fine (since changing the order of columns is OK).Thank you for your reply!
-mfg-
adam