What a dope!!! Here I tried "0" which went out 1 space, and I tried "3" which made it go out 3 spaces just to test it. Didn't think of trying "1", which made it 0 places. I guess now that I write that down, it sorta doesn't make sense, does it?
Thanks Mike! Karen -----Original Message----- From: mike.ramsour <[email protected]> To: karentellef <[email protected]> Sent: Wed, Sep 30, 2015 9:11 am Subject: [RBASE-L] - Re: Version 9.5 and "selmargin" Karen: Try setting it to "1". Iuse this technique to unload data to a text file. I think it willaccomplish your goal. Sample code: SET NULL ' ' SET HEADINGS OFF SET WIDTH 2000 SET SELMARGIN 1 I use variables earlier in my programto capture the current settings so that I can set them back when the programcompletes its run. Hope that helps. Regards. Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 From: Karen Tellef <[email protected]> To: [email protected], Date: 09/30/2015 10:04 AM Subject: [RBASE-L] -Version 9.5 and "selmargin" Sent by: [email protected] Converting some DOS code that exported inventoryto QuickBooks file. It creates a text file with a header row createdwith a "write" statement followed by a complicated "select"statement. Here's what it looks like (shortened and edited): !INVITEM,ACCNT,INVITEMTYPE,ASSETACCNT,COGSACCNT,TAXABLE,NAME,DESC,COST,PURCHASEDESC,PRICE INVITEM,Sales,INVENTORY,Inventory,Cost of Goods Sold,Y,85079-3504,MinkCoat,100,Mink Coat,200 INVITEM,Sales,INVENTORY,Inventory,Cost of Goods Sold,Y,85080-RSM78,RabbitCoat,100,Rabbit Coat,150 In DOS we used the microrim_selmargin 0 to get the select to go to theleft margin. In 9.5 I tried the "set selmargin 0" but itstarts with one blank at the left, which is what I think the help fileis confirming. Am I missing something, or do I have to change this to an "unloadas ascii" command? (I'm not doing that right away because itwill require creating a temp table as alot of stuff is done within the"select" that wouldn't be allowed in an unload) Thanks!! Karen Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
