Advertisement
Guest User

Untitled

a guest
Jan 11th, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
ASP 0.53 KB | None | 0 0
  1. private function valFromConf(dr_numdoc,dr_tipdoc,dr_anndoc,dr_riga,cod_cnf)
  2.     sql = "SELECT cnfv_val FROM cnf_valconf WHERE "
  3.     sql = sql & " cnfv_numdoc       = " & sy_cvn(dr_numdoc)
  4.     sql = sql & " AND cnfv_tipdoc   = " & sy_cvs(dr_tipdoc)
  5.     sql = sql & " AND cnfv_anndoc   = " & sy_cvn(dr_anndoc)
  6.     sql = sql & " AND cnfv_dcriga   = " & sy_cvn(dr_riga)
  7.     sql = sql & " AND cnfv_cnfprg   = " & sy_cvn(cod_cnf)
  8.     set rsc = conn.execute(sql)
  9.     if not rsc.eof then
  10.         valFromConf = rsc("cnfv_val")
  11.     else
  12.         valFromConf = ""
  13.     end if
  14. end function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement