HDTenEightyP/NetNews huggingface dataset:
Newsgroups: bit.listserv.dbase-l
Date:         Tue, 15 Dec 1992 15:18:22 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         JLEWIS@INDYCMS.BITNET
Subject:      Re: Extracting Memo fields
              15 Dec 1992 14:22:02 -0500 from <Tom_Scott@QMRELAY
              .MAIL.CORNELL.EDU>

On Tue, 15 Dec 1992 14:22:02 -0500 Tom Scott said:
A Memo field is really just a long string.  I'm not familiar with Foxpro 1.02
but the general concept should be the same....

something like this...

cString = file->memofield
SET PRINTER TO testfile
SET PRINTER ON
? cString
SET PRINTER OFF
-------------------------
or maybe just call a function that will append the cString to a file.

>     Extracting Memo fields
>I'm working on a project right now which is an adaptation of a system we've
>previously been using for three years now.  Currently, we're extracting fields
>from 3 related databases into a text file which we then call the WordPerfect
>CONVERT program to convert it into a mail merge file.  We're using FoxPro 1.02
>on an IBM PS/2 Model 50.  It's worked fine up to this point, but......
>
>Ah yes, there's that "but".  Now we're thinking about customizing the mail
>merge so that each subset of the data (specifically we're extracting students
>that are to be accepted to the Engineering school, and each subset represents a
>different field of engineering that they've expressed an interest in) will
>receive a slightly different letter.  What we'd like to do is maintain a
>seperate database that contain the interest code and the paragraph to be merged
>into the leter for that interest code to be held in a memo field in this
>database.
>
>Once we get to the point where we copy to a text file, and then convert it to a
>WordPerfect mail merge document, we lose the paragraph contained in the memo
>field.  It saves first to the text file and then automatically converts to mail
>merge format, so I'm not positive which of these two operations causes the
>problem, but I suspect it's the former.
>
>Does anybody have a suggestion on how to extract the contents of a memo field
>to a text file for subsequent processing into a mail merge.  This is the first
>time I've tried something like this, and I've hit a brick wall.  So I'm hoping
>the collective net consciousness might have a solution.
>
>Thanks in advance!!!   :-)
>
>
>Thomas Scott, Systems Manager, College of Engineering
>Cornell University, Carpenter Hall Annex, Ithaca, NY  14853
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Wed, 16 Dec 1992 10:14:59 CST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         John G Jay Burrell <jgb1@CC.MSSTATE.EDU>
Subject:      Re: Extracting Memo fields

> >>     Extracting Memo fields  FOR MAIL MERGE
> >> create a database with the interest code and the text for the leter for
> >> that interest code to be held in a memo field in this database.
>
> >> Does anybody have a suggestion on how to extract the contents of a memo
> >> fieldto a text file for subsequent processing into a mail merge.  This is
> >> the firsttime I've tried something like this, and I've hit a brick wall.
> >> So I'm hoping the collective net consciousness might have a solution.
>
> >> Thomas Scott, Systems Manager, College of Engineering
>
> Change your lookup database from CODE, MEMO to CODE, FILENAME
>
> Create the text associated with a code as a wordperfect document.  Store the
> name of the document in the FILENAME field.  Tell Wordperfect to chain
> printing to the file selected (rather than insert) or use a macro to import
> the text reading from the variable.
>
> Alternatively, don't use a memo field, instead use a large text field so that
> wordperfect can read directly from the dbase file.
>
>                         -or-
>
> Create a wordperfect macro that reads a comtrol file and assembles the
> document for you.  Control file example:
>
> Person info, text code, text code, text code . . .
> Person info, text code, text code, text code . . .
> .
> .
> .
>
> WP Macro:  Format Person info; Loop: get filename from text code
>                                      if end found endloop
> finish up formatting
> restart with person info.
>

Quite some time ago developed a stand-alone program to convert dBase style
databases to WordPerfect style secondary merge files.  This program is
available via anonymous ftp at ftp.msstate.edu.  The directory is
/pub/pc/jgb1/clipper.  There are several files there for the taking.
The dbf to wpm conversion program is out there as a self-extracting archive
as well as just zipped.  The file name is dbf2wpm1.exe and dbf2wpm1.zip.

Also available is wpmerge.zip - the Clipper 5.01 object file used to create
dbf2wpm.exe.

Two other programs are also available: dbu_pll.zip/dbualone.zip and
dispmemo.zip.  The dbu*.zip files are Nantucket's DBU.EXE that has been
modified to work on a network with shared databases.  The dbu_pll.zip
requires the use of RtLink's pre-linked library (PLL) and the dbualone.zip
is a stand alone version.  The dispmemo.zip is a C program that will
display the contents of a memory file from the command line.

Enjoy!

Jay Burrell                    E-Mail: jgb1@CC.MsState.Edu
Computing Center & Services     Voice: (601) 325-7025
Mississippi State University      Fax: (601) 355-8921
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-Path: <johnboyd@ocdis01.tinker.af.mil>
X-Orig-Date: Fri, 18 Dec 1992 00:43:35 GMT
X-Orig-From: Smith Brad J <bjs9077%USL.EDU@TECMTYVM.MTY.ITESM.MX>
X-Orig-Message-Id: <9212180057.AA02110@ocdis01.tinker.af.mil>
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 18 Dec 1992 01:01:54 -0600
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         John Boyd <johnboyd@OCDIS01.TINKER.AF.MIL>
Subject:      Re: Packing a Database (Clipper 5.01 question)

In your message of 17 Dec 1992 at 1857 CST, you write:
> In article <9212172241.AA00396@JayRell.CC.MsState.Edu> John G Jay Burrell
> <jgb1@CC.MSSTATE.EDU> writes:
> >>
> >> Question:  How can I pack a subset of deleted records???
> >>
> >How 'bout:
> >        Copy to <new.dbf> for !( date>=CtoD('01/01/92') .AND. ;
> >                                 date<=CtoD('01/31/92')
> >                               )
> >        Erase <old.dbf>
> >        Rename <new.dbf> to <old.dbf>
> >
>
> Would this work in a multi-user enviroment???
>
>         Just Curious.
>
> Is there a more efficient way of doing this??
>
>         If this were a very large file, disk space may become a problem.
>
If your free space is running close enough that you can't mirror your
largest file, you're running too close to the edge ( 1/2 :) ).

----------------------------------------------------------------------------
'Oklahoma, where the legislature runs without a brain' - with apologies to
  Rodgers and Hammerstein
Disclaimer: If you ask the Air Force, they'll tell you I don't know what
             I'm talking about anyway.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Tue, 15 Dec 1992 14:22:02 -0500
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Tom Scott <Tom_Scott@QMRELAY.MAIL.CORNELL.EDU>
Subject:      Extracting Memo fields

     Extracting Memo fields
I'm working on a project right now which is an adaptation of a system we've
previously been using for three years now.  Currently, we're extracting fields
from 3 related databases into a text file which we then call the WordPerfect
CONVERT program to convert it into a mail merge file.  We're using FoxPro 1.02
on an IBM PS/2 Model 50.  It's worked fine up to this point, but......

Ah yes, there's that "but".  Now we're thinking about customizing the mail
merge so that each subset of the data (specifically we're extracting students
that are to be accepted to the Engineering school, and each subset represents a
different field of engineering that they've expressed an interest in) will
receive a slightly different letter.  What we'd like to do is maintain a
seperate database that contain the interest code and the paragraph to be merged
into the leter for that interest code to be held in a memo field in this
database.

Once we get to the point where we copy to a text file, and then convert it to a
WordPerfect mail merge document, we lose the paragraph contained in the memo
field.  It saves first to the text file and then automatically converts to mail
merge format, so I'm not positive which of these two operations causes the
problem, but I suspect it's the former.

Does anybody have a suggestion on how to extract the contents of a memo field
to a text file for subsequent processing into a mail merge.  This is the first
time I've tried something like this, and I've hit a brick wall.  So I'm hoping
the collective net consciousness might have a solution.

Thanks in advance!!!   :-)


Thomas Scott, Systems Manager, College of Engineering
Cornell University, Carpenter Hall Annex, Ithaca, NY  14853
Newsgroups: bit.listserv.dbase-l
From: davec@wsti.demon.co.uk (David Churcher)
Subject: Re: Reading the volume of the hard disk 
Distribution: world
Organization: Welcom Software Technology International
Reply-To: davec@wsti.demon.co.uk
X-Mailer: Simple NEWS 1.90 (ka9q DIS 1.18)
Date: Sun, 20 Dec 1992 14:45:45 +0000

In article <viking.724847729@vincent2.iastate.edu> viking@iastate.edu writes:

>davec@wsti.demon.co.uk (David Churcher) writes:
>
>>>I want to read  the volume of the hard disk using FoxPro 2.0.
>
>> Use the ADIR() function. For example, the following:
>
>> =adir(test, "F:\*.*", "V")
>
>> puts the volume label in the first element of the test[] array.
>
>        What if the volume has no label, like many floppies and hard
>drive are formatted as?

 It returns a blank string in the array element if the volume is
unlabelled.

-- 
davec@wsti.demon.co.uk
From: jrg@doc.ic.ac.uk (James Grinter)
Newsgroups: bit.listserv.dbase-l
Subject: Re: Detection of NULL numeric field
Date: 14 Dec 92 16:56:58 GMT
Organization: Dept. of Computing, Imperial College, Univ. of London, UK
NNTP-Posting-Host: owl.doc.ic.ac.uk
In-reply-to: "Mark W. Schumann"'s message of Fri, 11 Dec 1992 08:48:10 EST

In article <2b289c1c.whizbang@whizbang.wariat.org> "Mark W. Schumann" <mark@WHIZBANG.WARIAT.ORG> writes:

   James Grinter wrote:

   >  if ""=ltrim(rtrim(str(mtemp)))

   Or more simply IF EMPTY (STR (MTEMP))

Ah, but I remember vauguely that dBASE doesn't have EMPTY() in III+.
It has, however, been quite a while and my memory could be lacking on
what is in III+ (not a lot, for certain).

James.
--
James Grinter, c/o Dept Of Computing, Imperial College, LONDON, SW7 2BZ.
Aeval({227406,131304,719166,950732,993440,1364628,1491756,1868584,1235232,;
2151480,2524368,2802876,2769312,2839886,3104325,1824},;
{|x,y| QQout(chr((x%2048)/y)+chr(int((x/2048)/y))) })
From: gcooke@access.digex.com (Gregg Cooke)
Newsgroups: bit.listserv.dbase-l
Subject: dBASE IV 1.5 views and the AppGen
Date: 20 Dec 1992 13:22:56 GMT
Organization: Express Access Online Communications, Greenbelt, MD USA
NNTP-Posting-Host: access.digex.com
X-Newsreader: Tin 1.1 PL3

I'm using the Applications Generator to build a simple two-database
app with a couple of reports and a couple of forms.  Trouble is, I
can't seem to get the AppGen to use a view instead of a database
file for some of the objects in my app.  When I specify a view file
at any of the 'Override assigned ... file' options, the code that
gets generated seems deaf dumb and stupid to half the fields in the
view.  

Also, can anyone tell me where I can find the FAQ for this group?

	-Gregg  (gcooke@access.digex.com
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 11 Dec 1992 13:15:11 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         The Radio Gnome <V2002A@TEMPLEVM.BITNET>
Subject:      Re: Relating Two Databases In Ascending Order

On Thu, 10 Dec 1992 08:18:12 -0500 DON SMITH said:
>> Is there any way to relate two databases on a numeric field but at the same
>> time have a second index active on the database that is being related into so
>> that a character field is listed in alpha order?
>
>My immediate reaction is simply 'No, you can't do that.'  The database being
>related INTO must be indexed on the field used for the relation, and since
>only ONE index can be in force at a time, that would seem to take care of it.
>
>But if someone knows better, I'm happy to be instructed...

     Well you could take a roundabout solution...

1) Sort the secondary datafile in the primary/secondary order that you
want into a temporary file.
2) Index the temporary file only on the primary key (the relational tag)
3) SET RELATION into the secondary file.

     The records in the secondary file will be in the order you want.
(I haven't tried this, but it seems the intuitive way to do it).

                   Andy Wing
Newsgroups: bit.listserv.dbase-l
From: "R.L. Magidson" <wk01682@worldlink.com>
Subject: Re: SIGN ON SCREEN IN DBASE IV ver 1.5
Organization: Performance Systems Int'l
Date: Thu, 17 Dec 1992 16:00:25 GMT
X-Mailer: WORLDLink (3.11)

DBASE /t works for me...

>DATE:   Wed, 16 Dec 1992 17:25:06 CST
>FROM:   Stanton Schmidt <sschmidt@HP.UWSUPER.EDU>
>
>Hi all,
>I just got version 1.5 of dBASE IV.  I am having one problem with it.  In
>the manual it says to use -t, /t, -T, or /T to suppress the sign on screen,
>as in the following format.
>
>dbase -t progname
>
>I have tried it each different way and I still get the same thing as I do
>without the switch.(a screen with my name, company name, serial #, and
>copyright stuff)
>
>could some kind soul tell me what I am doing wrong, or does this thing not
>work as advertised on page 16-2  of the "PROGRAMMING IN dBASE IV" manual.

Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Mon, 14 Dec 1992 16:50:46 CST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         JOHNSON@TWSUVM.BITNET
Subject:      subscribing to the list

Forgive this post to the list please.  Would someone please send me
the information for subscribing to this list.
Thank you for your time and patience.
Brenda F. Johnson
johnson@twsuvm.bitnet
johnson@twsuvm.us.twsu.edu
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 17 Dec 1992 16:41:19 CST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         John G Jay Burrell <jgb1@CC.MSSTATE.EDU>
Subject:      Re: Packing a Database (Clipper 5.01 question)

> I have a question concerning Clipper 5.01.
>
> Question:  How can I pack a subset of deleted records???
>
>            EXAMPLE: I need to pack a group of deleted records within a
>                     range of dates.
>
>            The command I wish clipper offered is:
>                 PACK FOR date>=CtoD('01/01/92') .AND. Date<=CtoD('01/31/92')
>
> Any help is GREATLY appreciated.............
>
>                                 Thanks in advance,
>                                 Brad
>                                 bjs90772usl.edu
>
How 'bout:
        Copy to <new.dbf> for !( date>=CtoD('01/01/92') .AND. ;
                                 date<=CtoD('01/31/92')
                               )
        Erase <old.dbf>
        Rename <new.dbf> to <old.dbf>

Enjoy!


Jay Burrell                    E-Mail: jgb1@CC.MsState.Edu
Computing Center & Services     Voice: (601) 325-7025
Mississippi State University      Fax: (601) 355-8921
Newsgroups: bit.listserv.dbase-l
From: davec@wsti.demon.co.uk (David Churcher)
Subject: Re: Extracting Memo fields 
Distribution: world
Organization: Welcom Software Technology International
Reply-To: davec@wsti.demon.co.uk
X-Mailer: Simple NEWS 1.90 (ka9q DIS 1.18)
Date: Thu, 17 Dec 1992 15:25:38 +0000

In article <DBASE-L%92121512221654@NMSUVM1.BITNET> Tom_Scott@QMRELAY.MAIL.CORNELL.EDU writes:
>Does anybody have a suggestion on how to extract the contents of a memo field
>to a text file for subsequent processing into a mail merge.

 If you don't have the text file open, just

   COPY MEMO yourmemofield TO yourfile ADDITIVE

 If you're using low-level file functions to write to the file (see
 FOPEN(), FPUTS(), FWRITE(), FCLOSE() in the docs):

   = FWRITE( yourhandle, Memofield )

 Dave.

-- 
davec@wsti.demon.co.uk
Newsgroups: bit.listserv.dbase-l
From: viking@iastate.edu (Dan Sorenson)
Subject: Re: Reading the volume of the hard disk 
Organization: Iowa State University, Ames IA
Date: Sun, 20 Dec 1992 10:35:29 GMT

davec@wsti.demon.co.uk (David Churcher) writes:

>>I want to read  the volume of the hard disk using FoxPro 2.0.

> Use the ADIR() function. For example, the following:

> =adir(test, "F:\*.*", "V")

> puts the volume label in the first element of the test[] array.

	What if the volume has no label, like many floppies and hard
drive are formatted as?  I'd use ISDISKIN.PRG, a simple program that
is commonly available, on the drive I was looking for.  It should work
on floppy, hard, and network drives.  At least, it worked for me when
I asked for drive V: instead of B: by typo.  I had a fun time figuring
that one out...

< Dan Sorenson, DoD #1066 z1dan@exnet.iastate.edu viking@iastate.edu >
<  ISU only censors what I read, not what I say.  Don't blame them.  >
<  "This isn't an answer, it's a pagan dance around a midnight fire  >
<   written in intellectual runes." -- Rich Young                    >

Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Mailer: Network Courier V2.1a
Encoding: 13 TEXT
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 17 Dec 1992 11:14:00 LCL
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         PaussaVC@SSD0.LAAFB.AF.MIL
Subject:      Re: boxes around labels

>> I want to create a label file with a box around my labels.  The USING
>> dBASE IV manual tells me on page 12-9 that I can add lines and boxes
>> my labels but the line and box options are not available in the layout
>> menu when creating a label file.  Any ideas on how I can put a box around
>> labels would be appreciated.
Lines and boxes are merely characters in the 128-255 ASCII range of the
IBM PC-8 character set. But my mail administrator has disabled my ability to
shell out from mail, so I can't look them up right now but here's the sitch.
chr(170) ==  chr(179) ==  chr(185) ==  chr(186) ==   etc.
#1 add chr(170) etc. to the label.
#2 choose a PC-8 compatible font on your printer.
#3 print.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 17 Dec 1992 11:37:40 -0500
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Tom Scott <Tom_Scott@QMRELAY.MAIL.CORNELL.EDU>
Subject:      Re: Extracting Memo fields

                                RE>>Extracting Memo fields
College of Engineering                           Thomas Scott - (607) 255-0966
                                                 FAX: (607) 255-9606
                                                 E-mail:
LU7Y@CornellC.cit.cornell
                                                 edu

QM:Tom_Scott@QMRELAY.mail.cornell
                                                 edu
Carpenter Hall Annex_
>Quite some time ago developed a stand-alone program to convert dBase style
>databases to WordPerfect style secondary merge files.  This program is
>available via anonymous ftp at ftp.msstate.edu.  The directory is
>/pub/pc/jgb1/clipper.  There are several files there for the taking.
>The dbf to wpm conversion program is out there as a self-extracting archive
>as well as just zipped.  The file name is dbf2wpm1.exe and dbf2wpm1.zip.
>
>Also available is wpmerge.zip - the Clipper 5.01 object file used to create
>dbf2wpm.exe.
>
>Two other programs are also available: dbu_pll.zip/dbualone.zip and
>dispmemo.zip.  The dbu*.zip files are Nantucket's DBU.EXE that has been
>modified to work on a network with shared databases.  The dbu_pll.zip
>requires the use of RtLink's pre-linked library (PLL) and the dbualone.zip
>is a stand alone version.  The dispmemo.zip is a C program that will
>display the contents of a memory file from the command line.

Well, I've worked out my own procedure to create my WordPerfect-style merge
files using
Fox's "COPY TO..." command and WordPerfect's CONVERT command from within my
FoxPro
programs.  The thing just doesn't work with memo fields though!  It sends a
blank line to the
merge file, rather than the contents of the memo field.  Do any of these
programs address that
issue?  If so, then I'll download it and test it out.  But I need to overcome
this stumbling
block in order for this to work properly.

Suggestions that I have been getting are that I should handle the paragraph
processing at the
WP level.  So I'm investigating that now.  Would anyone like to see my solution
when I come
up with one?  If so, let me know, and I'll post it to the list.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: dbase-l@NMSUVM1.BITNET
Content-transfer-encoding: 7BIT
X-Popmail-Charset: English
Newsgroups: bit.listserv.dbase-l
Date:         Sun, 20 Dec 1992 15:34:14 -0600
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Steve Gillard <gillard@MAILBOX.MAIL.UMN.EDU>
Subject:      RE: Using popup menus for record selection

Here is more information on the popup menu question I posed two days ago
regarding locating and updating records using a popup menu.  I am using
dBase IV 1.5 and the procedures in question follow.


PROCEDURE PopMenu
   SELECT 2            &&  AVACMAIN.DBF
   Mfield = FIELD(3)   &&  last name field in AVACMAIN.DBF
   DEFINE POPUP GetRec FROM 7,58 TO 14,70 PROMPT FIELD &Mfield ;
          MESSAGE "Highlight and Press <ENTER> to make selection."
   ON SELECTION POPUP GetRec DO FindRec
   ACTIVATE POPUP GetRec
RETURN  && (EOP PopMenu)

PROCEDURE FindRec
   GOTO BAR()
   Mlast=&Mfield
   Mssn=Ssn
   LOCATE FOR Ssn=Mssn
   IF FOUND()
      Mname=TRIM(Last)+" "+TRIM(first)
      @ 9,32 SAY Mname      &&  places first and last name on input screen
   ENDIF
   SELECT 1
   SAVE SCREEN TO SavScr
   DEACTIVATE POPUP
RETURN  && (EOP FindRec)

What I would like this section of code to do is select a last name from the
menu and go to another file and bring up information on the person
selected.  Currenly the program is not bringing the correct data from
the person selected up on the screen.  The procedure apparently does not
select and/or search properly.


On Sat, 19 Dec 1992 17:41:00 GMT, Anthony K. Lima wrote:

>Show us your code and tell us what flavor of xBASE you're using.
>-- Tony Lima
Newsgroups: bit.listserv.dbase-l
From: davec@wsti.demon.co.uk (David Churcher)
Subject: Re: Reading the volume of the hard disk 
Distribution: world
Organization: Welcom Software Technology International
Reply-To: davec@wsti.demon.co.uk
X-Mailer: Simple NEWS 1.90 (ka9q DIS 1.18)
Date: Sat, 19 Dec 1992 16:35:59 +0000

In article <921219.092709.SAT.STUP092@SAUPM00.BITNET> STUP092@SAUPM00.BITNET writes:
>I want to read  the volume of the hard disk using FoxPro 2.0.

 Use the ADIR() function. For example, the following:

 =adir(test, "F:\*.*", "V")

 puts the volume label in the first element of the test[] array.

-- 
davec@wsti.demon.co.uk
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU