I wanted to upgrade from 5.80 to 6.10 but now I get an error message when posting a record in a TSmartQuery I did not have before the upgrade (I did not change any source line...)
I have a TSmartQuery looking for data on a table and a view like this:
SELECT FAX.PAGES.ROWID,
FAX.PAGES.*,
FAX.PAGE_VERSION(FAX.PAGES.PAGE_ID) AS PAGE_VERSION,
FAX.V_PATIENTS.STUDY_LONG_DESCRIPTION,
FAX.V_PATIENTS.STUDY_SHORT_DESCRIPTION,
FAX.V_PATIENTS.CENTRE_SPONSOR_NAME,
FAX.V_PATIENTS.PATIENT_DESCRIPTION
FROM FAX.PAGES
LEFT JOIN FAX.V_PATIENTS ON FAX.V_PATIENTS.PATIENT_ID=FAX.PAGES.PATIENT_ID
ORDER BY FAX_IN_ID, FAX_PAGE
The updating table property is properly set on FAX.PAGES, but when posting, ODAC returns an error:
ORA-00904: "LEFT"."PATIENT_DESCRIPTION": Invalid identifier
I am using BDS2006 Architect, WXP SP2, ODAC 6.10
My bet is that ODAC 6.10 thinks my "LEFT JOIN" is a table name
Thanks