Re: SQL Query Invalid operation

From: Jonathan (anonymous_at_discussions.microsoft.com)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 12:21:07 -0800

The tables are linked tables from an oracle database and there were no other error messages or number. Just the invalid operation error message.

Here is the code I was using, the qry_BB_LOC_1 is where I get the error message

CurrentDb.QueryDefs("qry_AP_RESOURCE_SCENARIO").SQL = _
    " SELECT DISTINCT A.* FROM " & userID & "_AIRPORT_RESOURCE AS A INNER JOIN " & userID & "_SCENARIO_RULE AS B" & _
    " ON B.RULE_ID = A.RULE_ID WHERE B.SCENARIO_ID = '" & cmbBlScn & "';"
    
    CurrentDb.QueryDefs("qry_BAGGAGE_BELT").SQL = _
    "SELECT DISTINCT BB.AIRPORT_RESOURCE_KEY, AIRPORT_RESOURCE_NAME, AIRPORT_RESOURCE_CODE, GRAPHICS_SEQ_NO, SECTOR_CODE_STRING, " & _
    " CAPACITY, CLAIM, AIRPORT_CODE, DESCRIPTION, AR.IS_INACTIVE, AR.RULE_ID FROM " & _
    userID & "_BAGGAGE_BELT AS BB, qry_AP_RESOURCE_SCENARIO AS AR WHERE " & _
    " AR.AIRPORT_RESOURCE_KEY = BB.AIRPORT_RESOURCE_KEY;"
    
    CurrentDb.QueryDefs("qry_BELT_IN_AREA_VIEW").SQL = _
    " SELECT DISTINCT B.* FROM " & userID & "_BELTS_IN_AREA_RULE_VIEW AS B INNER JOIN " & userID & "_SCENARIO_RULE AS C" & _
    " ON C.RULE_ID = B.RULE_ID WHERE C.SCENARIO_ID = '" & cmbBlScn & "';"
         
    CurrentDb.QueryDefs("qry_BAREA_RULE_VIEW").SQL = _
    " SELECT DISTINCT D.CONSIST AS ACONSIST, D.INCLUDES AS AINCLUDES FROM " & userID & "_BAREA_RULE_VIEW AS D INNER JOIN " & userID & "_SCENARIO_RULE AS E" & _
    " ON E.RULE_ID = D.RULE_ID WHERE E.SCENARIO_ID = '" & cmbBlScn & "';"
    
    CurrentDb.QueryDefs("qry_BB_LOC_1").SQL = _
    " SELECT DISTINCT qry_BAREA_RULE_VIEW.ACONSIST AS TERMINAL, qry_BELT_IN_AREA_VIEW.INCLUDES FROM qry_BAREA_RULE_VIEW " & _
    "qry_BELT_IN_AREA_VIEW WHERE qry_BAREA_RULE_VIEW.AINCLUDES = qry_BELT_IN_AREA_VIEW.CONSIST;"