| Line 979... |
Line 979... |
| 979 |
" WHERE br.PROJ_ID = pr.PROJ_ID"&_
|
979 |
" WHERE br.PROJ_ID = pr.PROJ_ID"&_
|
| 980 |
" AND b.BRANCH_ID = br.BRANCH_ID"&_
|
980 |
" AND b.BRANCH_ID = br.BRANCH_ID"&_
|
| 981 |
" AND b.BOM_ID ="&parSBOMB, cint(0))
|
981 |
" AND b.BOM_ID ="&parSBOMB, cint(0))
|
| 982 |
|
982 |
|
| 983 |
NewTextFile.WriteLine("<title>Difference Report Between "&rsQryA("branch_name")&" "&rsQryA("location")&" and "&rsQryB("branch_name")&" "&rsQryB("location")&"</title>")
|
983 |
NewTextFile.WriteLine("<title>Difference Report Between "&rsQryA("branch_name")&" "&rsQryA("location")&" and "&rsQryB("branch_name")&" "&rsQryB("location")&"</title>")
|
| 984 |
NewTextFile.WriteLine("<link rel="shortcut icon" href="<%=FavIcon%>"/>
|
- |
|
| 985 |
NewTextFile.WriteLine("<div align="&chr(34)&"center"&chr(34)&"><font color="&chr(34)&"red"&chr(34)&" size="&chr(34)&"4"&chr(34)&" face="&chr(34)&"Verdana, Arial, Helvetica, sans-serif"&chr(34)&">Difference Report Between "&rsQryA("branch_name")&" "&rsQryA("location")&" and "&rsQryB("branch_name")&" "&rsQryB("location")&"</font></div><br>")
|
984 |
NewTextFile.WriteLine("<div align="&chr(34)&"center"&chr(34)&"><font color="&chr(34)&"red"&chr(34)&" size="&chr(34)&"4"&chr(34)&" face="&chr(34)&"Verdana, Arial, Helvetica, sans-serif"&chr(34)&">Difference Report Between "&rsQryA("branch_name")&" "&rsQryA("location")&" and "&rsQryB("branch_name")&" "&rsQryB("location")&"</font></div><br>")
|
| 986 |
|
985 |
|
| 987 |
While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))
|
986 |
While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))
|
| 988 |
errormsg = false
|
987 |
errormsg = false
|
| 989 |
rowId = rsQry("node_id_a") &"_"& rsQry("os_id_a") &"_"& rsQry("pv_id_a") &"_"& rsQry("pv_id_b")
|
988 |
rowId = rsQry("node_id_a") &"_"& rsQry("os_id_a") &"_"& rsQry("pv_id_a") &"_"& rsQry("pv_id_b")
|