HDTenEightyP/NetNews huggingface dataset:
X-Orig-Date: Tue, 28 Jul 1992 23:52:25 GMT
X-Orig-From: "Discussion on the use of the dBase language and related dialects"
             <DBASE-L@TECMTYVM.BITNET>
X-Orig-Message-Id: <9207290051.AA12295@charly.taclog.af.mil>
Status:  N
Newsgroups: bit.listserv.dbase-l
Date:         Tue, 28 Jul 1992 21:27:45 -0600
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "TSgt Mark Singleton;37TFW/MAS;DSN 358-5422"
              <singleto@TACLG.AF.MIL>
Subject:      Re: changing letters to uppercase
X-To:         DBASE-L@charly.taclog.af.mil

>Hello, does anyone know if there's a program (preferably one I can get
>with ftp) that will change all the letters in a dbase file to
>uppercase.  I could do it by hand, but it's a longggg file.

Why not try the following in dBase3/4


if the Database (NAME.DBF) looks like this:

FIELD   NAME    TYPE   WIDTH   DEC

1       LNAME   CHAR     20      0

2       FNAME   CHAR     20      0

3       MNAME   CHAR     20      0


Try this program

USE name

DO WHILE .NOT. EOF()

    REPLACE lname WITH UPPER(lname)
    REPLACE fname WITH UPPER(fname)
    REPLACE mname WITH UPPER(mname)
    SKIP
ENDDO

It has to read every record but just go get a cup of coffee while
you wait.


Mark Singleton, singleto@taclg.af.mil
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Organization: State University of New York - Central Administration
Newsgroups: bit.listserv.dbase-l
Date:         Wed, 29 Jul 1992 07:41:15 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         EVERETT OGDEN <OGDENEB@SNYCENVM.BITNET>
Subject:      Re: changing letters to uppercase
              28 Jul 1992 23:52:25 GMT from <mrdunn@CSD4.CSD.UWM.EDU>

Michael Dunn wants to replace all letters in a dbase file with
uppercase.  How about:

  REPLACE ALL Field1 WITH UPPER(Field1), Field2 WITH UPPER(Field2), ...

where Field1, Field2, etc. are all of the fields that might contain
letters.

I question whether converting to uppercase is a good idea, though.  It's
fine if lower- or mixed-case is never desirable (in an arbitrary key
code, for example), but it's a good idea to keep it for names and
addresses.  Yes, I know the Post Office would like addresses in
uppercase, but you wouldn't want that in the body of a letter.  The
UPPER() function can always be used to print labels or in indexing
expressions.

      Everett Ogden    ogdeneb@snycenvm.bitnet
Newsgroups: bit.listserv.dbase-l
From: rdb@ktibv.uucp (The Graphical Gnome)
Subject: Re: Clipper/MEMO Question
Organization: KTI BV
Distribution: bit
Date: Mon, 27 Jul 1992 15:04:27 GMT

schli@cs.tu-berlin.de (Wolfram Schlickenrieder) writes:



>	Hi there...

>	I (yet again) have a problem with the *.DBT files (those files
>	where the content of all the MEMO fields of a DB is held).
>	Problem is the following:

>	I have a database with two fields in each record: An index
>	field for identification purposes, and a memo field with about
>	10000 to 25000 Bytes in it.  I expect to have about 100 to 200
>	records in it.  Now when I change the contents of a memo field
>	it seems like the old contents are not removed from the DBT
>	file, and thus, the DBT file gets *enormously* huge: With 20
>	records in it and exactly 10000 bytes in each memo field the
>	DBT file's size is now 7MB (7,000,000 bytes)!  Is this
>	supposed to be like it is, or am I doing something wrong? Or
>	-- even better -- am I missing anything, something like
>	"memo-file-pack ()"?!?

>	Any help is apprechiated...

>	...Wolfram

Your not mistaken. dBase does exactly what you are thinking. I solved it by
having a maintenance function in my applications.
the procedure packs all files, copies the files with memos ( to repack
de DBT files) and creates new indexes (just to be on the save side, deleting
without indexes goes faster). There is no memopack function. 
Copying does the trick, dirty, but it works. 


If you find somthing better pls let me know.


Happy Hacking "PABRAS"
(aka The Graphical Gnome)

-----------------------------------------------------------------------------
| Rob den Braasem    | "Before I sink into the big   | Voice :-31-79-531825 |
|                    |  sleep, I want to hear the    | Fax   :-31-79-513561 |
|                    |  scream of the butterfly."    | Mail  :              |
| "PABRAS"           |  J. Morrison          | ..!sun4nl.nluug.nl!ktibv!rdb |
| KTI bv             |-------------------------------| ---------------------|
| P.O. Box 86        | "I die when it's time for me to die. So let me live  | 
| 2700 AB Zoetermeer |   my life the way I want to."                        |
| The Netherlands    |   Jimi Hendrix                                       |
-----------------------------------------------------------------------------
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 24 Jul 1992 14:51:06 -0700
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         S-DELA@UMINN1.BITNET
Subject:      temp index files

 I am getting messages that I am out of disk space during the creation of
 either .ndx or .mdx index file. The message refers to my C: drive where
 my dbase IV v1.5 programs are, but I'm indexing a database on on D drive
 that has LOTS of free disk space. I never had this problem under ver 1.1
 and I had indexed much larger files. (This one is 3 MB.)

 I've tried setting the path to the D drive, setting the directory and
 setting the default. I still get the same error. Does anyone have any
 ideas?

 My PC is a Zeos 386 33MHz with 6 MB ram, DOS 5.0, and Desqview.


 Also, what was the answer to the question about suppressing the dBase
 banner stuff that pops up when you start the program?

 Thanks,

     Sarah Delaney                       University of Minnesota
 s-dela.uminn1.bitnet               Mgmt Planning & Info Service
 s-dela@vm1.spcs.umn.edu                   30 Wulling Hall
 FAX: 612-624-6057,  Phone: 624-1093     Minneapolis, MN 55455
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Wed, 29 Jul 1992 16:11:35 PDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Anthony Tieu <atieu@SKAT.USC.EDU>
Subject:      Re: changing letters to uppercase
X-To:         "Discussion on the use of the dBase language and related
              dialects" <DBASE-L%NMSUVM1.BITNET@VM.usc.edu>

there is a function call upper which will convert a string to upper case
. you can do something like this
	replace all name with upper(name)

which will convert the field name to uppercase for all the records.
*** CAUTION: be should to make a backup copy of your dbase file
be attempt to make any global changes such as replace command.

-Anthony
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Mon, 27 Jul 1992 10:47:33 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         RBOYER2 <rboyer2@IUS.INDIANA.EDU>
Subject:      Re: Clipper/MEMO Question
X-To:         schli%CS.TU-BERLIN.DE@TECMTYVM.MTY.ITESM.MX

          No you aren't missing anything (that's the way MEMO fields
          work in dBase).  The way to get the memo file size down to a
          reasonable level (and increase performance) is to use: COPY
          <dBase file name> TO <new dBase file name>.  This will only
          copy the latest "version" of the memo field and will place
          the memo in optimal order (sequential).

          Alternetly, a book called (I think) "Guide to Clipper
          programming" had a program (C code) that would "pack" a memo
          file for you.  HTH!

    +---------------------------------------------------------------------+
    | Richard L. Boyer                                     (812) 941-2287 |
    | Operations Supervisor/Programmer & Associate Network Administrator  |
    | Indiana University Southeast | IUS LAN Mail: Rick                   |
    | Computer Services, CV-030    |  Bitnet Mail: Rboyer@Iubacs          |
    | 4201 Grant Line Road         |Internet Mail: Rboyer@Ucs.Indiana.Edu |
    | New Albany, IN  47150 USA    |                                      |
    +---------------------------------------------------------------------+
    |=---> RAID: kills bugs dead forever.  Just in case you thought <----=|
    |=---> there was some kinda live temporary killing! - Galligar  <----=|
    +---------------------------------------------------------------------+

==================================================================
	Hi there...

	I (yet again) have a problem with the *.DBT files (those files
	where the content of all the MEMO fields of a DB is held).
	Problem is the following:

	I have a database with two fields in each record: An index
	field for identification purposes, and a memo field with about
	10000 to 25000 Bytes in it.  I expect to have about 100 to 200
	records in it.  Now when I change the contents of a memo field
	it seems like the old contents are not removed from the DBT
	file, and thus, the DBT file gets *enormously* huge: With 20
	records in it and exactly 10000 bytes in each memo field the
	DBT file's size is now 7MB (7,000,000 bytes)!  Is this
	supposed to be like it is, or am I doing something wrong? Or
	-- even better -- am I missing anything, something like
	"memo-file-pack ()"?!?

	Any help is apprechiated...

	...Wolfram
From: lapworth@mizar.usc.edu (Bill Lapworth)
Newsgroups: bit.listserv.dbase-l
Subject: Omenu.prg (sample from Nantucket)
Date: 21 Jul 1992 15:38:59 -0700
Organization: University of Southern California, Los Angeles, CA
NNTP-Posting-Host: mizar.usc.edu

I've been playing with Omenu.prg, which makes SAA/CUA type menus in
Clipper 5.01.  Nantucket probided the program, but the documentation
is a bit skimpy.  I've figured out how to use it, but can't make it
call a proc directly from the menubar without going through a menu.
That is, I can have a "EXIT" option on the menubar, and when that
is pressed a single item menu opens up, which when pressed executes
the desired proc.  What I want to do is press "EXIT" on the menu
bar and go directly to the proc.  

Can this be done?
Newsgroups: bit.listserv.dbase-l
From: schli@cs.tu-berlin.de (Wolfram Schlickenrieder)
Subject: Clipper/MEMO Question
Organization: Technical University of Berlin, Germany
Distribution: bit
Date: Mon, 27 Jul 1992 13:25:45 GMT



	Hi there...

	I (yet again) have a problem with the *.DBT files (those files
	where the content of all the MEMO fields of a DB is held).
	Problem is the following:

	I have a database with two fields in each record: An index
	field for identification purposes, and a memo field with about
	10000 to 25000 Bytes in it.  I expect to have about 100 to 200
	records in it.  Now when I change the contents of a memo field
	it seems like the old contents are not removed from the DBT
	file, and thus, the DBT file gets *enormously* huge: With 20
	records in it and exactly 10000 bytes in each memo field the
	DBT file's size is now 7MB (7,000,000 bytes)!  Is this
	supposed to be like it is, or am I doing something wrong? Or
	-- even better -- am I missing anything, something like
	"memo-file-pack ()"?!?

	Any help is apprechiated...

	...Wolfram
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Popmail-Charset: English
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 23 Jul 1992 08:07:18 CST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         sschmidt@HP.UWSUPER.EDU
Subject:      Re: Expanding Letters

On Thu, 23 Jul 1992 06:22:20 -060,
  MSgt Brian J. Boudreaux;3380 SUPS/LGSPM;DSN 597-   writes:

>Thanks for the info, however I think that I was not clear enough.
>
>What I need to do is take a normal size letter/number and make it
>larger in height, not s p r e a d out.  I need to be able to print
>labels that contain as a minimum 3/4" lettering.
>
>I hope that this clarifies it a bit for you.
>
>Brian J. Boudreaux
>"Who Dat" in the Super Bowl - Go New Orleans!!!!!

Try changing printer fonts.  In dbase IV I use ??? to send control codes to
the printer.  Clipper must have something similar.

--
Stanton W. Schmidt
University of Wisconsin-Superior
sschmidt@uwsuper.edu
Newsgroups: bit.listserv.dbase-l
From: jw2b@galen.med.Virginia.EDU (Sara J. Wagner)
Subject: Re: Flushing a read statement
Organization: University of Virginia
Date: Fri, 31 Jul 1992 17:13:08 GMT


I set up something similar for my get subfunctions (assuming you're
using Clipper).  As best as I can remember (without looking it up):

Do while !lcorrect
  @1,5 get variable
       ... (lots more)
  @ 24,5 say "Type Y or press CTRL-END to save, Esc to abort " get
lcorrect picture "Y"
  read
if lastkey() = K_CTRL_END
  lcorrect := .t.
endif
enddo
if lastkey() != K_ESC
  (do something with the values)
endif

I can press CTRL-End anywhere in the read statements and have it
register.  Hope this helps.

--
Jane Wagner, Computer Systems and Publications Assistant
The Claude Moore Health Sciences Library| INTERNET: jw2b@virginia.edu
Box 234, UVA Health Sciences Center	| PHONE:    804-924-0188
Charlottesville, VA  22908 		| BITNET:   jw2b@virginia.bitnet
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Mon, 27 Jul 1992 09:57:49 EDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         TKOZMA@WAYNEST1.BITNET
Subject:      Re: Clipper/MEMO Question
              27 Jul 1992 13:25:45 GMT from <schli@CS.TU-BERLIN.DE>

You are correct that when a memo field is changed the old contents
remain in the file.  The solution seems to be to make a copy of the
database.  The obsolete portions of the .dbt file will be discarded.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Mailer: ELM [version 2.3 PL11]
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 31 Jul 1992 14:48:25 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Mak Rusli <grads064@SNOWHITE.CIS.UOGUELPH.CA>
Subject:      Flushing a read statement
X-To:         DBASE-L%NMSUVM1.BITNET@vm.uoguelph.ca
              "ALDSTF06@OUACCVMB.BITNET" at Jul 30, 92 1:22 pm

Hi Everyone.

Consider the following code:

MDone = "N"
ON KEY Ctrl-End DO ...
.
.
.
MQuantity = 0
MDescription = space(35)
MPrice = 0
@3,3 GET MQuantity
@3,9 GET MDescription
@3,42 GET MPrice
READ

The problem is:
After the user hit Ctrl-End, he/she has to finish up the whole section of the
GETs with either the Tab or the PgDown key.

The question is:
How can I flush the read statement when the user hit the Ctrl-End ?

Thanks in advance.

MAK RUSLI
Dept. of Computing and Info. Sc.
University of Guelph
Guelph, ONT, N1G 2W1
Canada
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:         Wed, 29 Jul 1992 08:11:00 CDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         BKCOBB@UAMS.BITNET
Subject:      Re: changing letters to uppercase

If you're talking about character fields, why not just do
a

  REPLACE ALL myfield WITH UPPER(myfield)

and repeat this for all the character fields in the
database?

Brian
e-mail: bkcobb@life.uams.edu
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Status:  N
Newsgroups: bit.listserv.dbase-l
Date:         Wed, 22 Jul 1992 14:14:49 -0600
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "MSgt Brian J. Boudreaux;3380 SUPS/LGSPM;DSN 597-"
              <boudrea@CHARLY.TACLOG.AF.MIL>
Subject:      Expanding Letters
X-To:         DBASE-L@charly.taclog.af.mil

I am writting a program where I need to be able to print
letters/numbers in various sizes.  Does anyone know of a routine or
way to get this done from within a Clipper 5.01 based program?


Thanks
MSgt Brian J. Boudreaux
Keesler AFB, MS
boudrea@charly.taclog.af.mil
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: WIGHTMAN
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 24 Jul 1992 21:29:00 CDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         BRIAN THOMAS WIGHTMAN <WIGHTMAN@OSHKOSHW.BITNET>
Subject:      Re: temp index files

Date sent:  24-JUL-1992 21:20:41

->  I am getting messages that I am out of disk space during the creation of
->  either .ndx or .mdx index file. The message refers to my C: drive where
->  my dbase IV v1.5 programs are, but I'm indexing a database on on D drive
->  that has LOTS of free disk space. I never had this problem under ver 1.1
->  and I had indexed much larger files. (This one is 3 MB.)
->
->  I've tried setting the path to the D drive, setting the directory and
->  setting the default. I still get the same error. Does anyone have any
->  ideas?

I'm not sure about dBase IV, but a lot of other programs use an environment
variable named TMP or TEMP.  This may be a place to start looking.  Some times
these variables are pointing to C:\DOS, and other times they are not set at
all.  See if dBase IV uses them, and if it does, set the environment variable
to your D: drive by typing SET TMP=(or TEMP=, depending on the need)D:\<subdir>
where <subdir> is a temp directory on your larger drive.  Hope that works.

Good luck :-)

Whitey...

->      Sarah Delaney                       University of Minnesota
->  s-dela.uminn1.bitnet               Mgmt Planning & Info Service
->  s-dela@vm1.spcs.umn.edu                   30 Wulling Hall
->  FAX: 612-624-6057,  Phone: 624-1093     Minneapolis, MN 55455

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Brian Wightman                  | Bitnet    := WIGHTMAN@OSHKOSHW            |
| UW-Oshkosh                      | Internet  := WIGHTMAN@vaxa.cis.uwosh.edu  |
| Member of ACM since 02/92       +-------------------------------------------|
|---------------------------------+        A QUOTE .... FOR A WHILE           |
| Van Gogh's Law - "Whatever plan one makes, there is a hidden                |
|                        difficulty somewhere" - Murphy, 1992                 |
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Hi.  I am a signature virus.  Copy me into your signature to join.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Status:  N
Newsgroups: bit.listserv.dbase-l
Date:         Tue, 28 Jul 1992 19:53:28 -0600
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "TSgt Mark Singleton;37TFW/MAS;DSN 358-5422"
              <singleto@TACLG.AF.MIL>
Subject:      Toms Dbase Question
X-To:         DBASE-L@charly.taclog.af.mil
X-cc:         mictom@ubvms.cc.buffalo.edu

> We have a budget tracking system that was created using dBase III plus.
> Our problem is that no one here knows how to start a new financial year
> i.e. make a new directory and recreate the file structures. The
> individual who created the database is no longer with us.
>        + T.J.Corsalini, Director - Computing Services @ UB Law School  +
>        + State University of New York at Buffalo                       +
>        + Internet:     mictom@ubvms.cc.buffalo.edu                     +
>        + Voice:        (716)636-5959   Fax:    (716)636-2064           +

Tom,

I would suggest copying all the files to a backup floppy (first), and
ZAPping the data in the database.

I would suggest you look at the .prg file and find out if you delete the
index files if it will recreate them.  The code I use looks some thing
like this:

IF FILE("budget.ndx")
   USE database INDEX budget
ELSE
   USE database
   INDEX ON category TO budget
ENDIF

If it does not create the new index using dbase go to the dot prompt,
(find out in the .PRG file what the USE Statement is) type the
following:

 database = name of database
 index = name of index

.USE database INDEX index
.SET SAFETY OFF
.ZAP
.SET SAFETY ON
.REINDEX
.CLOSE ALL


and see if it works.  if not reload your backup and maybe someone else
has a suggestion.


Mark Singleton  singleto@taclg.af.mil
                work (801) 777-3307
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: DBASE-L@TECMTYVM.BITNET
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 23 Jul 1992 09:17:14 -0400
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Peter Coleman <pcoleman@MCMAIL.CIS.MCMASTER.CA>
Subject:      Re: Expanding Letters

I have made extensive use of HP laser jet printer codes to not only expand
and/or compress character size but to also rotate the paper
(portait/landscape).  If you do this always remember to reset the printer
back to its default settings at the end of each report via your program.


Peter Coleman                (pcoleman@mcmail.cis.mcmaster.ca)
ABB 132
McMaster University          (416)529-7070x3856
Hamilton, Ontario


On Thu, 23 Jul 1992, sschmidt@HP.UWSUPER.EDU wrote:

> On Thu, 23 Jul 1992 06:22:20 -060,
>   MSgt Brian J. Boudreaux;3380 SUPS/LGSPM;DSN 597-   writes:
>
> >Thanks for the info, however I think that I was not clear enough.
> >
> >What I need to do is take a normal size letter/number and make it
> >larger in height, not s p r e a d out.  I need to be able to print
> >labels that contain as a minimum 3/4" lettering.
> >
> >I hope that this clarifies it a bit for you.
> >
> >Brian J. Boudreaux
> >"Who Dat" in the Super Bowl - Go New Orleans!!!!!
>
> Try changing printer fonts.  In dbase IV I use ??? to send control codes to
> the printer.  Clipper must have something similar.
>
> --
> Stanton W. Schmidt
> University of Wisconsin-Superior
> sschmidt@uwsuper.edu
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-Receipt-To: boudrea@charly.taclog.af.mil
Status:  N
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 23 Jul 1992 06:22:20 -0600
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "MSgt Brian J. Boudreaux;3380 SUPS/LGSPM;DSN 597-"
              <boudrea@CHARLY.TACLOG.AF.MIL>
Subject:      Expanding Letters
X-To:         tmoore@charly.taclog.af.mil
X-cc:         DBASE-L@charly.taclog.af.mil

Thanks for the info, however I think that I was not clear enough.

What I need to do is take a normal size letter/number and make it
larger in height, not s p r e a d out.  I need to be able to print
labels that contain as a minimum 3/4" lettering.

I hope that this clarifies it a bit for you.

Brian J. Boudreaux
"Who Dat" in the Super Bowl - Go New Orleans!!!!!
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Subject: (no subject given)
Newsgroups: bit.listserv.dbase-l
Date:         Tue, 28 Jul 1992 07:51:40 EDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         LINDA GLEASON <CGLEASON@SUVM.BITNET>

     I am currently setting up a LAN for a legal firm.  They had already
purchased Paradox 3.5 before my appearance on the scene, so we are
file serving Paradox.  I am much more fluent with programming dBASE but have
not yet set up a real dBASE networking environment.  Does anyone have compari-
son comments?  Or perhaps advice about dBASE's limitations or advantages on a
network application?