HDTenEightyP/NetNews huggingface dataset:
Organization: State University of New York - Central Administration
Newsgroups: bit.listserv.dbase-l
Date:         Mon, 17 Aug 1992 07:58:56 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         EVERETT OGDEN <OGDENEB@SNYCENVM.BITNET>
Subject:      Re: Setting up Paths

Kenneth Jackson asked if it is possible to run dBASE III+ applications
located in a directory other than the one dBASE itself is in.  There are
several ways to do this.  I like the generic approach (i.e. it will work
for most programs, not just dBASE).  Put all the files related to an
application in one directory, separate from the dBASE program directory.
A separate directory for each application is best, unless two apps are
closely related and share data files.

Now do a bit of experimenting to see if the dBASE directory needs to be
on the path (FoxBASE+, the dBASE III+ equivalent, did, but FoxPro does
not).  Go to your app directory and try to start dBASE by specifying the
path to it.  Once started, a well-written program should be able to find
its own files.  If dBASE can't, you'll have to add its directory to your
PATH statement.  You could add it in AUTOEXEC.BAT, but I don't recommend
it (that practice leads to excessively long PATH statements that take a
long time to search).  Better to change the path on the fly and change
it back when you're done.  Again, there are several ways to do this, but
I like USE5.ZIP, available from the SYSUTL directory of SIMTEL20.

Finally, make a batch file in a directory that *is* on the path (C:/BAT
should be the first thing on your path (mainframes don't like
backslashes, but you know what I mean)).  It should save the current
drive and directory (many utilities do this; PC Magazine's BATCHMAN is
one), change to the app's directory, add the dBASE directory to the path
if necessary, and run dBASE with the name of the app's starting .PRG
file as parameter 1.  On exit, the batch file should remove the dBASE
directory from the path if it added it on entry, and return to the
original drive and subdirectory.

A note on paths: nearly all applications' installation instructions tell
you to put the app's subdirectory on your path.  This is rarely
necessary.  Most programs are smart enough to know what directory they
were started from, and will look there for overlays or for a file that
tells them where to find the rest of their files.  WordPerfect does
this.  Some programs want an environment variable that tells them where
to find their files.  ProComm Plus works this way.  A very few, such as
Norton Utilities, deserve to be on the path because they consist of many
files that can be executed separately.  Except in the latter case, it's
usually best to start a program with a batch file that specifies the
path to the program as well as its name.  My PATH statement has only 4
paths in it: BAT (where all the batch files go), DOS, UTIL (general
utilities) and NU (Norton Utilities).  Everything else is run from batch
files.

       Everett Ogden    ogdeneb@snycenvm.bitnet
Newsgroups: bit.listserv.dbase-l
From: aa656@cleveland.Freenet.Edu (Benjamin R. Keller)
Subject: Using @SAY...GET in a window
Reply-To: aa656@cleveland.Freenet.Edu (Benjamin R. Keller)
Organization: Case Western Reserve University, Cleveland, OH (USA)
Date: Sun, 23 Aug 92 02:31:31 GMT


I cannot get @SAY...GET in a window.  The prompt to the user simply flashes 
in the window and does not wait for user input.  I worked around the
problem using WAIT but I would like to use @SAY...GET to make use of the 
verify command.

Please respond via e.mail to
aa656@cleveland.Freenet.Edu

Thanks
Ben Keller
Baldwin-Wallace College
Berea, Ohio
-- 
CFN aa656     |"Anyone who cannot cope with mathematics is
HFN bkeller   |not fully human.  At best he is a tolerable
MFN ac858     |subhuman who has learned to wear shoes, bathe,
YFN ad465     |and not make messes in the house." -Heinlein
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Autoforwarded: false
Content-type: TEXT
Importance: normal
Priority: non-urgent
UA-content-id: 11688A2D3100
X-Hop-count: 1
Date-warning: Date header was inserted by mrgate.uwyo.edu
Newsgroups: bit.listserv.dbase-l
Date:         Mon, 17 Aug 1992 08:57:00 MDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Tony Wickersham <TWICK@CORRAL.UWYO.EDU>
Subject:      RE: COPY FROM

Brett Bendickson (bbendick@ccit.arizona.edu) writes:

> I'm pretty unfamiliar with exchanging files and importing and exporting, ...


Brett:

I exchange files between dBASE and WP using WP's Convert program and the
intermediate file format DIF (Data Interchange Format).  WP's Convert can
change a _secondary merge file_ into a DIF file, which dBASE can import.
Or, dBASE can COPY TO <fname> TYPE DIF, and then WP's Convert can change
it into a secondary merge file.

Judging from what other posters have said, you _might_ not have to go with
an intermediate format.

Good Luck.

Tony Wickersham                   American Heritage Center
Programmer/User consultant        University of Wyoming
twick@corral.uwyo.edu             Laramie, Wyoming, USA
Newsgroups: bit.listserv.dbase-l
From: dc_ags@ac.nsac.ns.ca (Don Christie)
Subject: Re: Using DBASEIV and DBASEIII+
Reply-To: dc_ags@ac.nsac.ns.ca
Organization: Nova Scotia Agricultural College, Nova Scotia, CANADA
Date: Thu, 20 Aug 1992 18:56:27 GMT

In article <MAILQUEUE-101.920819161541.343@econ.uni-paderborn.de>, MODI@ECON.UNI-PADERBORN.DE writes:
>Hi,
>
>I'm having difficulties with using files in DBASEIII+ which have been edited
>under DBASEIV. The MEMO fields somehow get messed up. When I use DBASEIII+ for
>editing it does not find the proper content of the MEMO field anymore.
>Can anybody tell me the reason and what can be done. I only have III+
>at home, but use IV in the office and therefore would like to be able to
>switch back and forth.
>
>You can also answer to me directly. Thanks.

You have stumbled onto one of dBASE's more interesting features... you have
invoked the DESDATA (Destroy DATA) command. First of all, what version of
dBASE IV are you using?? Version 1.0 is notorious for de-indexing the contents
of memo files... Versions newer than that have had this annoying little bug
fixed, according to Borland, anyway.

My advice to you is to get the most recent version of dBASE IV (which I think
is ver. 1.5) and install it at home and at the office... I think you'll run
into serious difficulties if you attempt to switch back and forth. Also, many
application programs get really messed up when they are mixed with two or
more versions of dBASE.

Hope this helps


>
>******************************************************************************
>*                                Armin Modi                                  *
>*                                                                            *
>* Department of business administration                                      *
>* University of Paderborn                                                    *
>* Warburger Str. 100                   Internet: modi@econ.uni-paderborn.de  *
>* 4790 Paderborn                         Fax  (05251) 60-3240                *
>* West Germany                           Tel. (05251) 60-2922                *
>******************************************************************************
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 13 Aug 1992 16:22:02 -0400
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         BRADLEY MORGAN <morgan@GW.WMICH.EDU>
Subject:      RE: Setting up Paths

There is a way to specify the search path using the format
PATH=C:\DBASE\DATA. After reading your message more closely I find
you would like to create files also.  This command will not redirect
files which are save to anywhere but the default directory.  Best fix
of which I am aware is to save the pathname to a memory variable.
Then specify the memory variable with an ampersand in front of the
memory variable name.
use &memvar\<file name>
All new files unless you specify the path will be written to the
default directory in Dbase III.


------------------------------------------------------------
Bradley F. Morgan             Internet: morgan@gw.wmich.edu
Western Michigan University    Phone: (616)-387-5042
Technical Services             Fax: (616)-387-4630
0004 Friedmann
Kalamazoo, MI 49008
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 21 Aug 1992 17:04:53 BSC
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Helio Viana <IBRCEP01@FGVRJ.BITNET>
Subject:      FOXTRIS.ZIP strikes again

What am I doing wrong?
If I say ...

   ftp wuarchive.wustl.edu uuencode
   user anonymous
   get /pub/MSDOS_UPLOADS/FOXTRIS.ZIP

I get ...
<<< 550 /pub/MSDOS_UPLOADS/FOXTRIS.ZIP: No such file or dire
             ctory.

Thanks for your patience
Helio Viana <IBRCEP01@FGVRJ.BITNET>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 21 Aug 1992 09:24:59 HST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         YUNOH@UHCRCHVM.BITNET
Subject:      Re: DO on a variable

you might try preceding the progname with '&' i.e.)  DO &progname
so that the value contained in variable progname is used.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Organization: Universitaet Paderborn
X-Pmrqc:      1
X-Mailer:     Pegasus Mail v2.3 (R3).
Newsgroups: bit.listserv.dbase-l
Date:         Wed, 19 Aug 1992 16:15:41 GMT+2
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         MODI@ECON.UNI-PADERBORN.DE
Subject:      Using DBASEIV and DBASEIII+
X-To:         DBASE-L@TECMTYVM.MTY.ITESM.MX

Hi,

I'm having difficulties with using files in DBASEIII+ which have been edited
under DBASEIV. The MEMO fields somehow get messed up. When I use DBASEIII+ for
editing it does not find the proper content of the MEMO field anymore.
Can anybody tell me the reason and what can be done. I only have III+
at home, but use IV in the office and therefore would like to be able to
switch back and forth.

You can also answer to me directly. Thanks.

******************************************************************************
*                                Armin Modi                                  *
*                                                                            *
* Department of business administration                                      *
* University of Paderborn                                                    *
* Warburger Str. 100                   Internet: modi@econ.uni-paderborn.de  *
* 4790 Paderborn                         Fax  (05251) 60-3240                *
* West Germany                           Tel. (05251) 60-2922                *
******************************************************************************
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: BBENDICK
Newsgroups: bit.listserv.dbase-l
Date:         Sat, 15 Aug 1992 17:24:00 MST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         BBENDICK@ARIZVMS.BITNET
Subject:      COPY FROM

I'm pretty unfamiliar with exchanging files and importing and exporting, and I
haven't been able to find out _anythhing_ about this problem. Is it possible to
import a file delimited by carriage returns? This is all in Dbase III+, and the
file I'd like to import is in WP 5.1, and the linelength is _way_ over anything
I can keep on one line.

I'd like to be able to write a macro to seperate all of my fields by a carriage
return... that's not a problem. The problem's are:

1) The format of my copy command... COPY FROM file TYPE DELIMITED WITH (what?)

2) How does the program know when the next record starts? _Hopefully_ it would
just fill all the fields of a record and then just skip to the next one. I
could ensure that would work.... _if_ that's what it would do.

Hope someone can come up with some ideas, and I appreciate your help.

Brett Bendickson
bbendick@ccit.arizona.edu
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:         Thu, 20 Aug 1992 11:13:25 -0500
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         DON SMITH <DSMITH@INDYVAX.BITNET>
Subject:      Re: Using DBASEIV and DBASEIII+

> I'm having difficulties with using files in DBASEIII+ which have been edited
> under DBASEIV. The MEMO fields somehow get messed up. When I use DBASEIII+ for
> editing it does not find the proper content of the MEMO field anymore.

This isn't a bug, it's a feature.  I'm quoting from the Ashton Tate dBASE IV
ver 1.1 manual, referring to the COPY command, and how you can specify DBMEMO3
as the exported file type:

"DBMEMO3 - dBASE III PLUS format for database (.dbf) and memo field (.dbt)
files.  Once a database and its memo file have been created or modified in
dBASE IV, they cannot be opened in dBASE III PLUS.  However, you can COPY them
with TYPE DBMEMO3 and open the copies in dBASE III PLUS.  Any type F
(floating) numeric field that you copy using the DBMEMO3 option is converted
to type N (fixed)."

Hope that solves your problem...
Don Smith
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 21 Aug 1992 13:32:44 EDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         CC39000 <CC39@IONA.BITNET>
Subject:      DO on a variable

Try using DO &progname... this is how I refer to using different
dbfs and idx's in my generic routines:

use &filen index &indexn

b.gettleman.. cc39@iona
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Tue, 18 Aug 1992 12:12:00 MET
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Jan Snoek <RCIVJAN@HDETUD2.TUDELFT.NL>
Subject:      Re: CUMULATE PROBLEM

> |Date: 7-12-92  7:38pm
> |From: benh:ncrr-lib:nih
> |  To: EDBASE-L@NMSUVM1L:BITNET
> |  cc: benh
> |Subj: CUMULATE PROBLEM
> ------------------------------------------------------------------
> I have a program that cumulates statistics for the current month and
> then wants to refer to a second database with all stats from the
> previous year.  My problem is that the user wants to be able to cumulate
> the Fiscal year to date total for the same month as the current.
> Goverment fiscal years are from October-September.  For instance, if the
> user was to run the statistics program for this month the variable I set
> for the current month is  07/01/92 (day is allways 1) the cumulative
> total is the total from October 91 to present month July.  Now how do I
> sum fields in the second database between October90-July91.
>
> Thanks in advance for any help........
>
>
> Ben Hope, TLC                            Internet: benh@nihrrlib.bitnet
> National Institutes of Health              Bitnet: benh@nihrrlib
> Bethesda, MD

Hi Ben,
Sorry, but what's the problem? It seems straight forward, so probably
I am missing the problem. As I read it now, there are several simple
ways to do this. I suppose that the second database has some field,
let's say DATE, with the date involved in it. So, you select there
the records with DATE>={10/01/90}.AND.DATE<={07/01/92}. That could
be done in dBASE IV with QBE or in dBASE >=3 with a SET FILTER TO
command. Once that is done you can simply SUM the fields you want,
again in QBE or in a statement. In 1.5 the selection can be done
with SET KEY TO, either from QBE or as a command, which is fast.
Is there more to your problem?

Jan Snoek
<Jan.Snoek@RC.TUDelft.NL>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Nupop-Charset: English
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 21 Aug 1992 10:41:40 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "Stephen M. Barrett" <smb1@CORNELL.EDU>
Subject:      RE:DO on a variable

In Message Fri, 21 Aug 1992 09:50:01 EDT,
  Karl Gudmunds <KARLG@ERS.BITNET> writes:

>I am a new user of FoxPro 2.  Is it possible to use DO progname where
>progname is not hardcoded?  I would like to store progname in a field
>of a record which also contains a description of the progname and a
>field that toggles with the user's selection.  That is, if the user
>clicks on the field description, the progname field is passed to DO and
>the progname is run. If progname contains "FOO.PRG", for example, and
>the user selects the program from a pick list then the FOO.PRG file is
>run.
>
>If I try DO progname then FoxPro takes "progname" as literal. This also happens
>if I store the contents of progname to a variable name (e.g. PROGPICK) and
>then try to DO the variable name (e.g. DO PROGPICK).  Do I need to hardcode
>all of the possible picks?  I want the user to be able to add programs
>(essentially queries and reports) to the list, along with a description
>and memo of the program.  Any help?  Thanxxxxxxx.
>
>+------------------------------------------------+
>| Karl Gudmunds      /   I've fallen and I can't |
>| KARLG@ERS.BITNET  0<-<   reach my keyboard!    |
>+------------------------------------------------+

In FoxBASE+ you can use: DO &PROGPICK

In FoxPro you should also be able to DO (PROGPICK) <- better way to do it.

Steveb
>--------------------------------------------------------------------<
> Stephen M. Barrett  (607) 732-7743h     CIT/IR, Cornell University <
> 323 South Ave.      (607) 254-6462o   sba@cornellc.cit.cornell.edu <
> Elmira, NY  14904            ALT: smb1@postoffice.mail.cornell.edu <
>--------------------------------------------------------------------<
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Apparently-From: Soaf1!woodb!jbpackman
Original-To: dbase-l@TECMTYVM.MTY.ITESM.MX
Original-Cc: jbpackman modi@econ.uni-paderborn.de
Newsgroups: bit.listserv.dbase-l
Date:         Wed, 19 Aug 1992 13:39:00 EDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
Comments:     <Parser> E: "From:"/"Sender:" field is missing.
From:         Undetermined origin c/o Postmaster <POSTMASTER@TECMTYVM.BITNET>
Subject: Re: Using DBASEIV and DBASEIII+ Original Message
X-To:         dbase-l@TECMTYVM.MTY.ITESM.MX

****************************************************************************
Hi,

I'm having difficulties with using files in DBASEIII+ which have been edited
under DBASEIV. The MEMO fields somehow get messed up. When I use DBASEIII+ for
editing it does not find the proper content of the MEMO field anymore.
Can anybody tell me the reason and what can be done. I only have III+
at home, but use IV in the office and therefore would like to be able to
switch back and forth.
******************************************************************************
Memo fields are not downward compatbile from dBASE IV to dBASE III+.
Refer to dBASE IV Change Summary page 1-9 on using the COPY TO command
with the DBMEMO3 TYPE option.

Joel B. Packman
Internet: jbpackman@ssa.gov
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Tue, 18 Aug 1992 08:24:27 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Sam McCoy <ALDSTF06@OUACCVMB.BITNET>
Subject:      Redefining Function Keys

First, thanks to all who have replied to my last few requests.
Now, I am wanting to re-define some of the function keys so that a user of the
application I am building can use them for various things that aren't available
now in dBase IV. In other words, I have developed some of my own functions and
wish the user to access them by pressing a certain function key.

Does anyone know if this is possible and if so, could someone send along the
keyboard return codes that dBase understands for them.
Please feel free to send any info to me as well as the list.

Thanks,
Sam McCoy (Aldstf06@OUACCVMB.Bitnet)
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Mailer: ELM [version 2.3 PL11]
Newsgroups: bit.listserv.dbase-l
Date:         Tue, 18 Aug 1992 00:07:25 CDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "Joel N. Fischoff" <jnf@GAGME.CHI.IL.US>
Subject:      PowerBase?

	(Cross-posted to comp.databases)

	One of our clients uses an old database package called
	PowerBase (don't ask me -- I've never heard of it), made
	by a company that is now defunct.  Unfortunately, it
	seems thier hard drive crashed and they've lost the
	boot disks.  Does anyone know where we can get a
	replacement for the boot (startup) disk?

	Also, along the same lines, does anyone know if any of
	the more modern systems (like Paradox, dBase IV, and/or
	FoxPro) can read PowerBase files?

				Thanks,
					Joel N. Fischoff
					jnf@gagme.chi.il.us
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:         Fri, 21 Aug 1992 10:02:45 -0500
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         DON SMITH <DSMITH@INDYVAX.BITNET>
Subject:      Re: DO on a variable

Karl -
   Two ways to do this:  you want to DO progname, where progname is a
variable, not a hard-coded name, right?

   You can either   DO &progname
               or   DO (progname)

   The first technique is known as "macro substitution" and has been a part of
dBASE since at least dBASE III Plus; the second form was introduced in dBASE
IV as a way of avoiding the macro substitution (which you want to do for
various reasons).  The techniques were cloned into FoxPro.

   I'd better be right about this, or I'll look foolish....

Don Smith
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 13 Aug 1992 16:02:00 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Lou Tinaro <TCTINAL@VCCSCENT.BITNET>
Subject:      Creating a Query Without QBE

Sam McCoy <ALDSTF06@OUACCVMB.BITNET> asked:

    I  am  currently designing a dbase  application  in
    dBase  IV  and want to query  a main  database  for
    certain  records (this is going to be used to  help
    users   find the call number of a certain  record).
    The  problem is, I don't want my  user to  have  to
    use the query design screen but rather type in  the
    key phrase  and a list of related titles under this
    unit  will be displayed in which they   can  scroll
    through  until they find the one they want.  (Sorry
    so windy).

The  dBase IV QUERY was designed to make  the  database
searches  friendlier, but Sam is not the only one  that
wishes  to  protect  the users  from  a  supposed  USER
FRIENDLY feature in software.

If  you did not need to pick values from a  list,  this
would be easy.  Write a short program to get the  value
from  the  user and then search for  the  record.   For
example, if CallNo is a numeric field, this might work:

          INPUT "TYPE THE CALL NUMBER" TO M_CALL
          LOCATE FOR CALLNO = M_CALL
          EDIT

To  implement  a  PICK  LIST would  be  a  little  more
complicated.   I  would  use the  menu  system  in  the
applications  generator.  There is something  called  a
VALUES  LIST.   This will display all of  the  possible
values  in a dBase field, allow the user to select  one
and then take some action with that record.

If you are relatively new to dBase IV, the applications
generator will require a little work the first time you
use  it.  One you have mastered it, however,  you  will
find it to be a powerful tool for designing dBase  user
interfaces (protecting the USER from dBase).



=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Lou Tinaro                          BitNet
Tidewater Community College    TCTINAL at VCCSCENT
Va. Beach, VA   23456
U.S.A.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Newsgroups: bit.listserv.dbase-l