HDTenEightyP/NetNews huggingface dataset:
X-Envelope-to: DBASE-L@NMSUVM1.BITNET
X-VMS-To: IN%"DBASE-L@NMSUVM1.BITNET"
Newsgroups: bit.listserv.dbase-l
Date:         Tue, 1 Sep 1992 13:12:00 CDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         RESLIFPA@OSHKOSHW.BITNET
Subject:      Re: Clipper: Backup/Restore routines for BIG files...

Hi  !
        Try the following algorithm

1-      Use DBSTRU function to get the structure of the database into a
        2-D array --- aStru := DBSTRU()
2-      Use DBCREATE to create a database from aStru to the disk in the
        drive where you want to backup the file
3-      Go to top of the file you want to backup and start copying 1 record
        at a time to the target drive
4-      Use RECSIZE and DISKSPACE to see if the records can be copied.
5-      if there is not enough DISKSPACE ask to change disk and loop

Note:   For step 3 you can calculate how many records can be copied first
        and then copy all of them

        if you use this method each backup disk will have a valid DBASE
file which you can play with and also writing the RESTORE function will
be easy --- just append all the files together

Suggestion:     To keep track of the sequence of disks you could create
a file on the disk with name like eg. dbbknnn with nnn meaning the disk
number --- JUST A SUGGESTION.

                                                Good Luck
                                                Saad Ahmad
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 4 Sep 1992 11:14:13 CDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         steve foreman <C223468@MIZZOU1.BITNET>
Subject:      window memo fields

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?
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Mon, 31 Aug 1992 13:36:30 EDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         SBA@CORNELLC.BITNET
Subject:      Re: Specifying a record by its number.

My mistake, I believe the second option was better.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 27 Aug 1992 13:09:58 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Lou Tinaro <TCTINAL@VCCSCENT.BITNET>
Subject:      Clipper & C

>>>     Tony Butler <abutler@ARIEL.DEMON.CO.UK> asked:
>>>     Does anyone know how to get C to use Clipper Database
>>>             and index files.

The inexpensive way of doing this is to get a copy of the
file structures and write your own code.  A good source of
this information is the book:
                CLIPPER: Programming Guide
                          by Rick Spence
This book has all of the file structures you need and some
examples of C code that do some database functions such
creating a database, listing a database, and NTX (Clipper)
or NDX (dBase) index use.

If you do this for a living and time is money, you may want
to invest in a good dBase/C library.  The one I am aware of
(but have not used) is CodeBase 4.5 by SEQUITER Software.
This costs between $250 and $300, but is probably set up to
duplicate most of the xBase commands that you are used to.
An extra benefit of CodeBase is that it works with C++ and
will allow you to program under Windows.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Lou Tinaro                          BitNet
Tidewater Community College    TCTINAL at VCCSCENT
Va. Beach, VA   23456
U.S.A.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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, 4 Sep 1992 08:29:15 -0500
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         DON SMITH <DSMITH@INDYVAX.BITNET>
Subject:      Re: manipulate string 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.

I have encountered this same problem, trying to make up for the vagaries of
someone else's data entry.  So (for dBASE IV), I wrote a CAPFIRST() UDF to
solve the problem.  As someone else pointed out, FoxPro (also DataEase) has a
PROPER() function that does much the same thing, but mine is ever so slightly
improved...

The syntax for use would be
   USE database
   REPLACE ALL firstname WITH CAPFIRST(firstname)

Enjoy (or better yet, improve...) - Don Smith

CUT HERE
-----------------------------------------------------------------------------

FUNCTION capfirst
PARAMETERS fldname

* --- Function to return a properly capitalized name

PRIVATE propname, prefix, suffix, n, m, i

propname = LTRIM(TRIM(fldname))        && Remove leading, trailing spaces
propname = UPPER(LEFT(propname, 1)) + LOWER(SUBSTR(propname, 2))

* --- Propname is now correct in 90+ % of the cases
* --- Deal now with all the detectable exceptions I can think of:
* ---    multiple words, McDonald, O'Neal
* ---      punctuation  .,-/&(  without spaces
* --- Undetectable exceptions include:
* ---    MacDonald (could be names like MACKIE or MACHINE)
* ---    Initials with no periods (INB)
* ---    Roman numerals (Don Smith III)
* ---    Certain names (DeLa Mare)

i = 1
DO WHILE i <= 9
* --- Test for a different punctuation mark each time
   DO CASE
   CASE i = 1
      punct = ' '
   CASE i = 2
      punct = '.'
   CASE i = 3
      punct = ','
   CASE i = 4
      punct = '-'
   CASE i = 5
      punct = '/'
   CASE i = 6
      punct = '&'
   CASE i = 7
      punct = '('
   CASE i = 8
      punct = 'Mc'
   CASE i = 9
      punct = "O'"
   ENDCASE

* --- Capitalize the first letter after each occurrence of punct (if any)
   suffix = propname
   prefix = ''
   m = LEN(punct)
   n = AT(punct, suffix)

   DO WHILE n > 0 .AND. n < LEN(suffix) - (m-1)
      prefix = prefix + LEFT(suffix, n+m-1)
      suffix = UPPER(SUBSTR(suffix, n+m, 1)) + SUBSTR(suffix, n+m+1)
      n = AT(punct, suffix)
   ENDDO

   propname = prefix + suffix

   i = i + 1
ENDDO

RETURN propname
From: vanloon@cwi.nl (Maarten van Loon)
Newsgroups: bit.listserv.dbase-l
Subject: ASCII --> DBASE
Date: 2 Sep 92 07:18:55 GMT
Organization: CWI, Amsterdam

Hello netters,

Here is a somewhat strange question:

I want to convert a address list from ASCII (actually I have it
in WP) to a dbase record structure. I have "records" like

   M. van Loon
   Vogelenzangsweg 42
   2111 HS Aerdenhout

All records consists of three lines and have the
same structure. In dbase I want them to be represented
like:

   name    : Loon
   prefix  : M. van
   street  : Vogelenzangseweg
   number  : 42
   zipcode1: 2111
   zipcode2: HS

Note that the prefix consists of capitals, separted by periods,
eventually followed by words like "van", "van de" etc. which
do not contain capitals.

My question is: how can I change my address list into a dbase
file?
Has anybody done this before, or does anybody know a (simple)
solution? Please email me or respond to this group,

Thanks in advance,

Maarten
--------------------------------------------------------------------
| Maarten van Loon      |  The easiest answers are the most        |
| CWI, P.O.Box 4079     |  difficult to find                       |
| 1009 AB Amsterdam     |                                          |
| The Netherlands       |  ----------------------------------------|
| email: vanloon@cwi.nl |  Not knowing Bach = not really living    |
--------------------------------------------------------------------
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Via:      UK.AC.UEA.CPC865; 28 AUG 92 17:42:44 BST
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 28 Aug 1992 17:42:00 GMT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "P.NEWBY" <S090@CPC865.EAST-ANGLIA.AC.UK>
Subject:      Re: Specifying a record by its number.

Thanks for all the replies to my question:

>Subj:	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.
----------------------------------------------

I had tried   APPEND FROM b FOR recno() = 5     but got "no records added".

Several replies suggested that this should work, but it doesn't. So I then
looked in the the dBASE IV manual (though I'm using III+). The manual explains
why it doesn't work, in III+ or IV:

	The value returned for the RECNO() function in the statement
			APPEND FROM newdbf FOR RECNO() = 100
	is the next available record number in the current database file, not
	the record number in the FROM database file. In this example, a record
	is appended only if the current database file has exactly 99 records.

And ... the record appended is always the first one from 'newdbf'.

We will use the approaches suggested by several people, of:
	copy to temp
	...
	append from temp
or
	select A
	...
	select B
	append blank
	replace field1 with A->field1
	...

Thank you for your interest.

Pat Newby, University of East Anglia, UK
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Organization: Research Foundation OF SUNY
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 4 Sep 1992 07:55:31 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Joel Saunders <RJFS@SNYCENVM.BITNET>
Subject:      Re: manipulate string fields
              4 Sep 1992 00:07:04 GMT from <amead@S.PSYCH.UIUC.EDU>

The FUNCKY lib for Clipper has a function that can do what you need.  It has
numerous other functions that will undoubtedly be helpful to you in the future.

Disclaimer:  I have no connection to this software with the exception of being
a satisfied user.

You can purchase the library from any of the PROGRAMMER .... stores.

HTH ..... Joel Saunders
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Nupop-Charset: English
Newsgroups: bit.listserv.dbase-l
Date:         Wed, 26 Aug 1992 12:08:17 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 07:26:13 -0500,
  DON SMITH <DSMITH@INDYVAX.BITNET> 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 -
>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

OK, yes there are better ways to do this including the WHILE clause and
such.  I must say that I replyed to a generic message.  People should say
what they are using and the best help would come from fellow users.  I would
never consider appending from another database for 1 record, especially if
the source database was large.  If I were to do such a thing I would do the
following with Fox(/Microsoft) products:

sele b
goto <recno()>
scatter to temp
sele a
appe blan
gather from temp

There are even faster ways than that.  The append from for recno()= might be
a good solution for appending a specific record from an ascii file but with
Fox we better ways to do that also.


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                     smb1@postoffice.mail.cornell.edu <
>------------------------------------------------------------------------<
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Tue, 1 Sep 1992 10:12:14 MDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         agonzale@NMSU.EDU
Subject:      RE: Clipper: Backup/Restore routines for BIG files...
X-To:         DBASE-L%NMSUVM1.BitNet@pucc.PRINCETON.EDU
              1 Sep 1992 11:49:59 GMT <9209011156.AA24497@argon>

I use to use the normal DOS backup program from within my
Clipper app's. But I kept having problems when Clipper's runtime
kept running out of memory. Also, the the backup program
that comes with DOS is rather limited. Now I'm using
cpbackup from PC tools. I am very happy with it. It is
fast and it compresses your files.

--------------------------------- * -----------------------------------
Agustin Gonzalez-Tuchmann                    Graduate student
Dept. of Computer Science                    dbase-l list owner
New Mexico State University                  Office: SH-131
P.O. Box 30001, Dept. CS                     Phone: (505) 646-6229
Las Cruces, N.M. 88003-0001                  e-mail: agonzale@nmsu.edu
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Original_To:  BITNET%"DBASE-L@NMSUVM1.BITNET"
Original_cc:  DSMITH
Newsgroups: bit.listserv.dbase-l
Date:         Tue, 25 Aug 1992 16:11:00 -0500
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         DON SMITH <DSMITH@INDYVAX.BITNET>
Subject:      RE: 2 "easy" questions

Question #1

        . CDate=date()
        . ? CDate
          MM/DD/YY

                how can i lose the "/"s in the previous output line?
                i.e., i want just MMDDYY.

Answer #1 - you can't, unless you do something horribly clunky like...
   . ? LEFT(DTOC(Cdate), 2) + SUBSTR(DTOC(Cdate), 4, 2) + ;
       RIGHT(DTOC(Cdate), 2)

Question #2

                how can i create a procedure such that

        Fill018 produces  18 zeros,
        Fill200 produces 200 zeros?

Answer #2 - use the built-in RELIPCATE() function -
   REPLICATE('0', 18)  ==>>  '000000000000000000'

Don Smith
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Mailer: PCElm 3.01 (1.3 gt)
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 28 Aug 1992 10:24:48 GMT
Reply-To:     abutler@ariel.demon.co.uk
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Tony Butler <abutler@ARIEL.DEMON.CO.UK>
Subject:      Re: Clipper & C
X-To:         DBASE-L@tecmtyvm.mty.itesm.mx

In message <9208271844.AA29283@carinN> Status: U
>
>
>                   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
>

Thanks, it would help a lot, though if you had the address of the Simtel
archives, I could probably ftp there myself. The domain name may well be
enough, or, preferably the IP address in case my server doesn't know of
Simtel.

Regards,


   Tony.


 ----------------------------------------------------------------------------
| Tony Butler                           Internet: abutler@ariel.demon.co.uk  |
| Surrey,                                 TCP/IP: 158.152.8.125              |
| England.                               Fidonet: Anthony Butler @ 2:250/408 |
 ----------------------------------------------------------------------------
From: BURNFIELD@UTHSCSA.BITNET
Newsgroups: bit.listserv.dbase-l
Subject: RE: Help needed to interpret Clipper error message
Date: 4 Sep 92 14:19:00 GMT
              dialects" <DBASE-L@NMSUVM1.BITNET>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Original_To:  BITNET%"DBASE-L@TECMTYVM.BITNET"
Original_cc:  BURNFIELD

Bing,

If the suggestions that others have made to your problem don't eliminate the
error, then you might want to send a short message containing the syntax of
the conditional statement that is blowing up to the list.

Dean Burnfield
The University of Texas Health Science Center at San Antonio
Internet address: burnfield@uthscsa.edu
Xref: sparky bit.listserv.dbase-l:879 comp.databases:6391
From: michaelh@g2syd.genasys.com.au (Michael Haldey)
Newsgroups: bit.listserv.dbase-l,comp.databases
Subject: Re: Clipper: Network / Index Question...
Date: 28 Aug 92 00:12:54 GMT
Organization: Genasys II, Sydney, Australia

In article <1992Aug27.091514.933@cs.tu-berlin.de> schli@cs.tu-berlin.de (Wolfram Schlickenrieder) writes:
>
>	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?
>

Actually, you can't. But if you issue dbCommit() call before doing something
important, Clipper run-time system updates b-tree indexes. 

>	- (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"?
>

The same idea. Issue dbCommit(). Actually, Clipper, despite an opportunity 
to write network applications, is a single-user system. This is inherited 
from xBases and can not be reliably solved in not client-server systems. 
 [ Another idea is to organise a form of communication between processes. 
   I've got a number of solutions for that so e-mail if you are interested.]

>	Any help is greatly appreciated...
>
>	...Wolfram

My 0.02
Michael
-- 
Michael Haldey  |  Genasys II Pty Ltd
                |  13th Level, 33 Berry St, North Sydney, NSW, Australia
                |  Phone:    +61-2-954-2878 (-9930 FAX)
                |  Internet: michaelh@g2syd.genasys.com.au
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Mailer: PCElm 3.01 (1.3 gt)
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 27 Aug 1992 14:52:12 GMT
Reply-To:     abutler@ariel.demon.co.uk
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Tony Butler <abutler@ARIEL.DEMON.CO.UK>
Subject:      Clipper & C
X-To:         DBASE-L@tecmtyvm.mty.itesm.mx

Does anyone know how to get C to use Clipper Database and index files.

I have written an application in Clipper, but now my company wants it
done in C (Borland C), and I want to still use the current data-set.

Regards,

   Tony.


 ----------------------------------------------------------------------------
| Tony Butler                           Internet: abutler@ariel.demon.co.uk  |
| Surrey,                                 TCP/IP: 158.152.8.125              |
| England.                               Fidonet: Anthony Butler @ 2:250/408 |
 ----------------------------------------------------------------------------
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Wed, 26 Aug 1992 08:16:33 EDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         BENH@NIHRRLIB.BITNET
Subject:      Re: TIME CALCULATION

|Date: 8-26-92  8:13am
|From: benh:ncrr-lib:nih
|  To: DBASE-L@NMSUVM1:BITNET
|Subj: Re: TIME CALCULATION
|In-Reply-To: Message from DBASE-L@NMSUVM1:BITNET of 8-24-92
------------------------------------------------------------------
Thanks to Mr. Schmidt.

-Ben Hope


>What would the code be to give a valid amount of time when total hours
>and total minutes is given?
>
>Example:  elapsedH = 2     (elapsed hours)
>          elapsedM = 130   (elapsed minutes)
>
>I need elapsed minutes to be a normal value between 0-60 and elapsedH to
>be incremented accordingly.
>

 STORE elapsedH + int(elapsedM/60) to elapsedH
 STORE mod(elapsedM,60) to elapsedm

Hope this helps.

--
Stanton W. Schmidt
University of Wisconsin-Superior
sschmidt@uwsuper.edu
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-Path: <johnboyd@ocdis01.oc.aflc.af.mil>
X-Orig-Date: Tue, 1 Sep 1992 11:49:59 GMT
X-Orig-From: Wolfram Schlickenrieder
             <schli%CS.TU-BERLIN.DE@TECMTYVM.MTY.ITESM.MX>
X-Orig-Message-Id: <9209011203.AA29655@ocdis01.oc.aflc.af.mil>
Newsgroups: bit.listserv.dbase-l
Date:         Tue, 1 Sep 1992 08:17:15 -0500
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         "John Boyd;LAHDI;" <johnboyd@OCDIS01.OC.AFLC.AF.MIL>
Subject:      Re: Clipper: Backup/Restore routines for BIG files...
X-To:         DBASE-L%TECMTYVM.BITNET@ucbvax.Berkeley.EDU
X-cc:         DBASE-L%TECMTYVM.BITNET@ucbvax.Berkeley.EDU

In your message of  1 Sep 1992 at 0703 CDT, you write:
> 	Hi there...
>
> 	I'm stuck: I wanted to write a backup & restore routine for an
> 	application I wrote before, but I have got a few data bases
> 	which are HUGE (2-4MB) and therefore won't fit on a single
> 	disc. Has anyone out there done that before from within a
> 	Clipper application (without using "run backup ..." of
> 	course)?
>
I have seen (somewhere) in the past a routine which used the diskspace and
recsize functions to copy x number of records to sequential floppies for
backup purposes.  The advantage to this approach is that the records are
still accessable from the backup directly.  Don't know if this (or what)
would work if you're backing up to tape tho'.
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Apparently-From: Soaf1!woodb!jbpackman
Original-To: dbase-l@tecmtyvm.mty.itesm.mx
Newsgroups: bit.listserv.dbase-l
Date:         Wed, 2 Sep 1992 09:48: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:      Mulit-User Applications on Lantastic
X-To:         dbase-l@tecmtyvm.mty.itesm.mx

Has anyone had any experience (good or bad) with dBASE IV (ver 1.1 or 1.5)
multi-user applications using a LANTASTIC peer-to-peer LAN.

Thanks,

Joel Packman
jbpackman@ssa.gov
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Wed, 26 Aug 1992 09:56:32 CDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         John G 'Jay' Burrell <jgb1@CC.MSSTATE.EDU>
Subject:      RE:Specifying a record by its number.

> 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

One suggestion here... go to that record first (GOTO 6) then use the
WHILE clause (append from A WHILE recno()=6). The FOR clause will search
each and every record looking for a match.... could take a little time
on large databases!

Jay Burrell               jgb1@CC.MsState.Edu
Computing Center
Mississippi State University
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU