Skip to Content
0
Former Member
Nov 22, 2012 at 08:14 AM

Invalid Query Tree

39 Views

Hi

After adding this line

and b.u_Unique_ID = " & oForm.Items.Item("33").Specific.ToString.Trim) , i am getting this error . b.u_Unique_ID is numeric Data Type.

oDT.ExecuteQuery("SELECT a.Code, a.Name , b.U_Amount as Amount FROM [@TEMP]a left JOIN [@TEMP1]b ON a.Code = b.U_Al_Code and b.u_Unique_ID = " & oForm.Items.Item("33").Specific.ToString.Trim)

Thanks