Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Submitting comma delimited data
Message
De
11/05/2011 10:48:07
 
 
À
11/05/2011 10:33:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01510319
Message ID:
01510323
Vues:
49
Thanks, I'm still extremely new to VFP though so I'm a bit confused. I tried putting the loop before the OpenTable function and ending it after it put the results into the cursor, but I'm still only getting one record exported. Can you give me a little more detail on where exactly it should go?

>You will need a loop, something like
>For x=1 to getwordcount(bn,',')
>   tempbn=getwordnum(bn,x,',')
>   **your code here
>Endfor
>
>>Quick overview, I have a page that lets a user type in a record number and get the record info exported into an Excel spreadsheet. Right now it only works with one number at a time, but I want to allow them to type multiple record numbers separated with commas.
>>
>>The relevant code is below:
>>
>>
	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])
>>
>>The "OpenTable" bit at the beginning is where it grabs the record number from the textbox on the HTML page (m.bn). Would I need a loop or something in order to get multiple record numbers recognized?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform