TableName not correctly parsed

Yan
2008-07-17
2013-05-02
  • Yan
    Yan
    2008-07-17

    Hi everyone,

    I'm would like to create a virtual column on the C_InvoiceLine which give me some information about the charge which could be selected on the line.

    So I've made my SQL, which gives good results.

    When opening my window, i got the information in the field, but there are some errors on the log window...
    I don't think it is critical but i would like to understand why these errors appears and if possible to resolve them.

    So :

    My SQL is :
    (select C_ValidCombination.combination  FROM C_Charge_Acct, C_ValidCombination   WHERE C_Charge_Acct.ch_expense_acct=C_ValidCombination.c_validcombination_id  AND C_Charge_Acct.c_acctschema_id =1000003  AND C_Charge_Acct.c_charge_id=C_InvoiceLine.C_Charge_ID)

    When going on the Line tab, the log says :

    -----------> AccessSqlParser.getTableInfo: More than one FROM clause - SELECT AD_Client_ID,AD_Org_ID,C_Invoice
    _ID,C_OrderLine_ID,Line,M_InOutLine_ID,M_Product_ID,C_Charge_ID,Description,QtyEntered,C_UOM_ID,QtyInvoiced,Pr
    iceEntered,PriceActual,PriceList,C_Tax_ID,TaxAmt,C_Activity_ID,AD_OrgTrx_ID,User1_ID,User2_ID,LineNetAmt,LineT
    otalAmt,IsDescription,IsPrinted,(select C_ValidCombination.combination  FROM C_Charge_Acct, C_ValidCombination
       WHERE C_Charge_Acct.ch_expense_acct=C_ValidCombination.c_validcombination_id  AND C_Charge_Acct.c_acctschem
    a_id =1000003  AND C_Charge_Acct.c_charge_id=C_InvoiceLine.C_Charge_ID) AS YS_Charge_Info, C_Campaig
    n_ID,C_ProjectPhase_ID,RRAmt,C_ProjectTask_ID,RRStartDate,Processed,C_Project_ID,Ref_InvoiceLine_ID,PriceLimit
    ,M_AttributeSetInstance_ID,C_InvoiceLine_ID,IsActive,S_ResourceAssignment_ID,A_Asset_ID,Created,CreatedBy,Upda
    ted,UpdatedBy FROM C_InvoiceLine WHERE C_Invoice_ID=1000251 [11]

    ===========> MRole.addAccessSQL: TableName not correctly parsed - TableNameIn=C_InvoiceLine - AccessSqlParser[
    C_Charge_Acct,C_ValidCombination=WHERE,C_Campaign_ID,C_ProjectPhase_ID,RRAmt,C_ProjectTask_ID,RRStartDate,Proc
    essed,C_Project_ID,Ref_InvoiceLine_ID,PriceLimit,M_AttributeSetInstance_ID,C_InvoiceLine_ID,IsActive,S_Resourc
    eAssignment_ID,A_Asset_ID,Created,CreatedBy,Updated,UpdatedBy=FROM|0] - #1 C_Charge_Acct
    = SELECT AD_Client_ID,AD_Org_ID,C_Invoice_ID,C_OrderLine_ID,Line,M_InOutLine_ID,M_Product_ID,C_Charge_ID,Desc
    ription,QtyEntered,C_UOM_ID,QtyInvoiced,PriceEntered,PriceActual,PriceList,C_Tax_ID,TaxAmt,C_Activity_ID,AD_Or
    gTrx_ID,User1_ID,User2_ID,LineNetAmt,LineTotalAmt,IsDescription,IsPrinted,(select C_ValidCombination.combinati
    on  FROM C_Charge_Acct, C_ValidCombination   WHERE C_Charge_Acct.ch_expense_acct=C_ValidCombination.c_validcom
    bination_id  AND C_Charge_Acct.c_acctschema_id =1000003  AND C_Charge_Acct.c_charge_id=C_InvoiceLine.C_Charge_
    ID) AS YS_Charge_Info,C_Campaign_ID,C_ProjectPhase_ID,RRAmt,C_ProjectTask_ID,RRStartDate,Processed,
    C_Project_ID,Ref_InvoiceLine_ID,PriceLimit,M_AttributeSetInstance_ID,C_InvoiceLine_ID,IsActive,S_ResourceAssig
    nment_ID,A_Asset_ID,Created,CreatedBy,Updated,UpdatedBy FROM C_InvoiceLine WHERE C_Invoice_ID=1000251 [11]

    I'm working on a 261 version.

    Thanks for any help or tips

    Yan

     
    • Hamza khanfouf
      Hamza khanfouf
      2008-07-19

      put this in column sql :
      (SELECT C_ValidCombination.Combination FROM C_Charge_Acct INNER JOIN C_ValidCombination
      ON (C_Charge_Acct.Ch_expense_acct=C_ValidCombination.C_Validcombination_ID )
      WHERE C_Charge_Acct.c_acctschema_id =1000003 AND  C_Charge_Acct.C_Charge_ID=C_InvoiceLine.C_Charge_ID)
      Thanks
      Hamza

       
      • Yan
        Yan
        2008-07-20

        Thanks a lot Hamza, it's working !

        Regards,

        Yan