Compare retrieved records
HI, i have a problem, i have 2 tables
tbl_IssueToTempB (input from user)
ToNo PartNo Qty VerifyBy
123 987 500 1
123 987 500 1
123 345 800 1
123 345 800 1
tbl_IssueTo (table to be compare)
TONo PartNo Qty
123 987 1000
123 678 1000
123 345 2000
i tried the code below but i cant get the PartNo tat dint match! during user fire an event, i check a ToNo for every different partNo. If one of the record dont match, i need to show user which partNo is not match, if every partNo in tat ToNo is match, i'll let them to proceed. can any1 guide me through tis? i stuck on tis problem for 4 days alrd!!!
StrSql="select Tbl_IssueTo.partNo,Tbl_IssueToTempB.qty from Tbl_IssueTo Left Outer join " & _
"(select partno,sum(qty) qty from Tbl_IssueToTempB where verifyBy=@verify And ToNo=@toNo group by partNo) " & _
"Tbl_IssueToTempB on " & _
"Tbl_IssueTo.partNo = Tbl_IssueToTempB.partNo where " & _
"Tbl_IssueTo.qty = Tbl_IssueToTempB.qty"
ObjCmd=New SqlCommand(StrSql, ObjConn)
With ObjCmd.Parameters:
.Add(New SqlParameter("@verify", Session("User_ID")))
.Add(New SqlParameter("@ToNo", tbToNo.Text))
End With
ObjCmd.Connection.Open()
ObjReader=ObjCmd.ExecuteReader()
while objReader.Read=true
Response.Write(ObjReader.item("Qty"))
Response.Write(ObjReader.item("PartNo") & "<br />")
end while
ObjClose()
|
