HDTenEightyP/NetNews huggingface dataset:
X-Envelope-to: DBASE-L@NMSUVM1.BITNET
X-VMS-To: IN%"DBASE-L@NMSUVM1.BITNET"
X-VMS-Cc: DSMITH
MIME-version: 1.0
Content-type: TEXT/PLAIN; CHARSET=US-ASCII
Content-transfer-encoding: 7BIT
Newsgroups: bit.listserv.dbase-l
Date:         Mon, 14 Sep 1992 08:21:36 -0500
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         DON SMITH <DSMITH@INDYVAX.BITNET>
Subject:      Re: Multiple Level Interrupt

> I gave the user a chance to correct his/her mistake by hitting the
> UPARROW key.  However, my concern is that the user may hit the UPARROW key
> again, and this will generate another level of interrupt.

I don't know PRECISELY what you're after, but it MIGHT be something like this:

ON KEY uparrow DO uparrow
.
.
PROCEDURE uparrow
called_by = PROGRAM()
IF called_by = "uparrow"
   RETURN
ENDIF
.
.
Body of procedure here
.
.
RETURN

So if PROCEDURE uparrow is called from your main program, OK, but if the user
is already within uparrow when they call it, it should return immediately.

Don Smith
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Mon, 14 Sep 1992 18:54:48 MDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         David L West <dlwest@SOMNET.SANDIA.GOV>
Subject:      unsubscribe

UNSUBSCRIBE David L. West
From: grads064@SNOWHITE.CIS.UOGUELPH.CA ((Mak Rusli))
Newsgroups: bit.listserv.dbase-l
Subject: Re: dBase start
Date: 15 Sep 92 23:30:07 GMT
              dialects" <DBASE-L@NMSUVM1.BITNET>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Mailer: ELM [version 2.3 PL11]
              Sep 15, 92 12:32 pm

>
> Does anyone know how to start up dbase without seeing the license agreement
> showing up on the screen?

  Try using this:

  DBASE/T
>
> I have version 1.1 and I hate to see it each time I load dBase.

  You will see a short introductory screen without having to press any key
  to go to the control center (ussually, unless you set it differently).

MAK RUSLI
Dept. of Computing & Info. Sc.
University of Guelph
Guelph, ONT, N1G 2W1
Canada
Newsgroups: bit.listserv.dbase-l
Subject: RE: Help (Communications needs
From: browland@vax1.umkc.edu
Date: Mon, 7 Sep 1992 13:50:05 GMT
Organization: University of Missouri - Kansas City

>From: ACSMSS@SAUPM00.BITNET (Siddiq, Mohammed), King Fahd University of Petroleu
>
>Date: 6 Sep 92 01:47:46 CST
>
>Hi,
>   I am developing a package for a client and a came across this problem that m
>y client has a office away from his shop and he wants me to give him an option
>within the application which will use a modem to dial and upload the transactio
>n file upon selection of that option.
>
>  I will be very much thankful for all suggestion.


I have used COMET, a communications library for Dbase, Clipper, Fox, Quicksliver
and even C to call remote systems, digital pagers, transfer files, etc for
almost two years with no troubles.  (prior to this I used Blaise libs and
Greenleaf libs for Microsoft C so I know what hard work is!).
It can even work in background.

You can see adds for it in Data Based advisor.
It is from a company Compusolve in Rockaway NJ, 07866
Phone # (201) 983-9429

The company will allow you to get demo version (runs for limited time) 
which can actually be used in production if files are small enough.

It costs about 100 dollars and the assistance that I have received from
company when needing help has been literally short of amazing.  (They
have looked at my source code, talked to me FREE for unlimited time and done
everything that my clients would expect from me.)

It supports protocols except Zmodem, baud rates up to 115K, multiport boards
whatever you need.

As a extra they give you source code that pretty much will do anything without
mucking about in it.

-robert

Yes if you have questions I will try to answer / help

Standard disclaimer re: no financial interest in company.

Xref: sparky bit.listserv.dbase-l:937 comp.databases:6623
From: michaelh@g2syd.genasys.com.au (Michael Haldey)
Newsgroups: bit.listserv.dbase-l,comp.databases
Subject: Re: Clipper: Network / Index Question...
Date: 9 Sep 92 10:18:50 GMT
Organization: Genasys II, Sydney, Australia

In article <BuAG16.7CE@acsu.buffalo.edu> bforob@ubvmsb.cc.buffalo.edu (WBFO 88.7 FM -- Rob Rothkopf) writes:
>In article <1992Aug28.001254.7030@g2syd.genasys.com.au>, michaelh@g2syd.genasys.com.au (Michael Haldey) writes...
>>Actually, you can't. But if you issue dbCommit() call before doing something
>>important, Clipper run-time system updates b-tree indexes. 
>
>Not really.. he was talking about in a networked environment.. and if you have 
>files used in Sharable mode, clipper updates the indexes right after the record 
>is replaced (it doesn't even wait for an UNLOCK or another RLOCK()!).  

Frankly speaking, I do not remember any hints on such a behaviour...
May be I'm wrong.

>Netware takes care of everything else.

It really cares about a lot of things. But not about everything :)(if not
call its functions directly).

>
>As a matter of fact, you almost *never* want to do a COMMIT; COMMIT flushes 
>*all* buffers to disk, whether or not they have been changed.  This means if 
>you have 10 files open with 3 indexes each, you have lots of unncessary disk 
>writes/seeks being done and your application can begin to drrrrrag.  

You can commit any particular workarea. But frequency of COMMITing is a 
matter of application design. I do not want to rely on Clipper here; 
otherwise you have to implement, say, some sort of journalling, checkpoint etc.

> Of course, 
>I'm talking about in a networked, sharable mode setting.
>
>>The same idea. Issue dbCommit(). Actually, Clipper, despite an opportunity 
>>to write network applications, is a single-user system. This is inherited 
>>from xBases and can not be reliably solved in not client-server systems. 
>> [ Another idea is to organise a form of communication between processes. 
>>   I've got a number of solutions for that so e-mail if you are interested.]
>
>What are you talking about by "is a single-user system"???!  It has low level 
>locking facilities while, although primative, ... 
				    ^^^^^^^^^
That's what I meant. In real life you have to either make unreliable 
tricks (for example, implementing security) or use underlying 
NetWare/Lan-Manager/etc routines directly. The portability suffers.

>for a multiuser/multitasking system.  If someone wanted a multi-process system 
>where different machines must communicate, Clipper provides for it by allowing 
>you to implement semaphores via indexed files.. of course, depending on the 
>application, another language may be more suitable.

Implementing semaphores through files only is a 'Walt Disney for the poor'.
This is how things are usually done; but it does not mean that the things
are good.

>
>--Rob Rothkopf

Michael Haldey
-- 
Michael Haldey  |  Genasys II Pty Ltd
                |  13th Level, 33 Berry St, North Sydney, NSW, Australia
                |  Phone:    +61-2-954-2878 (-9930 FAX)
                |  Internet: michaelh@g2syd.genasys.com.au
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: DBASE-L@NMSUVM1.BITNET
X-VMS-To: IN%"DBASE-L@NMSUVM1.BITNET"
Newsgroups: bit.listserv.dbase-l
Date:         Mon, 7 Sep 1992 15:03:00 CDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         RESLIFPA@OSHKOSHW.BITNET
Subject:      Re: Report Page Control

Hi
        Try adjusting the Lines/Page setting
                                                -Saad
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Encoding: 12 TEXT
X-Mailer: Microsoft Mail V3.0 (beta-1)
Newsgroups: bit.listserv.dbase-l
Date:         Mon, 14 Sep 1992 12:38:00 PDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Ramiro@SECTEC.SSCNET.UCLA.EDU
Subject:      QUESTION?

GOOD AFTERNOON FROM GUADALAJARA, JAL. MEXICO

CAN SOME ONE RECOMEND BOOKS ON CLIPPER 5.1
OTHER THEN "THE GUIDE TO CLIPPER"


GRACIAS

THANK YOU

     RAMIRO
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Subject: (no subject given)
X-Envelope-to: DBASE-L@NMSUVM1.BITNET
Content-transfer-encoding: 8BIT
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 11 Sep 1992 17:59:57 -0700
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         VHASS%CAT700.gm@HAC2ARPA.HAC.COM

SUB Vishwanath Hssan
Organization: City University of New York/ University Computer Center
Date: Saturday, 5 Sep 1992 23:13:05 EDT
From: <EQMBB@CUNYVM.BITNET>
Newsgroups: bit.listserv.dbase-l
Subject: Report Page Control

Can someone help me figure out how to control when the next page on a report sh
ould be sent to the screen?
I created a report in dbase III+ that I would like to output to the screen
but I cant control the report to stop after every page and request the user
to get the next page of the report.
Any info would be greatly appreciated.
nick
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Delivery-Notice:  SMTP MAIL FROM does not correspond to sender.
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 10 Sep 1992 06:12:57 EDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Rich=Gautier%SETA%DRC@S1.DRC.COM
Subject:      re: Indexes?

Why not try:

INDEX ON TOCC_DESC TAG TOCC_NO WHERE SUBSTR(TOCC_NO,1,2)="VE"

				Rich Gautier
From: SBA@CORNELLC.BITNET
Newsgroups: bit.listserv.dbase-l
Subject: Re: Data Based Advisor (fwd)
Date: 8 Sep 92 13:24:31 GMT
              dialects" <DBASE-L@NMSUVM1.BITNET>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
              8 Sep 1992 14:05:39 BST from <I.Bowes@SOUTHAMPTON.AC.UK>

DBA Subscriptions: 1 year (12) issues U.S. $35, Canada $55 (includes GS tax),
Forgien $75 (U.S. Dollars, U.S. Banks or Clearing houses only).  CA Residents
add 7.75% sales tax. Send subscription orders to Data Based Advisor Subscrip-
tion Dept., Box 3735, Escondido, CA 92033-9895.  Phone orders only: (800)
336-6060.  Customer Service: (619) 483-6400.

I've had a subscription from it's beginning.  Steveb
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Posted-Date:  Fri, 11 Sep 92 00:43:15 -0500
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 11 Sep 1992 00:43:15 -0500
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         garyg@EMX.CC.UTEXAS.EDU
Subject:      Re: Clipper: Backup/Restore routines for BIG files...

>Back a couple of years ago I downloaded some source code that will backup
>and restore large files or a number of files over a number of diskettes.
>It was written and put in public domain by someone in Switzerland.  It is
>entirely written in clipper and works beautifully.  I have included it in
>my applications for the past year.
>
>For anyone who has access to E-mail and 'uuencode' & 'uudecode' I would be
>willing to send them a copy.

Thank you.
Please send.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Via:        UK.AC.SOTON; 10 SEP 92 11:06:58 BST
X-Mailer:   ELM [version 2.3 PL11]
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 10 Sep 1992 10:59:27 BST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "I.Bowes" <I.Bowes@SOUTHAMPTON.AC.UK>
Subject:      Indexes?

Dear all on DBASE-L,
(programming in dBase IV v1.1)
I have a problem regarding a picklist Im trying to create using conditional
indexes.
I'll try to elaborate...

I have a chemical data table containing a type of compound and a type of
compound description.
eg.

TOCC_NO           TOCC_DESC

VA0001            Alkaloids (natural and synthetic)
VA0002            Quinolizidines
..
..
VE0001            Penicillins (natural and synthetic)
VE0002            General Antibiotics

I was trying to create a subset of this table (to make into a POPUP picklist
with the descriptions; tocc_desc), according to its TOCC_NO. First I tried
using

SET FILTER TO substr(tocc_no,1,2) = "VE"

But the subsequent picklist was extremely slow. Then I tried creating a
conditional index using

USE tocc.dbf
INDEX ON tocc_no TAG tocc_no for substr(tocc_no,1,2) = "VE"

This worked fine, although there was a small delay before the picklist was
displayed (better than using the filter though!).

My problem now, is that the picklist is in any order, I want to alphabetically
sort the records in the subset. How can I index a subset created by an index?

There must be a way of doing this, but Im a bit baffled at the mo'.

to clarify:

In the above example the picklist was created using the DEFINE POPUP command
with the PROMPT FIELD tocc_desc clause. The Picklist was displayed as follows:

Alkaloids (natural and synthetic)
Quinolizidines
..
..
Penicillins (natural and synthetic)
General Antibiotics

and I need this list alpha-sorted to make any sense to the user.

Any Help Gratefully received: I.Bowes@uk.ac.soton   Ian.
Newsgroups: bit.listserv.dbase-l
From: s187318@alfred.carleton.ca (Bing Wen ~{NB1y~})
Subject: Re: Help needed to interpret Clipper error message
Organization: Carleton University
Date: Mon, 7 Sep 1992 23:56:59 GMT

Thanks, Saad.

I thought NG was an electronic version of the manuals that came along
with the software. I guess I should install it, knowing it contains
more updated information than the books.

Bing
-------------------------

>Hi!
>        Have you seen the NG.exe that comes with Clipper 5.  I saw it there
>I did not look for it in the book
>                                                        -Saad
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Organization: State University of New York - Central Administration
Newsgroups: bit.listserv.dbase-l
Date:         Tue, 8 Sep 1992 09:29:54 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         EVERETT OGDEN <OGDENEB@SNYCENVM.BITNET>
Subject:      Re: dbase questions + ASCII --> dbase

Maarten van Loon asked (among other things) why dBASE files use
fixed-length fields, padded with spaces, rather than just storing the
data as in an ASCII file.  He says that seems inefficient.  Inefficient
for storage space, yes, but very efficient for speed.  Suppose you have
a database of several million records, and you want to look at record
3,579,545.  dBASE knows how big a record is, so a quick calculation
tells it just where to look in that multimegabyte file.  With a plain
sequential file, you'd have to scan through the file from the head (an
indexed sequential file would improve things some).

More importantly, look what happens when you want to modify a record.
Since the new version will take exactly the same space as the old, dBASE
can change just that part of the file.  But with a sequential file, you
have to either remove the old version and insert the new (and rewrite
the file from the record's position to the end), or tack any changed
records onto the end of the file, eventually leaving a lot of dead space
in the file and requiring a good indexing system to keep track of it.
Word processors generally work with sequential files and use one of the
latter two methods (the only one I know of that used the last method was
DisplayWrite).  But you don't generally load multimegabyte files into a
word processor.  If you do, you'll find that edits and even movement
through the file are very slow indeed.

      Everett Ogden    ogdeneb@snycenvm.bitnet
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Via:        UK.AC.SOTON;  9 SEP 92 17:33:08 BST
X-Mailer:   ELM [version 2.3 PL11]
Newsgroups: bit.listserv.dbase-l
Date:         Wed, 9 Sep 1992 17:25:40 BST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "I.Bowes" <I.Bowes@SOUTHAMPTON.AC.UK>
Subject:      Re: Data Base Advisor

Dear DBASE-L,

I have not seen any copies of the DATA BASED ADVISOR Magazine although I have
had some good reviews from members of the UK Based chest-dbase MAILBASE list.
I include some of their comments .....

---------------------------------------------------------------------------
From: TA@UK.AC.MRC.CANCER-TRIALS-OFFICE
To: I.BOWES@UK.AC.SOUTHAMPTON
Subject:        RE: dBase User group
Status: OR

Ian

  Have you seen a magazine called Data Based Advisor.  Its American but
is distributed over here.  It is aimed at xbase developers and has many
useful tips and articles.

There is certainly plenty to chew on as Data Based Advisor is aimed at
developers rather than end users.  There are sections on each of the xbase
dialects as well as news, client/server development, networking, downsizing
and many of the other buzz words.  The articles on xbase dialects range
from introducing underused (or incorrectly used) features of the language
to providing new ways of doing things and tips to help you get the most
from your environment.

.....
  from another member, about Data Based Advisor

That magazine is mainly geared to Clipper developers. I suppose it could
be useful to dBase users/programmers.

You are better off by subscribing to TechNotes from Borland. It provides
answers to your sort of questions. (i.e. How do I create a pop-up menu
within a window, etc, etc, etc.)

I don't know what the subscription rate is, but if I remember correctly
it wasn't a lot.

Happy hacking!
---------------------------------------------------------------------------

It seems it may be more geared to Clipper/dBase III, than dBaseIV programmers
although I suppose becoming familiar with the other dialects can give you a
general feel for the xbase language.

Any Help ?

Ian Bowes
BITNET/EARN I.Bowes%soton.ac.uk@UKACRL
JANET: I.Bowes@uk.ac.soton
/*------------------------------------------------------------------------*/
/* Mr I. Bowes BSc(Hons) Database Programmer                              */
/* International Legume Database and Information Service (ILDIS)          */
/* Bioinformatics Laboratory, Dept. of Biology                            */
/* University of Southampton, Bassett Crescent East                       */
/* Southampton, UK. SO9 3TU                                               */
/*------------------------------------------------------------------------*/
From: ACSMSS@SAUPM00.BITNET (Siddiq, Mohammed)
Newsgroups: bit.listserv.dbase-l
Subject: Help
Date: 6 Sep 92 06:47:46 GMT
              dialects" <DBASE-L@NMSUVM1.BITNET>
Organization: King Fahd University of Petroleum and Minerals, S.A.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Acknowledge-To: <ACSMSS@SAUPM00.BITNET>

Hi,
   I am developing a package for a client and a came across this problem that m
y client has a office away from his shop and he wants me to give him an option
within the application which will use a modem to dial and upload the transactio
n file upon selection of that option.

  I will be very much thankful for all suggestion.

BBBBBBB  YY    YY EEEEEEEE**********************************************
BBBBBBB  YY    YY EEEEEEEE*                                            *
BBBBBBBB YY    YY EEEEEEEE*  Talk To You Later.                        *
BBBBBBBB YY    YY EEEEEEEE*                                            *
BB    BB  YY  YY  EE      *                                            *
BB    BB  YY  YY  EE      *  SUCCESS IS LIKE A FART...!                *
BBBBBBB    YYYY   EEEEEE  *       YOU CAN ONLY STAND YOUR OWN.         *
BBBBBBB    YYYY   EEEEEE  **********************************************
BBBBBBB     YY    EEEEEE  * Mohammed Siddiq - Programmer / Analyst     *
BBBBBBB     YY    EEEEEE  * KFUPM # 613, Dhahran -31261, Saudi Arabia  *
BB    BB    YY    EE      * Tel: (Off) 00966-3-860-3959                *
BB    BB    YY    EE      *      (Res) 00966-3-894-3897                *
BBBBBBBB    YY    EEEEEEEE* E-Mail:ACSMSS@SAUPM00.BITNET               *
BBBBBBBB    YY    EEEEEEEE* Inter.:ACSMSS%SAUPM00.bitnet@vm.temple.edu *
BBBBBBB     YY    EEEEEEEE* Fax : 00966-3-860-3955                     *
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Via:        UK.AC.SOTON; 10 SEP 92 13:35:40 BST
X-Mailer:   ELM [version 2.3 PL11]
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 10 Sep 1992 13:28:09 BST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "I.Bowes" <I.Bowes@SOUTHAMPTON.AC.UK>
Subject:      Indexes ?

Dear All,

Thanks for the suggestion, it worked


index on substr(tocc_no,1,2)+left(tocc_desc,3) tag tocc_no for;
   substr(tocc_no,1,2) = "VE"


I also had other replies suggesting :-

index on left(tocc_desc,3) tag tocc_no for substr(tocc_no,1,2) = "VE"

Both work.

I was probably just being stupid this morn :-)

Cheers,

Ian Bowes
I.Bowes@uk.ac.soton
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Via:        UK.AC.SOTON;  8 SEP 92 14:13:02 BST
X-Mailer:   ELM [version 2.3 PL11]
Newsgroups: bit.listserv.dbase-l
Date:         Tue, 8 Sep 1992 14:05:39 BST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "I.Bowes" <I.Bowes@SOUTHAMPTON.AC.UK>
Subject:      Data Based Advisor (fwd)

 From ianne Tue Sep  8 14:00:07 1992
 Date: Tue, 8 Sep 92 14:00:07 BST
 To: dbase-l%nmsuvm1@earn-relay
 Subject: Data Based Advisor
 X-Mailer: ELM [version 2.3 PL11]

 Dear DBASE-L,

 I am a UK dBase programmer, who keeps hearing about the (US ?) magazine
 DATA BASED ADVISOR, but who can't seem to find anyone over here with a
 contact address. Could anyone tell me how to go about ordering this mag?
 Publishers address ?

 Cheers

 Ian Bowes

 BITNET/EARN I.Bowes%soton.ac.uk@UKACRL
 JANET: I.Bowes@uk.ac.soton
 /*------------------------------------------------------------------------*/
 /* Mr I. Bowes BSc(Hons) Database Programmer                              */
 /* International Legume Database and Information Service (ILDIS)          */
 /* Bioinformatics Laboratory, Dept. of Biology                            */
 /* University of Southampton, Bassett Crescent East                       */
 /* Southampton, UK. SO9 3TU                                               */
 /*------------------------------------------------------------------------*/
    Nevermind - Life can only get shorter.
Newsgroups: bit.listserv.dbase-l
From: jwarner@mrcnext.cso.uiuc.edu (Jack E. Warner)
Subject: flush right, zero fill
Organization: University of Illinois at Urbana
Date: Sun, 6 Sep 1992 22:53:28 GMT

I am working with a database that has a numeric field "Total" that is 6
digits long (though of course there may be 1--6 digits in this field. 
What is the best way --- using dBASE IV --- to get this to print to an 
ascii "field" say 9 digits long, flush right, zero fill? So that

if Total=22,               or        if Total=12345,
?? Total                             ?? Total
returns 000000022                    returns 000012345

I think I'd like to use replicate("0",x) where x is the difference between
the number of digits in the field and, in this case, 9; though I'm not
quite sure how to define such a function using len() to find out how many
digits are there in the first place. Possibly I'd have to use something like:

Length=len(ltrim(rtrim(Total))) 9-Length=number_of_0s ?? number_of_0s+Total

Thanks to dBASE wizards who e-mail ideas to
jwarner@mrcnext.cso.uiuc.edu (Jack E. Warner)

Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-Receipt-To: <Ramiro@sectec.sscnet.ucla.edu>
Encoding: 2 TEXT
X-Mailer: Microsoft Mail V3.0 (beta-1)
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 10 Sep 1992 11:48:00 PDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Ramiro@SECTEC.SSCNET.UCLA.EDU
Subject:      SUBSCRIBE

TELL LISTSERV AT TECMTYVM SUBSCRIBE DBASE-L RAMIRO CORONA
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: DBASE-L@NMSUVM1.BITNET
X-VMS-To: IN%"DBASE-L@NMSUVM1.BITNET"
X-VMS-Cc: DSMITH
MIME-version: 1.0
Content-type: TEXT/PLAIN; CHARSET=US-ASCII
Content-transfer-encoding: 7BIT
Newsgroups: bit.listserv.dbase-l
Date:         Tue, 8 Sep 1992 07:47:42 -0500
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         DON SMITH <DSMITH@INDYVAX.BITNET>
Subject:      Re: flush right, zero fill

This one has a simple solution.  I can't take credit, this comes straight out
of the Data Based Advisor's letter column from March, '91...

   new_var = TRANSFORM(old_var, '@L 999999')

If old_var was 123, new_var will be "000123"

Elegent, yes?

Don Smith
Newsgroups: bit.listserv.dbase-l