It's done automatically by the program Define a field, define the null value and in case of dates, integers etc. its format
Then open print text setup You will see the possibility to create a file of fixed length, comma separated or using tabs. Choose fixed length Add every needed control to the right and define its length per object/field. Rbase will take care of the rest You don't have pay attention to fileds place on the screen. In essence the report writer is creating the old fashioned punch card. The only thing you have to be aware of is that the controls are only being identified by their object name, which easily can lead to some confusion if you have a lot of fields. The best solution is to put the fields in the right order on the report, then they are identified by object1, object2, ..... Tony From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: zondag 4 januari 2015 23:11 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Fixed field file Yeah I considered that but I know it's alot of trial and error to get everything to fit in the exact space it's supposed to be in. My line has 1500 of characters across so that would be way too much fooling around, and I'm not sure it would help anyway since I need those 675 blank spaces at the end. How would you place those blank spaces in a TXT report? Karen -----Original Message----- From: Tony IJntema <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Sun, Jan 4, 2015 2:36 pm Subject: [RBASE-L] - RE: Fixed field file Have you tried using the report writer using option TXT? Look at file | print file setup Just have made a very complicated electronic invoice inluding 5 subreports and a lot of spaces and integers, which need to be filled with 000, it works like a charm. Tony From: [email protected] [mailto:[email protected] <mailto:[email protected]?> ] On Behalf Of Karen Tellef Sent: zondag 4 januari 2015 21:15 To: RBASE-L Mailing List Subject: [RBASE-L] - Fixed field file I need to create a file with fixed field lengths. Rather than doing SFIL/SPUT I did a "select" statement and it works great and is easy to code, except... I need to have 675 blank spaces at the end of each line and I can't figure out how to do that using a "select" statement. Has anyone done that, or do I need to use SFIL/SPUT. According to my notes, if I use SFIL/SPUT I'll have to use a cursor and then do something like this (and thanks to whoever originally posted this code and I saved it): --Add CarriageReturn/LineFeed charaters to the line Set var vDataLine = (SPUT(.vDataLine,.vCRLF,.vPastEnd)) --Make sure no trash data exists beyond CR/LF Set var vDataLine = (SGET(.vDataLine,..vTotalLength,1)) --Write the line, telling RBASE not to add its own CRLF WRITE .vDataLine CONTINUE Karen
