HDTenEightyP/NetNews huggingface dataset:
Organization: State University of New York - Central Administration
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 4 Sep 1992 09:02:57 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         EVERETT OGDEN <OGDENEB@SNYCENVM.BITNET>
Subject:      Re: manipulate string fields
              4 Sep 1992 00:07:04 GMT from <amead@S.PSYCH.UIUC.EDU>

Alan Mead wants to convert upper-case strings to lower case but with the
first letter of each word capitalized.  He didn't mention the flavor of
Xbase he's using.

FoxPro 2.0 will do this with the PROPER() function.  I don't know if
dBASE IV, Clipper, etc. have this function.  Most would have the LOWER()
function, which would allow you to force lower case; you could then scan
for any character following a space and capitalize it.

      Everett Ogden    ogdeneb@snycenvm.bitnet
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: DBASE-L@NMSUVM1.BITNET
Content-transfer-encoding: 7BIT
Newsgroups: bit.listserv.dbase-l
Date:         Mon, 31 Aug 1992 14:12:02 +0100
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Fred.deVet@SOFT.IEND.WAU.NL
Subject:      Problem with national characterset in DBASE IV Update V 1.5

The only information about national language support I can find is in the
Installation and Configuration guide, page 2-7 under the heading of
LangTables and AsciiSort.

Hope this helps,

Fred de Vet, Wageningen Agricultural University, Holland
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:         Fri, 4 Sep 1992 08:36:00 CDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         RESLIFPA@OSHKOSHW.BITNET
Subject:      Re: Help needed to interpret Clipper error message

Hi!
        This error occurs if the result of a statement in an IF statement,
WHILE statement or IF() is not a logical value ie. .t. or .f..
        You have not given the actual statements that you wrote, so I
don't know where are you making the mistake.


                                                        -Saad


PS-     I have Clipper 5.01 and this error message IS documented. As a
        general rule if the error message comes in a red box with option
        to QUIT etc. that will be documented
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Nupop-Charset: English
Newsgroups: bit.listserv.dbase-l
Date:         Wed, 26 Aug 1992 08:51:24 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "Stephen M. Barrett" <smb1@CORNELL.EDU>
Subject:      RE:Specifying a record by its number.

In Message Wed, 26 Aug 1992 11:29:00 GMT,
  "P.NEWBY" <S090@cpc865.east-anglia.ac.uk> writes:

>Can a record be copied from one database to another by using its record number
 ?
>
>Database A.dbf - current
>Database B.dbf - containing the record we want to copy.
>
>We can copy records from B into A with APPEND FROM b FOR b_field = 'xyz',
>but how can we copy record number 'n' ?
>
>Pat Newby, University of East Anglia, UK.

appe from A for recno()=6  <- I've done that before
>------------------------------------------------------------------------<
> Stephen M. Barrett  (607) 732-7743h         CIT/IR, Cornell University <
> 323 South Ave.      (607) 254-6462o       sba@cornellc.cit.cornell.edu <
> Elmira, NY  14904                     smb1@postoffice.mail.cornell.edu <
>------------------------------------------------------------------------<
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Organization: State University of New York - Central Administration
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 27 Aug 1992 11:59:31 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         EVERETT OGDEN <OGDENEB@SNYCENVM.BITNET>
Subject:      Re: Just Curious...
              26 Aug 1992 16:45:10 GMT from <weller@OSIRIS.CSO.UIUC.EDU>

Bonnie Weller asked if there is a way to copy the record numbers of
records in a source file over to a target file.  If you mean to put the
source record numbers into a field, rather than having those records
retain their original record numbers, then it's easy.  Before moving the
records, add a numeric field to the source DBF large enough to hold the
largest record number.  I'll call it RecNum.  With the source file in
use, REPLACE ALL RecNum WITH RECNO().  If you're moving the records with
an APPEND, you'll have to add the same field to your target DBF.

      Everett Ogden    ogdeneb@snycenvm.bitnet
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 27 Aug 1992 15:15:00 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "DRCOA1::RGAUTIER" <RGAUTIER%DRCOA1.decnet@DRCVAX.AF.MIL>
Subject:      Clipper File Access in C
X-To:         dbase-l <dbase-l@charly.taclog.af.mil>

                  I N T E R O F F I C E   M E M O R A N D U M

                                        Date:     27-Aug-1992 03:12pm EDT
                                        From:     Rich Gautier
                                                  RGAUTIER
                                        Dept:     02*22  Washington F.O.
                                        Tel No:   (703)521-3812  6054

TO:  Remote Addressee                     ( _DDN!dbase-l@charly.taclog.af.mil )


Subject: Clipper File Access in C

In the Simtel-20 archives, in the TURBOC directory, I believe...

  There is a library of functions for C that will access Clipper DBF and NTX
files.  Before I lost my access to the Internet, I could have told you where
they were....But right now I will have to ask someone else out there to look in
the Simtel archive index and find it.

					Rich
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Via:      UK.AC.UEA.CPC865; 26 AUG 92 11:30:06 BST
Newsgroups: bit.listserv.dbase-l
Date:         Wed, 26 Aug 1992 11:29:00 GMT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "P.NEWBY" <S090@CPC865.EAST-ANGLIA.AC.UK>
Subject:      Specifying a record by its number.

Can a record be copied from one database to another by using its record number ?

Database A.dbf - current
Database B.dbf - containing the record we want to copy.

We can copy records from B into A with APPEND FROM b FOR b_field = 'xyz',
but how can we copy record number 'n' ?

Pat Newby, University of East Anglia, UK.
Newsgroups: bit.listserv.dbase-l,comp.databases
From: schli@cs.tu-berlin.de (Wolfram Schlickenrieder)
Subject: Clipper: Network / Index Question...
Organization: Techn. University of Berlin, Germany
Date: Thu, 27 Aug 1992 09:15:14 GMT


	Hi there...

	I have two (probably simple?) question about indexes:

	- How can I determine wether an index file is still "up to
	  date" / "valid" for a data base or not? E.g., two users use
	  the same dbase & index through the net, user A appends a
	  record and has *not* *yet* issued a reindex command. How
	  does user B know that the index is not up to date?

	- (Same situation as abov. If onuser A eventually *does* issue
	  a "reindex", and thus updating an index which is used by
	  user B as well, is B's index still valid after the
	  "reindex"?

	Any help is greatly appreciated...

	...Wolfram


Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Original_To:  BITNET%"DBASE-L@TECMTYVM.BITNET"
Original_cc:  BURNFIELD
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 3 Sep 1992 09:00:00 CDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         BURNFIELD@UTHSCSA.BITNET
Subject:      RE: ASCII --> DBASE

Maarten,

  I have written a routine very similar to what you are requesting. It's not
extremely sophisticated as this was designed as a 1-shot, get the data into a
dbf file quick, routine. It will handle "labels" of up to 7 lines and assumes
that they are in a single column and each address label is separated by at least
1 blank line. It will also parse U.S. style address lines i.e.
"city, state zip" into separate city, state, and zip fields.

It was written in Clipper, rather than dbase, so you'll need to translate it
into a proper dbase IV program.

If you're still interested, I can e-mail you the source code.

Dean Burnfield
The University of Texas Health Science Center at San Antonio
Internet address: burnfield@uthscsa.edu
Newsgroups: bit.listserv.dbase-l
From: amead@s.psych.uiuc.edu (Alan Mead)
Subject: manipulate string fields
Organization: UIUC Department of Psychology
Date: Fri, 4 Sep 1992 00:07:04 GMT

First, if this is a faq just point me to it.  I am not a DBASE wizard.

My wife has some broken software that exports dbase files but all the 
string fields are forced to upper case.  She can get dbase to *display*
lower case but not alter the fields.

She needs a way to, for any string field, (1) force all characters to lower
case and then (2) force (a) the first char in a field and (b) each char
following a space to UPPER case.

Or, I could do this in 20 lines of Pascal if the exported ASCII file 
identifies the fields (ie, I don't want to perform this operation on
each string firled because some have to remain in uppper case).

Thanks very much. 

-alan mead 
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Mailer: ELM [version 2.3 PL11]
Newsgroups: bit.listserv.dbase-l
Date:         Wed, 2 Sep 1992 13:13:18 PDT
Reply-To:     thamilto@pcocd2.intel.com
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "Tony Hamilton - FES~" <thamilto@PCOCD2.INTEL.COM>
Subject:      Activity Log in dBase IV 1.1
X-cc:         Erik Myhrvol <emyhrvol@pcocd2.intel.com>

Using: dBase IV 1.1 for Unix

Problem:
     Looking for a way to track changes to a database file. For instance,
need a log which might say, "User X modified field NAME of database TEST at
DATE and TIME". Solution could either be a built-in dBase feature, or a
_simple_ algorithm/procedure/function. Do not want to have to manually
implement code to make log entries by checking every single field all of the
time. Any ideas?

Tony Hamilton
thamilto@pcocd2.intel.com

(please CC: reponses to emyhrvol@pcocd2.intel.com - thank you)
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Organization: Borland International
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 3 Sep 1992 13:13:00 PDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Dan Veditz <daniel@BORLAND.COM>
Subject:      Re: Probleme mit Variablen mit Umlauten in DBASE IV Update V 1.5

I hope your English is better than my German, but as I understood
it you had an old program that used to run, and in dBASE IV 1.5
you get a Syntax Error on a variable with a umlauted character
in it that used to parse fine.

The problem is that your LANGTABLES config option is set OFF.

You don't say whether you are using the English version or
the German version of dBASE.  In the English version the
default for LANGTABLES is OFF, in the German version the default
is ON.  If you have no config.db file or there is no explicit
mention of the LANGTABLES setting in it then you will get
the default.

Also the INSTALL program checks the country-code of your
machine and if the CC is 001 (US) then it will set
LANGTABLES = OFF in your config.db

When LANGTABLES are off then you get ASCII collation for
indexes and the only recognized alphabetics are a-zA-Z with
none of the characters > 127 accepted as 'letters'.  If
LANGTABLES are ON then you get the collation and alphabetic
definition built into the file DBASE1.RES which differs from
translation to translation.  For example, the sharp-s character
(chr(225) in codepage 437 and 850) is an alphabetic character in
the German version of dBASE and sorts as if it were 'ss', but it's
just another graphic character in the International English
version and the French version, etc.

Incidentally, if you want more than just the one built in collation
you can call Borland Customer Service or Technical Support and
ask for the "Language Support Disk" for dBASE IV 1.5 -- this
program will replace the language-support tables in your
dbase1.res file with the one you select.  One warning--index files
made with one collation order will be corrupt if modified or used
by dBASE running with a different collation order so be sure to
reindex your files after you switch.  This is also true if you switch
the LANGTABLES or ASCIISORT options on and off (if LANGTABLES is OFF
the ASCIISORT has no effect).

[The language support disk may not be available in the US and I don't
know if we sell it or give it away--I'm just a techie...]

-Dan Veditz
International R&D
Borland International
Newsgroups: bit.listserv.dbase-l
From: weisss@Informatik.TU-Muenchen.DE (Stefan Weiss)
Subject: Online-Database with dBase?
Organization: Technische Universitaet Muenchen, Germany
Date: Fri, 28 Aug 1992 11:39:03 GMT

I want to start an online-database. Since I know the
dBase programming language quite well I'd like to use
dBase IV.
Is there any 'ready' software? What do I need?
Are there any known problems? Are there any Tools, e.g.
for supervising the com-ports?
Any experiences?

Stefan


-------------------------------------------------------
Stefan Weiss           weisss@informatik.tu-muenchen.de
Germering, Oberbayern
Germany                                    IRC: Chagall
-------------------------------------------------------
  Humanitas est, quod reliquit, si omnia oblitus sis.
-------------------------------------------------------
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Mailer: ELM [version 2.3 PL11]
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 4 Sep 1992 19:20:01 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Mak Rusli <grads064@SNOWHITE.CIS.UOGUELPH.CA>
Subject:      Re: window memo fields
              foreman" at Sep 4, 92 11:14 am

>
> I have recently encountered a problem with the @ get memo window <window
> name> read command sequence.  After I enter a windowed memo field (Ctrl
> -Home) and save it (Ctrl-End), dBASE blanks out any surrounding screen text.
> I have tried to save the screen before entering the memo and restore it after
> reading the memo and this has not worked.  Does anyone know of a workaround?
>

I assume you are using dbase IV version 1.1.

You must first define a window specifically for the memo.  Then use
@ x,y GET <var-name> OPEN WINDOW <window-name>.  If the OPEN option is not
included, the content of the memo-field is not displayed, only the memo marker.

I hope this help.  Good luck.

Mak Rusli
Dept. of Computing & Info. Sc.
University of Guelph
Guelph, ONT, N1G 2W1
Canada
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 28 Aug 1992 07:43:00 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "DRCOA1::RGAUTIER" <RGAUTIER%DRCOA1.decnet@DRCVAX.AF.MIL>
Subject:      Simtel address
X-To:         dbase-l <dbase-l@charly.taclog.af.mil>

                  I N T E R O F F I C E   M E M O R A N D U M

                                        Date:     28-Aug-1992 07:41am EDT
                                        From:     Rich Gautier
                                                  RGAUTIER
                                        Dept:     02*22  Washington F.O.
                                        Tel No:   (703)521-3812  6054

TO:  Remote Addressee                     ( _DDN!dbase-l@charly.taclog.af.mil )


Subject: Simtel address

Simtel-20 archives are stored at many locations and mirror sites.
However, the address I like to use best is rigel.acs.oakland.edu.
Check the /pub/msdos/turboc and related directories.
					Rich Gautier
					rgautier%drcoa1.decnet@drcvax.af.mil
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Via: uk.ac.southampton; Fri, 4 Sep 1992 15:48:05 +0100
X-Mailer: ELM [version 2.3 PL11]
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 4 Sep 1992 15:41:49 BST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "I.Bowes" <I.Bowes@SOUTHAMPTON.AC.UK>
Subject:      Re: manipulate string fields

Dear All,

I have come across the same problem regarding string case manipulations
and have found that there is a shareware program on SIMTEL20 that can
do all the appropriate manipulations, on any given DBF file.

The file can be obtained from the PD:<MSDOS.DBASE>RECAP21.ZIP

Cheers,

Mr Ian Bowes
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:         Wed, 26 Aug 1992 07:26:13 -0500
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         DON SMITH <DSMITH@INDYVAX.BITNET>
Subject:      Re: Specifying a record by its number.

> Can a record be copied from one database to another by using its record
> number ?

> Database A.dbf - current
> Database B.dbf - containing the record we want to copy.

> We can copy records from B into A with APPEND FROM b FOR b_field = 'xyz',
> but how can we copy record number 'n' ?

Pat -
With Database B current, you can say:
   current_rec = RECNO()
   COPY TO temp WHILE RECNO() = current_rec
   USE Database A
   APPEND FROM temp

This is fairly long-winded, I know.  The ideal brief syntax would be if you
could say (with Database A current),
   APPEND FROM b WHILE RECNO() = ...something...

That MIGHT work, but I would have to try it to be sure.  But you CAN use
RECNO() to specify a scope...

Don Smith
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Original_To:  BITNET%"DBASE-L@TECMTYVM.BITNET"
Newsgroups: bit.listserv.dbase-l
Date:         Sun, 23 Aug 1992 00:06:00 CST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         UBAC@MTECV1.BITNET
Subject:      RE: Setting up Paths

You may consider this aproach:

-Suppose this directory structure
  C:
  |
  +---DOS
  |
  +---DBASE
      |
      +---MISC
      |
      +---APPL1
      |
      +---APPL2
      .     .
      .     .
      +---APPLn

-Create a batch file in the DBASE directory:
 DBASES.BAT
       if %1. == . goto aaa
       c:\dos\subst f: c:\dbase\%1
       goto bbb
       :aaa
       c:\dos\subst f: c:\dbase\misc
       :bbb
       DBASE
       c:\dos\subst f: /d

-Include the next instruction in your CONFIG.DB
    default=f

-Append this statement to your CONFIG.SYS and reboot in order to
 make it work.
    lastdrive=f

-That's All


If you want to work in APPL1 your call to dbase will be:
  C:\DBASE>DBASES APPL1

And if you don't want any particular APPLn then your files will
be in MISC.
  C:\DBASE>DBASES
  C:\DBASE>DBASES MISC


Of course, you will change those paths (DOS,DBASE, MISC, APPLn) and
drive letter (f:) to the ones that make sense in your computer.


I hope this help.
___________________________________________________________________

ENRIQUE CAZARES                          UBAC@MTECV1.BITNET
I. C. S.
UNIVERSIDAD DEL BAJIO
LEON, GTO.
MEXICO
___________________________________________________________________
Newsgroups: bit.listserv.dbase-l
From: weller@osiris.cso.uiuc.edu (Bonnie Weller)
Subject: Just Curious...
Organization: University of Illinois at Urbana
Date: Wed, 26 Aug 1992 16:45:10 GMT

While reading the post 'Specifying a record by it's number' reminded
me of a situation I ran across once and was never able to solve.

Can you, when adding records to a database, copy over the record
number as well?  There was a situation when I would have liked to use
the record number as the key identifier in the new file I was
creating.

Also, is there a way to make a query file into a database file using
dbase 3+?  I used to do it all the time in Dbase 4 (from the pull
down menu.  I now try to use dot commands.  Lesson hard learned) but 
in my new job I have Dbase 3+ and am uncertain of all its capabilities. 
I can't find this solution in my documentation.

Thanks in advance

Bonnie
From: s187318@alfred.carleton.ca (Bing Wen ~{NB1y~})
Newsgroups: bit.listserv.dbase-l
Subject: Help needed to interpret Clipper error message
Keywords: clipper, error, message
Date: 4 Sep 92 12:24:39 GMT
Organization: Carleton University

I have difficulty returning from the data-entry screen to the
mainmenu. The error message looks something like this:

          Error BASE/1066 Argument error: conditional
                          Quit?

I checked my CLIPPER5 user's reference manual but found no
interpretation of such an error message.

The program, which runs without that problem on dBase III Plus,
consists of the following parts:

                    Mainmenu
                  1. enter data
                  2. retrieve data
                  3. utilities


I placed two conditions in the data-entry .prg:

        if either the title or issue number fields are empty
        .....
        return

        ...

        if no change needs to be made on the entry screen        
        then append blank
        replace .... with ....
        ......
        return       


Help replies via email or direct posting are appreciated.

Bing
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:         Thu, 3 Sep 1992 12:49:00 CDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         RESLIFPA@OSHKOSHW.BITNET
Subject:      Re: ASCII --> DBASE

Hi!
        If you are using Clipper, you can use the FOPEN, FREAD functions
to read in the text file and then use SUBSTR, AT, LEFT, RIGHT etc to parse
the string. After that store them to a database.

        If you have Clipper 5.0, this comes with some sample PRGs. One of
them is fileio.prg.  This has functions that use FREAD, FOPEN etc but
it is easier to use them with text files.  If you installed Clipper with
default settings these should be in clipper5\source\sample directory

                                                peace
                                                -Saad Ahmad
From: dflynn@aludra.usc.edu (Daniel Flynn)
Newsgroups: bit.listserv.dbase-l
Subject: dBASE Archive
Date: 31 Aug 1992 04:13:49 -0700
Organization: University of Southern California, Los Angeles, CA
NNTP-Posting-Host: aludra.usc.edu

I am looking for a site that has an archive of UDF and written code for 
applications... I have looked at SIMTEL20 and mirror site (such as wuarchive.
wustl.edu), but haven't found the type s of tyhings I am looking for. Does
anyone know of such a site?

Dan Flynn
dflynn@aludra.usc.edu
Mailer: Elm [revision: 66.36.1.1]
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 3 Sep 1992 13:44:22 EDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Cliff Green <green@UMDNJ.EDU>
Subject:      Re: Clipper: Backup/Restore routines for BIG files...

>    Has anyone out there done that before from within a
>    Clipper application (without using "run backup ..." of
>    course)?
>
There's an excellent version of this (in S87, but you could update
it, I'm sure) called PER_BACK/PER_REST.  You can probably find it
in a zipfile called PER.ZIP.  I know it's on the BOSS bbs
(201-568-7293 for the public line), but it may be on a bbs near
you.
Briefly, it will span as many disks as it needs, labelling each
disk in sequence, and adjusting to the size of the disks you use.

c
--
Clifford Green               Internet:   green@rwja.umdnj.edu
Academic Computing Services     voice:   908-463-4436
UMDNJ-RWJMS                       fax:   908-463-5252
#include <fineprint.h>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU