Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- nsql = ''
- 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,'Н') = 'Н'"
- data = csql(nsql1;;',';)
- foreach str in data
- //nsql = nsql& "insert into dbo.BankDetails(DirectumID, OrgID, Bank, BIK, KS, RS, currency, Action, ModTime) values("&str&","&Action&",'"&time&"')"
- nsql = nsql& "insert into dbo.BankDetails(DirectumID, OrgID, Bank, BIK, KS, RS, currency, Action, ModTime) values("&str&",'"&time&"')"
- endforeach
- sql(nsql;;;;IConnection)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement