E
eddie wang
The following caculcation will result type mismatch:
boe_net=oil_net+oil_gross .
Here is the value:
oil_net: 69997
oil_grss: 84651
Here is the code:
strSQl = "SELECT nvl(ROUND(SUM(A.NET_STD_PB_VOL)),0) OIL_NET,
ROUND(SUM(A.GROSS_STD_PB_VOL)) OIL_GROSS,
NVL(ROUND((SUM(A.NET_STD_PB_VOL) / SUM(A.GROSS_STD_PB_VOL)) * 100, 2),0)
EST_AGGR_OIL_INTEREST "&_
"FROM OGDWMART.PO_CMPL_MTH_ALLOC_VOL_F A"
Set rs = conn(strSQl)
if not rs.EOF then
oil_int = rs("EST_AGGR_OIL_INTEREST")
oil_net = rs("OIL_NET")
oil_gross = rs("OIL_GROSS")
boe_net=oil_net+oil_gross
end if
boe_net=oil_net+oil_gross .
Here is the value:
oil_net: 69997
oil_grss: 84651
Here is the code:
strSQl = "SELECT nvl(ROUND(SUM(A.NET_STD_PB_VOL)),0) OIL_NET,
ROUND(SUM(A.GROSS_STD_PB_VOL)) OIL_GROSS,
NVL(ROUND((SUM(A.NET_STD_PB_VOL) / SUM(A.GROSS_STD_PB_VOL)) * 100, 2),0)
EST_AGGR_OIL_INTEREST "&_
"FROM OGDWMART.PO_CMPL_MTH_ALLOC_VOL_F A"
Set rs = conn(strSQl)
if not rs.EOF then
oil_int = rs("EST_AGGR_OIL_INTEREST")
oil_net = rs("OIL_NET")
oil_gross = rs("OIL_GROSS")
boe_net=oil_net+oil_gross
end if