HDTenEightyP/NetNews huggingface dataset:
From: david@datamark.co.nz (David Rowland)
Subject: Re: HELP: Loading text file to FoxPro database
Date: Mon, 9 Nov 1992 02:37:32 GMT
Organization: Datamark International Ltd.

In article <50990003@hpsgm2.sgp.hp.com> thwaites@hpsgm2.sgp.hp.com (Damien THWAITES) writes:
>
>I have an ASCII text file that contains one field from a database per line.
>As there are 20 fields in each record, there are 20 lines in the file for
>each record. I want to load this text file into a FoxPro database with
>the same number of fields (20) per record.
>
>How can I read this text file into a FoxPro database ? I tried using the
>APPEND FROM command but FoxPro loaded each line of the text file as a
>separate record. I need FoxPro to place each of the 20 lines into the
>corresponding database record field. Any pointers are much appreciated !!
>
One of the easiest ways to change ascii files, believe it or not, is
by using Qbasic which comes with MS-DOS 5.  This package is not used
to its full potential by alot of programmers which is a shame.  Once I
got use to it, I was using this package to format files etc alot
faster then appending them to a database and using foxpro or clipper.

An example program would be as follows:

OPEN <old file> FOR INPUT AS #1
OPEN <new file> FOR OUTPUT AS #2

:LOOP
    A$=""
    FOR N=1 TO 20
        INPUT #1, B$
        A$=A$+B$
    NEXT
    PRINT #2, A$
    IF NOT EOF(1) THEN GO TO LOOP
 
CLOSE #1, #2

NOTE: I Dont have Qbasic available and wrote the above program from
memory.  It might have to be changed a bit but this should be easy.
The end result would be a new file with one line per record.

I have also been asked a similar question to this one before and
discovered the file in question was infact a RTF file.  If this is the
case, a simple APPEND FROM <file> TYPE RTF will do the trick.
Likewise, try to discover the format for the ascii file and see if
foxpro can append from that format.

Good Luck.



-- 
| David Rowland       | The British are using New Zealanders.  They must |
| Datamark Intl Ltd   | really mean business !                           |
| Wellington          |      -  General Rommel During Northern African   |
| NEW ZEALAND         |         Campaign WWII.                           |
Newsgroups: comp.databases
From: nkolluru@mcs213a.cs.umr.edu (THE DEADLY DEVIL)
Subject: Re: OODB recommendation needed
Date: Fri, 6 Nov 1992 05:47:43 GMT
Organization: University of Missouri - Rolla

In article <1992Nov5.140729.16137@iti.gov.sg> leeshyan@iti.gov.sg writes:
>Hi, 
>       We need to use a data base in our Smalltalk/V project on a PC.  Can anyone on the net
>recommend any OODB that you may have heard of or have experience on ?  If a relational
>database is easily adapted to be used in our Smalltalk environment, it can be considered too.
>
>       Would appreciate it if the contact address and prices of the databases can be obtained.
>
>       Thanks in advance.
>
>Please reply to leeshyan@iti.gov.sg
>
>Lee Shyan
>


The OODBMS GEMSTONE works well with Smalltalk. It is sufficiently rugged 
and is easy to use for Smalltalk programmers. The GEMSTONE-Smalltalk 
interface is graphical and similar to the Smalltalk user interface.

Nookaiah V. Kolluru

Newsgroups: comp.databases
From: thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040)
Subject: Re: dbase III+ vs. dbase IV
News-Software: VAX/VMS VNEWS 1.4-b1  
Organization: NASA/GSFC-Laboratory for Astronomy and Solar Physics
Distribution: usa
Date: Thu, 12 Nov 1992 20:47:00 GMT

In article <BxMAuz.EKs@borland.com>, Cy Shuster <cy@borland.com> writes...
>In article <1992Nov10.134148.7092@ecsvax.uncecs.edu>, dgm@ecsvax.uncecs.edu 
>(Debby Morley) writes:
>> 
>> I am curious as to why so many people have held onto and prefer dbase III+
>to
>> the newer dbase IV.  Can someone please summarize the differences in these
>> two (DOS) products for me?
> 
>BIAS ALERT: I work for Borland, on dBASE IV.
> 
>The most useful distinction today is in the amount of resources each
>requires: III+ works fine on systems all the way back to XTs; IV works best
>on newer systems. III+ can run on floppy-only systems; IV requires a hard
>disk. 

That's interesting--I had no problem upgrading from dBASE III+ to dBASE IV on
an 8 MHz XT.  It did take more time to load up than dBASE III+, but I don't
recall that the application was any slower.

>Many people held on to III+ when IV came out back in '88 because of many
>problems with the first release. But since then, there's been dBASE IV 1.1
>and now 1.5, released in February this year by Borland. III+ was first
>released in '85, practically the Bronze Age of microcomputing -- and people
>wonder why it doesn't support extended memory!
> 
>If you are new to dBASE, and have a 286 or better machine and a couple of meg
>free on your hard disk, I recommend dBASE IV: there have been major
>improvements that make life easier for both the first-time user as well as
>the experienced programmer. I see many comments from people on our CompuServe
>forum who are coming over from III+ and find using the menus in the Control
>Center they can easily create applications. If money's tight or your disk is
>full, go for III+: you can upgrade later on, and both your data and your
>programs will be compatible (the IV language is almost 100% a superset of
>III+).

My impression was that the Assistant in dBASE III+ was actually more intuitive
than the control center in dBASE IV.  However, I was writing my own
application, and bypassing both the Assistant and the Control Center, so it
didn't matter to me.  I did run into one true bug with dBASE IV (the first
release) which I was able to program around.  We went with dBASE IV because we
needed to have more files open simultaneously than dBASE III+ allowed us.  My
client has since upgraded his AT&T 8088 machine to a 486, and is quite happy
with the way dBASE IV does disk caching.

At the time dBASE was "it"!  If I had to do it today, though, I might choose
something else to do it in.  I don't know--its been some time since I've done
any database programming.

Bill Thompson
Xref: sparky comp.databases:7736 comp.databases.theory:606
From: ab@dcs.ed.ac.uk (Albert Burger)
Newsgroups: comp.databases,comp.databases.theory
Subject: Re: 001 Benchmark
Date: 10 Nov 92 12:58:53 GMT
Reply-To: ab@dcs.ed.ac.uk (Albert Burger)
Organization: Department of Computer Science, Edinburgh University

In article <1992Nov8.185842.19152@newstand.syr.edu> socrates@npac.syr.edu (Socrates Costicoglou) writes:
>Can anybody provide details of 001 Benchmark (Cattel & Skeen).

For a start, their paper in TODS may help:

	Cattell, R.G.G. and Skeen, J.
	"Object Operations Benchmark"
	ACM Transactions on Database Systems, Vol.17, No.1, March '92, pp. 1-31

A.
+----------------------------------------------------------------------------+
|   Albert Burger, University of Edinburgh, Department of Computer Science   |
|    JCMB #1410, The King's Bldgs., Mayfield Road, Edinburgh EH9 3JZ, UK     |
|  Phone: +44 (31) 650-5165, Fax: +44 (31) 667-7209, Email: ab@dcs.ed.ac.uk  |
+----------------------------------------------------------------------------+
From: filippone@evax.gdc.com
Newsgroups: comp.databases
Subject: clipper5.01 for sale
Date: 5 Nov 92 21:48:31 GMT
Organization: General DataComm, Middlebury CT

For Sale:  Clipper 5.01, Summer 87, Autumn 86, Rick Spence book for 5.0, and
Occhigrosso book for 5.0 (both with source disks)  $ 350.00.
From: thwaites@hpsgm2.sgp.hp.com (Damien THWAITES)
Date: Sun, 8 Nov 1992 10:53:33 GMT
Subject: Re: RFI: HOLOS and Holistics ...
Organization: HP Singapore Notes-Server
Newsgroups: comp.databases


Holos combines EIS and DSS features into one system with links to
operational data in Oracle, Ingres & Rdb. You can contact 
Holistic Systems at:

6766 S.Revere Pkwy., Ste. 100
Englewood, CO 80112

Tel: 800-624-8266; 303-790-7939
Fax: 303-790-7522


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Damien Thwaites                           Tel    : (65) 279-8947
Information Technology Department         Email  : thwaites@hpsgm2.sgp.hp.com
Hewlett-Packard Singapore                 Fax    : (65) 279-2862
1150 Depot Road, SINGAPORE 0410.          HPDesk : Damien Thwaites /HP3200/09
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Newsgroups: comp.databases
Subject: Help!-searching FOXPRO string fields
From: <JBC103@psuvm.psu.edu>
Date: Thu, 12 Nov 1992 10:07:03 EST
Organization: Penn State University

We are currently evaluating FOXPRO (for DOS-I don't think windows version is
out yet).  One problem we're having is searching alphanumeric (string) fields.
We want to be able to match part of the field, ie. if the field contains
the words "Student address list" we may want to search for every record with
the word "address".  In Paradox, we would search for "..address..", but we
haven't been able to find a similar function in Foxpro.  Any help would be
appreciated.


 John Carnicella
From: lotter@cc.und.ac.za (Eddie Lotter)
Newsgroups: comp.databases
Subject: Re: Clipper 5.01 warning.
Date: 12 Nov 92 12:06:17 GMT
Article-I.D.: cc.lotter.110.721569977
Organization: University Of Natal (Durban)
NNTP-Posting-Host: pc17.cc.und.ac.za

fletcher@saxon.UUCP (Edward F Eaglehouse) writes:

>The first, if you are are not using SET EXCLUSIVE ON, is that the file you
>are printing to will be locked when you try to read it.  Unless you close it
>with the SET PRINTER TO command beforehand.  The low level file functions
>Clipper provides do not give any way to open a file in shared mode, and I
>would guess that the same is true of the redirection functions (SET PRINTER
>TO and SET ALTERNATE TO).

No, I'm not trying to read the file I'm writing to.

>The second problem, and what is the most likely source of what you are
>experiencing, is that the file you are writing to is buffered.  Trying to
>use MemoRead() to read the file that may not be completely written will not
>yield the results you wanted.  I presume you are using these functions to
>write a report that a user can scroll through.

No again. I'm simply writing to a temporary text file to give the user
the option of saving to a file they specify, or print it.

Basically I did something like the following:

Set Printer to PRINT.TMP
Set Device to Printer

/* various @y,x say 's here. */

cTextFile := "DSR" + LTrim( Str( Dsr->DsrNum, 5, 0 ) ) + ".TXT"
cText := MemoRead( cTextFile )

etc...

At this point cText will continually receive "" instead of the actual
contents of the text file, which *does* exist and *does* have a few
lines of text.

Now horror of all horrors, I took Tom's advice and wrote the bare
bones necessary to reproduce the problem and (you guessed it!)
no problem! It worked fine.

So I immediately suspected I had a handle problem, but a quick
check for the number of handles available put paid to that idea.
I am still trying to find what else could possibly be influencing
this simple bit of code to the extent that it does not work.

I'll have to get back to you when (if?) I get to the bottom of it.
Cheers
Eddie                                              lotter@cc.und.ac.za
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Most people ask for happiness on condition. Happiness
can be felt  only if you  don't set  any  conditions.
- Arthur Rubenstein
Newsgroups: comp.databases
From: csc4213@gsusgi2.gsu.edu (Uncle Remus)
Subject: Re: Foxpro2 & 10 Meg memory & DrDos - How best to configure?
Organization: Georgia State University
Distribution: na
Date: Fri, 13 Nov 1992 01:05:25 GMT

derwin@mach2.wlu.ca (Daryl Erwin) writes:

>I was wondering what people thought would be the best way to configure my
>machine. 

>Size of Expanded? Size of Extended? Sizoe of VDISK? Etc 

Leave it all alone. Just run foxpro (X). I uses protected mode and can access
all memory. It also handles disk caching. 


Josh Guttman
InterMed Corporation

-- 

Uncle_Remus - 404-355-0001   "Yeah, I've heard of Internet" - GSU User Services
       "I tried safe sex once, but I couldn't remember the combination" - Me
  "If you're gonna rock the boat, make sure you know who owns the ship" - Me
csc4213@gsusgi2.gsu.edu, Uncle_Remus, The Remulater, Josh, Guttman, Anton_Levey
Newsgroups: comp.databases
From: pbarone@x102a.ess.harris.com (barone philip 00309)
Subject: Mismatched dBase IV Memo fields
Date: Wed, 11 Nov 1992 17:56:33 GMT
X-Newsreader: Tin 1.1 PL4
Organization: Harris ESS, Melbourne, Fla.


   Has anybody experienced a problem with dBase IV that looks like
   the memo field for a record has been lost and another is in its
   place. It is like the Block Pointer Value is pointing to the 
   wrong Block in the .dbt file. 

   I have had this problem a couple of times in two different programs.
   I have reindexed and packed, not much else to do, the data in question
   to no avail.

   Is there a utility that is available that can fix this type of 
   problem.

--
============================================================================
Phil Barone                  \       Internet:  pbarone@x102a.ess.harris.com
Harris Corporporation GISD    \
Cape Canaveral A.F.S.          \
407-730-2199                    \
============================================================================



Newsgroups: comp.databases
From: ifenton@crc.ac.uk (I. Fenton)
Subject: Re: Clipper Internal error 1210?
Organization: MRC Human Genome Resource Centre
Date: Fri, 6 Nov 1992 13:35:50 GMT

In article <92310.100239U23176@uicvm.uic.edu> U23176@uicvm.uic.edu writes:
>I have a database file with more than 80000 records and 15 indexes. I make
>sure that all 15 indexes are active everytime I update the database and
>the said indexes are being reindexed every night. When we append records to the
>database, it works fine; but whenever we update a field which is a key to one o
>f the indexes, it sometimes gives us Internal error 1210. I tried setting order
>to 0 and i thought it worked but yesterday same thing happened. Our application
>is running in Novell LAN environment.  Please help!!!! I'm very desperate about
>fixing this problem.  Thanks in advance.

ok here goes... these answers are from a help list of internal errors i've got

ie1210 means record not found in index.  it should only occur if the database
is updated without the index being open.  it could be a buffering problem
where the disk is not 100% up-to-date with the latest index changes.  one
comment says that on novell you should mark all your dbf and ntx files as
shareable read/write.  novell 3.x has a habit of buffering at the
workstation files not marked this way.  if a user changes a index field
and another uses tries immediately after to access it then 1210 can occur.

also remember to set buffers to 8 in your workstation's config.sys file.

good luck, and keep in touch !

=============================================================================
IAIN FENTON                             | All errors of spelling, grammar &
Institute of Medical Genetics           | fact are due to a missing <Del> key
University of Wales College of Medicine |====================================
Heath Park                              | "No man should marry until he has
Cardiff  CF4 4XN                        |  studied anatomy and dissected at
U.K.                                    |  least one woman" - de Balzac
=============================================================================
Voice = +44 - 222 - 744049   | In 1912, Jack Johnson, the first black world
Fax   = +44 - 222 - 747603   | heavyweight boxing champion, was refused
Email = fenton@uk.ac.cardiff | permission to board the Titanic because of
   (or) wmgif@uk.ac.cardiff  | his colour.
   (or) ifenton@uk.ac.crc    |
=============================================================================

Newsgroups: comp.databases
From: jfile@bmers3.bnr.ca (Jonathan File)
Subject: Help: How can I page a dBase report on my screen?
Reply-To: jfile@bnr.ca
Organization: Bell Northern Research, Ottawa, Canada
Date: Mon, 9 Nov 92 15:24:32 GMT

When I use the Control Center in dBase IV and I select the report I
want, then select Print Report, then select View report on screen,
the report is presented to me on my screen.  After a the screen is full,
I get a message that says: "Cancel viewing: ESC, Continue viewing: SPACEBAR".
This is great, but How can I get the same effect when I use the REPORT
FROM command directly in my own program?  If I start the same report
using the REPORT FROM command, it just scrolls on by.  I can't get it
to pause after a screen full.  I tried ON PAGE AT LINE 20 wait "Press
any key to continue", but it didn't have any effect.  I see that there
is an ON PAGE AT LINE xx in the report code, so this one seems to override
the one that I have set (as I recall this did work if I commented out the
ON PAGE AT LINE xx in the report code, but this isn't the best solution
and dBase was still able to do it without this code commented out).  I 
also tried _pwait = .t. and _plength = 20.  This solution only worked when 
I actually sent the report to the printer (which is what I am trying to
avoid in the first place).

Since dbase can do it from the Control Center, I presume it can be done,
but I can't figure it out.  I would appreciate any pointers one might
have.

Thanks,
         /                       / /
        /                    ___/_/_
       /  ___  _____    ___    / /__    ___  _____
      /  /   )  /   )  /   )  / /   )  /   )  /   )
 /   /  /   /  /   /  /   /  / /   /  /   /  /   /  __
(___/  (___/  /   (__(___(__/ /   (__(___(_ /   (_  \/
-----------------------------------------------------------------
Jonathan File                            Bell-Northern Research 
                  <insert standard       P.O. Box 3511, Station C
                   disclaimer here>      Ottawa, Ontario
jfile@bnr.ca                             Canada K1Y 4H7
-----------------------------------------------------------------
Newsgroups: comp.databases
From: jfox@vms.macc.wisc.edu
Subject: Re: Paradox 4.0 speed (?)
Organization:  University of Wisconsin Academic Computing Center
Distribution:  world
Date: 11 NOV 92 16:03:26    

In article <tim.5.721094115@tim.src.utah.edu>, tim@tim.src.utah.edu (Tim Ma) writes...

> 
>>>An inquiry to all users of Paradox 4.0 out there.  We recently upgraded to 
>>>4.0 after reading articles and ads that highly touted the improved speed of
>>>Paradox 4.0 (claims that it was much faster that FoxPro 2.0).   I am 
>>>impressed with some of 4.0's new features, but SPEED is does not seem to be
>>>one of them.  I have a simple script written in 3.5 that randomizes the order
>>>of records in a file.  All it does it import that file as a single TEXT 
In our experience on 45 80386 computers Paradox 4.0 is much slower than 3.5 
with 2MB RAM. Borland techsupport now says 4 MB minimum, and I noticed the 
new ads don't say 2 MB recommended. On most 4 MB computers 4.0 is somewhat 
slower than 3.5. The codepool option can get some of the speed back. 
On all our 8 MB machines 4.0 is faster than 3.5, though nowhere near 10 times 
as fast for anything we do. All the above is true even after converting all 
DBs to 4.0 format. Memo fields are nice and so are the secondary indexes,
but unless you have lots of RAM, don't buy 4.0 for speed.
Newsgroups: comp.databases
From: viking@iastate.edu (Dan Sorenson)
Subject: Re: FP 2.0 DELETE FILE on a LAN
Organization: Iowa State University, Ames IA
Date: Sun, 8 Nov 1992 09:35:25 GMT

v125qmam@ubvmsb.cc.buffalo.edu (Ami R Pflugrad) writes:

>	Im wondering what will happen if a user issues a 
>	DELETE FILE F:\Foxpro2\MyJunk\Foo.DBF while
>	another user was using F:\Foxpro2\MyJunk\Foo.DBF 
>	in his/her current workspace. This would be under a NOVELL Lan.

	The file will not be deleted (as per the DOS command) because
the other user is reading it.  If you have EXCLUSIVE access, it can be
deleted as your other user won't even be reading from it.  If both of you
have the file open without EXCLUSIVE access you can SET MULTILOCKS ON and
delete (the Fox way) all but the record they're reading, and delete it
later if you want.  Perhaps something that deletes all files with
reccount()<2?

< 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                    >
From: someday@hardy.u.washington.edu (Scott Johnson)
Newsgroups: comp.databases
Subject: Re: Changes in Advanced Revelation from 1.16 to 3.0
Date: 12 Nov 92 07:43:17 GMT
Article-I.D.: u.1992Nov12.074317.10382
Organization: University of Washington, Seattle

In article <1dr68jINNqd7@crcnis1.unl.edu> price@helios.unl.edu (Chad  Price) writes:
>dtodd@titan.ucc.umass.edu (David M. Todd) writes:
>
>>Mike Stramba asked me the following in response to my posting
>>mentioning that I had just upgraded from Revelation 1.16 to 3.0.  I
>>thought I'd post my response on Comp.databases to see if others have
>>any comments:
>
>>POSITIVE:
>...
>>+ mouse capability (since 2.??, but much more fully implemented in
>>3.0)  
>
>Yes .. a very LARGE improvement in functionality.
>
>>PAINT has been improved and works very well with the mouse.
>
>Screens are now much faster and easier to paint. Good improvements here.
>...

FWIW, the screen painter was 100% redesigned and rewritten from scratch.

>In looking at the 30 pages of instructions for conversion, I get the feeling
>that they left a LOT of bugs in the conversion process in their haste to get it
>out the door, and are going to rely on hand conversion of much that should be
>automated. 
>
>Overall rating: 3.0 is a better product, but the conversion process (programs
>and hand-conversion) it terrible!
>
>--
>chad
>price@helios.unl.edu
>cprice@molecular.unmc.edu

There are some patches to the upgrade process and a 3.01 upgrade to the 
main product available on the Revelation CompuServe forum.  Or give tech
support a call, they can get them to you.

Scott Johnson
getting paid money to write programs by,
but not any kind of spokesman for,
Revelation Technologies, Inc.
Xref: sparky comp.databases:7734 comp.os.msdos.programmer:10455