Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sql = "INSERT INTO dc_tagliecolori (dctc_id, dctc_tpdoc, dctc_numdoc, dctc_anndoc, dctc_colore"
- sql = "SELECT COUNT(tgart_codtaglio) FROM PUBLIC.mg_tagliart WHERE art = cod"
- set rsc = conn.execute(sql)
- cont = 1
- if not rsc.eof then
- sql = sql & ","
- do while cont <= rsc(0)
- sql = sql & " dctc_taglia" & cont
- cont = cont + 1
- rsc.movenext
- loop
- sql = Left(sql,Len(sql)-1)
- end if
- sql = sql + " VALUES ("&sy_cvn(dctc_id)&","&sy_cvs(tipo)&","&sy_cvn(prg)&","&sy_cvn(anno)&","&sy_cvs(rs("tgcart_codart"))
- sql = "SELECT tgart_codtaglio FROM PUBLIC.mg_tagliart WHERE art = cod"
- set rsc = conn.execute(sql)
- if not rsc.eof then
- sql = sql & ","
- do until rsc.eof
- sql = sql & rs("tgart_codtaglio") & ","
- loop
- loop
- sql = Left(sql,Len(sql)-1)
- conn.execute(sql)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement