Skip to Content
0
Former Member
Nov 16, 2012 at 07:44 AM

Invalid Query Tree [300-33]

634 Views

Hi

It is giving me error "Invalid Query Tree [300-33] after i added this line LEFT JOIN OHEM c ON b.U_Unique_ID = m_id

If ((BusinessObjectInfo.FormTypeEx = "60100" And BusinessObjectInfo.EventType = SAPbouiCOM.BoEventTypes.et_FORM_DATA_LOAD) And (BusinessObjectInfo.BeforeAction = False)) Then

Dim oForm As SAPbouiCOM.Form = Me.SBO_Application.Forms.Item(BusinessObjectInfo.FormUID)

Dim oGrid As SAPbouiCOM.Grid = oForm.Items.Item("MyGrid").Specific

Dim oDT As SAPbouiCOM.DataTable = oGrid.DataTable

m_id = oForm.Items.Item("33").Specific.value.ToString()

oForm.DataSources.DataTables.Item(0).ExecuteQuery("SELECT a.Code, a.Name , b.U_Amount,b.U_Unique_ID as Amount FROM [@TEMP]a left JOIN [@Temp1]b ON a.Code = b.U_Al_Code where b.U_Unique_ID = m_id")

endif

Thanks