New Era/ODBC/Oracle
Posted in 1999
I am trying to port a New Era 3.11 application to run against an Oracle database. >From my limited knowledge of Oracle I understand it does not have date data types but only datetime data types. I am performing a simple query to retrieve records from the Oracle database using an Merant ODBC driver. I can retrieve records from the particular table, and can read and display numerical fields and character fields, however, I cannot retrieve any dates even though there is data in the field. This is the first time I have used ODBC and am not sure what to expect. If I getInfo on the column type it reports it to be an SQL_datetime any ideas what I am doing wrong? If anyone else had written a New Era application to run against Oracle I would be pleased to here of your experiences. Regards Shaun Campbell