I have a problem with attempting to retrieve a long data type under VBA. A runtime error is returned "OIP=04131: Field processing required ROWID". I have tried to rewrite the query using ROWID but have so far been unsuccessful. Code is below.
Any help would be appreciated,
Simon.
Top2_SQL = "SELECT " +
"RAS_TEXT.Text " +
"FROM " +
"RAS_TEXT, " +
"BO_RAS_MODEL_COMPANY, " +
"RAS_COMPANY_TEXT " +
"WHERE " +
"( RAS_TEXT.TEXT_ID=RAS_COMPANY_TEXT.TEXT_ID ) " +
"AND ( BO_RAS_MODEL_COMPANY.COMPANY_ID=RAS_COMPANY_TEXT.COMPANY_ID ) " +
"AND ( BO_RAS_MODEL_COMPANY.ASX_CODE IN ('ALN') " +
"AND RAS_COMPANY_TEXT.COMPANY_TEXT_LOOKUP_CODE IN ('TOP20') )"
Set Top2Data_osRecordSet = OraDatabase.DbCreateDynaset(Top2_SQL, CInt(0))
If Top2Data_osRecordSet.RecordCount >= 1 Then
top2 = (Top2Data_osRecordSet.Fields(0))
Else
