Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Submitting comma delimited data
Message
From
11/05/2011 16:23:42
 
 
To
11/05/2011 16:19:04
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01510319
Message ID:
01510390
Views:
45
>I'll just post the whole function, I didn't include some parts because I didn't think they played a part in what I was trying to do, but obviously I don't know what I'm doing so maybe this was the problem all along.
>
>
FUNCTION ApprovalPrintout
>	SET STEP ON 
>	m.bnin = ""
>	m.bn = ""
>	m.ty = ""
>	*Set variables to input from HTML page
>	m.bnin = ALLTRIM(TRANSFORM(Request.Form("bn")))
>	m.ty = ALLTRIM(Request.Form("btntype"))
>	m.msg = ""
>	
>
>		IF EMPTY(m.bnin)
>			IF EMPTY(m.ty)
>			m.msg="You Need To Enter A Batch Number"
>		ELSE
>			m.msg="Shouldnt Get this"		
>		ENDIF
>		
>		
>	ELSE
>
>		
>			NumberRecords = GETWORDCOUNT(m.bnin)
>				FOR i = 1 TO NumberRecords
>					m.bn = PADL(GetWordNum(m.bnin, i, ","),7,"0")				
>   			
>			*Opens the DBF file in the "key" folder, appends "A" and adds the user input as batch number
>			OpenTable(goWCServer.oConfig.oTask.cBTSPath+[key\A]+m.bn,[AppExp])
>			
>			*Select columns from table above, name them for Excel headers
>			SELECT 	bn as [BatchNum],;
>					pk as [RecNo],;
>					"" as [Approved],;
>					shdt as [ShipDate],;
>					canm as [Carrier],;
>					prno as [Pro],;
>					blno as [BOL],;
>					shnm as [Shipper],;
>					ozp as [OZip],;
>					conm as [Consignee],;
>					dzp as [DZip],;
>					wtttl as [Weight],;
>					"" as [ReWeigh],;
>					"" as [Notes],;
>					accd1 as [Acc1],;
>					acamt1 as [Amt1],;
>					accd2 as [Acc2],;
>					acamt2 as [Amt2],;
>					accd3 as [Acc3],;
>					acamt3 as [Amt3];
>			FROM AppExp; 
>			into cursor ApprovalA
>			
>			SELECT ApprovalA
>
>*Copy data from cursor to Excel file
>COPY TO ("C:\test\"+[bn]+m.bn+[T2.xls]) 
>
>m.msg=[File Exported to C:\test\bn]+m.bn+[T2.xls] + TRANSFORM(NumberRecords)
>ENDFOR
>			CloseTable("AppExp")
>
>
>
>	ENDIF
>	
>	Response.ExpandTemplate(goWCServer.oConfig.oTask.cBTSHTMPath+"ApprovalPrintout.htm")				
>		
>	
>ENDFUNC
>
>I stuck the cursor back in temporarily while I was testing some things, and I tried putting the ENDFOR right after the COPYTO, after the CLOSETABLE, and where it currently is in the code above.

Well, I'm stumped. The CloseTable() is after the ENDFOR so it should not get hit until after the second time through the loop. Can you put a wait window or messagebox in the for loop after you've assigned the value to m.bn displaying what m.bn is and see if that displays twice? If not, then I'm afraid there must be something that WestWind does to cause the loop to exit that I am unable to think of.
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform