Advertisement
Guest User

Untitled

a guest
Jun 22nd, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  nsql = ''
  2.           nsql1 =  "select mba.XRecId, mba.Analit, '''' + mba.DopT + '''', mba.LSS_BIK, mba.LSS_KST, mba.LSS_RST, '''' + ltrim(rtrim(analit.Kod)) + '''', isnull(mba.PointT,1) from MBAnValR mba left join dbo.MBAnalitSpr analit on mba.LSS_Currency = analit.Analit where mba.Analit = "&ID&" and isnull(mba.DaNet3T,'Н') = 'Н'"
  3.          data = csql(nsql1;;',';)
  4.           foreach str in data
  5.               //nsql = nsql& "insert into dbo.BankDetails(DirectumID, OrgID, Bank, BIK, KS, RS, currency, Action, ModTime) values("&str&","&Action&",'"&time&"')"
  6.              nsql = nsql& "insert into dbo.BankDetails(DirectumID, OrgID, Bank, BIK, KS, RS, currency, Action, ModTime) values("&str&",'"&time&"')"  
  7.          endforeach
  8.  
  9.          sql(nsql;;;;IConnection)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement