Sorry, I'm using Turbo V-8, and the latest version, build 8.0.19.31229 Paul
From: Paul Patrick - Enrollment Management Sent: Tuesday, January 06, 2009 11:16 AM To: '[email protected]' Subject: 0 filling fixed length numeric field for fixed length text output file Good morning, all. I'm creating a student enrollment file to send to the National Clearinghouse, and trying to 0-fill an output field and concatenate it to other 0-filled fields. I'm using the code below SET VAR lastline = ('T1' + (format(.fknt,'000000')) + (format(.hknt,'000000')) + (format(.lknt,'000000')) + (format(.wknt,'000000')) + (format(.gknt,'000000')) + (format(.aknt,'000000')) + (format(.xknt,'000000')) + (format(.dknt,'000000')) + (format(.totknt,'00000000')) + (RJS(.filler,642))) WRITE .lastline And the results look like this. An extra space is being added between fields. T1 008844 004080 001823 000441 000000 000000 000002 00015192 Any ideas how to get rid of the space or a better way to accomplish this? I've used LJS and RJS on the fields which get rid of the extra spaces, but haven't figured out how to 0-fill using those methods. Any help would be appreciated. Paul Paul Patrick, Associate Registrar University of Central Oklaoma [email protected] (405) 974-2336 From: [email protected] [mailto:[email protected]] On Behalf Of Tom Frederick Sent: Monday, January 05, 2009 12:47 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Relational Verification Today, I had two LAN based tables pop up the error message 'Cannot read table structure' while running Relational Verification before using Design. Other LAN tables had no problems with RV or Design. A clone development database on another drive works just fine. Using 12/29 V8 and did the usual checks including reload. RV has been ON for several months for no particular reason. When RV is turned off, the tables popped up immediately and operate / save like always. My understanding is RV ON checks table structures before changes and RV OFF checks table structures after saving any changes. Is there a reason to leave RV ON if OFF seems to work just fine? If these messages are a sign of something developing, what is a likely solution? I am putting an Audit system into the Forms for these tables, but have not changed the tables themselves in a long time. Tom Frederick Elm City Center 1314 W Walnut Jacksonville, IL 62650 Off - 217-245-9504 Fax - 217-245-2350 Email - [email protected]<mailto:[email protected]> Web - www.elmcity.org<http://www.elmcity.org> **ADDRESS CHANGE NOTICE**-The University of Central Oklahoma is moving to a new Internet address. All e-mail addresses and Web sites are now available at uco.edu. All e-mail addresses and Web sites will use uco.edu effective January 2, 2009. **CONFIDENTIALITY** -This e-mail (including any attachments) may contain confidential, proprietary and privileged information. Any unauthorized disclosure or use of this information is prohibited.
