View Single Post
  #5  
Old 22nd June 2017, 10:44
VishalMistry's Avatar
VishalMistry VishalMistry is offline
Guru
 
Join Date: Dec 2004
Location: India, Gujarat
Posts: 573
VishalMistry has a little shameless behaviour in the past
Baan: Baan IV, ERPLn - DB: SQL Server 2000 / 2008 - OS: Windows Server 2003 / 2008
Red face Success in generating supplier-wise report

Hi Mark,

I was able to successfully generate a separate file for every vendor.

The mistake I was making is I had kept the stpapi.end.session() inside the loop. I kept the spool.close() inside the loop and moved out stpapi.end.session() and it worked.

I have attached sample script if anybody encounters the similar issue.

Vishal
Attached Files
File Type: cln script.cln (1.5 KB, 4 views)
Reply With Quote