column qualifier or table undefined

[kjewell23]

I'm getting this error column qualifier or table undefined in asp.net

Dim connectionstring As String

connectionstring = "DRIVER=Client Access ODBC Driver (32-bit);UID=ODBC;PWD=GOCATS;System=143.42.191.135"

Dim Order As Integer
Order = CInt(txtOrderNumber.Text)
Dim myConnection As New Data.Odbc.OdbcConnection(connectionstring)
Dim mysql1 As String = "select rmsfiles2.obcop200.line#, rmsfiles2.mspmp100.ptyp1, rmsfiles2.mspmp100.ptyp2, rmsfiles2.obcop200.quano, rmsfiles2.obcop200.quana, rmsfiles2.obcop200.quans, rmsfiles2.obcop200.c2rdt, rmsfiles2.mspmp100.prdno, rmsfiles2.obcop200.unitm, rmsfiles2.mspmp100.descp, rmsfiles2.obcop200.actsp, rmsfiles2.obcop200.ordno from rmsfiles2.obcop200 inner join rmsfiles.mspmp100 on rmsfiles2.obcop200.prdno = rmsfiles2.mspmp100.prdno where ordno = " & Order.ToString()
Dim command As New Data.Odbc.OdbcCommand(mysql1)
command.Connection = myConnection
Dim adapter As OdbcDataAdapter = New OdbcDataAdapter(command)
myConnection.Open()

adapter.SelectCommand = New OdbcCommand("select rmsfiles2.obcop200.line#, rmsfiles2.mspmp100.ptyp1, rmsfiles2.mspmp100.ptyp2, rmsfiles2.obcop200.quano, rmsfiles2.obcop200.quana, rmsfiles2.obcop200.quans, rmsfiles2.obcop200.c2rdt, rmsfiles2.mspmp100.prdno, rmsfiles2.obcop200.unitm, rmsfiles2.mspmp100.descp, rmsfiles2.obcop200.actsp, rmsfiles2.obcop200.ordno from rmsfiles2.obcop200 inner join rmsfiles.mspmp100 on rmsfiles2.obcop200.prdno = rmsfiles2.mspmp100.prdno where ordno = " & Order.ToString(), myConnection)
'select rmsfiles2.obcop200.line#, cast(rmsfiles2.obcop200.quano as decimal(7,0))as ""Qty Ord"", rmsfiles2.obcop200.quana as ""Qty Aloc"", cast(rmsfiles2.obcop200.quans as decimal(7,0))as ""Qty Ship"", cast(rmsfiles2.obcop200.c2rdt as char(14))as ""Shipped Date"", rmsfiles2.obcop200.unitm as ""U/M"", cast(rmsfiles2.obcop200.actsp as decimal(7,2)) as ""Price"", rmsfiles2.obcop200.ordno as ""Factory Number"", rmsfiles2.obcop200.prdno from rmsfiles2.obcop200 where ordno = " & Order.ToString(), myConnection)


Dim ds As DataSet = New DataSet()
adapter.Fill(ds, "RMSFILES2.OBCOP200_and_RMSFILES2.MSPMP100")
' adapter.SelectCommand = New OdbcCommand("select rmsfiles2.mspmp100.ptyp1 as ""R/N"", rmsfiles2.mspmp100.ptyp2 as ""S/D"", rmsfiles2.mspmp100.descp as ""Description"", rmsfiles2.mspmp100.prdno from rmsfiles2.obcop200 inner join rmsfiles2.mspmp100 on rmsfiles2.obcop200.prdno = rmsfiles2.mspmp100.prdno where rmsfiles2.obcop200.ordno = " & Order.ToString(), myConnection)
' adapter.Fill(ds, "MSPMP100")

ds.Tables(0).TableName = "RMSFILES2.OBCOP200"
ds.Tables(1).TableName = "RMSFILES2.MSPMP100"
ds.Relations.Add("rmsfiles2.OBCOP200", ds.Tables("rmsfiles2.OBCOP200").Columns("prdno"), ds.Tables("rmsfiles2.MSPMP100").Columns("prdno"), True)


gridview1.DataSource = ds.Tables("RMSFILES2.OBCOP200")
' gridview1.DataSource = ds.Tables("MSPMP100")
gridview1.DataBind()
If ds.Tables(0).Rows.Count = 0 Then
lbl_error.Visible = True
gridview1.Visible = False
Else
lbl_error.Visible = False
gridview1.Visible = True
End If

If ds.Tables(1).Rows.Count = 0 Then
lbl_error.Visible = True
gridview1.Visible = False
Else
lbl_error.Visible = False
gridview1.Visible = True
End If

adapter.Dispose()
adapter = Nothing
myConnection.Close()

[Plater]

That sounds like there is a typo in your SQL query.
Use the debugger to step through so you can see the exact output value of your query.

It's probably something like not having ( or ) in the right place for those inner joins

[kjewell23]

That sounds like there is a typo in your SQL query.
Use the debugger to step through so you can see the exact output value of your query.

It's probably something like not having ( or ) in the right place for those inner joins

ok i did and it worked