HDTenEightyP/NetNews huggingface dataset:
From: jfile@bmers3.bnr.ca (Jonathan File)
Subject: Insufficient Memory error in dBase IV
Reply-To: jfile@bnr.ca
Organization: Bell Northern Research, Ottawa, Canada
Date: Mon, 16 Nov 92 15:37:26 GMT

I have a form that has about 35 gets and 35 says complete with
parameters for range, error, message etc.  When the form is displayed,
I get the "Insufficient memory, Press any key to continue" message.  Then
I get the details of the GET line that gives me the trouble.  The thing is,
that I have used the debugger to monitor the memory, and I appear to have
lots.  memory() returns usually 89 or 90.  I can usually fix the problem
when I remove some of the parameters on the GET that gives me the trouble 
(but of course this isn't desirable).  Then when I add some more code
(changes to/more GETS), I get the same message again, but on a different
GET statement.  I am wondering if I need to allocate more memory to the
buckets.  It originally had a value of 2 and I bumped it up to 3, but this
didn't help.  Any suggestions?
-- 
         /                       / /
        /                    ___/_/_
       /  ___  _____    ___    / /__    ___  _____
      /  /   )  /   )  /   )  / /   )  /   )  /   )
 /   /  /   /  /   /  /   /  / /   /  /   /  /   /  __
(___/  (___/  /   (__(___(__/ /   (__(___(_ /   (_  \/
-----------------------------------------------------------------
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: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: Ingres questions followup
Followup-To: comp.databases
Organization: 
Date: Thu, 19 Nov 1992 20:50:24 GMT

In article <5854@osc.COM>, jgk@osc.COM (Joe Keane) writes:
> In article <BxLBKH.2w0@usenet.ucs.indiana.edu>
> mdchaney@fractal.ucs.indiana.edu (M Darrin Chaney) writes:

>>Traditionally, files under VMS are limited to 65534 byte records.  That's
>>because for normal variable length record files, the record length is stored
>>in the two bytes before the record.

> That is so dumb.  What kind of operating system is it?  It looks like a C-64.
> I mean, sometimes you can get away with using less bytes if you're clever.
> But having variable-length fields break when you get to 64KB is unacceptable.
>
> --
> Joe Keane, professional programmer
> jgk@osc.com (uunet!amdcad!osc!jgk)

My, aren't we special.

Files with the 64K byte limit are by no means the only kind of file that
VMS supports, it's just that there are many, many applications for which
this kind of file is very suitable.

Maybe you'd like to rewrite RMS for Digital, and make it so much better?

Don't get me wrong, I'm not saying VMS is perfect, nor that the
filesystem is the best of all possible worlds (in many ways it's kind of
a pain, especially when you're _not_ dealing with simple text files),
but let's not go off the deep end and compare it to a C-64.

C'mon Mr. Professional Programmer, let's show a little tolerance.

--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
Graduate School of Business		yellnet:  (312) 702-0328
University of Chicago			faxnet:   (312) 702-0233
Disclaimer: My opinions are my own and not those of my employer.
Ich bin ein Virus.  Mach' mit und kopiere mich in Deine .signature.

Newsgroups: comp.databases
From: cjh@holmes.acc.Virginia.EDU (Carol J. Hughes)
Subject: Clipper printing deleted material from memo field
Originator: cjh@holmes.acc.Virginia.EDU
Organization: University of Virginia
Date: Mon, 16 Nov 1992 16:37:10 GMT

I wrote a Clipper '87 application that has a help.dbf with two fields:
var C10
helptext M10
The database contains help info in the memo field "helptext"
for various GET fields and menus within the program.
One of the records is used for logging purposes.  The program writes
various info to the field whenever certain actions are taken by
the users.  The supervisor views this info every week and can delete
old info.  She asked for the option of printing the info, so I added
an option to do so.  

Problem:  When I print the info using the function MEMOLINE,
          Clipper includes the text that has been deleted
          but it leaves out the first letter of each line
          that has been deleted.  I don't want any of the 
          deleted info.

I ran a program in 5.01 that Rick Spence suggests in his
second book to get rid of unused DBT blocks but that
didn't help.

If I search help.dbt with NORTON'S, it shows all the deleted
text, including the first letter of each line.  (The report
does not show the first letter of each line of deleted text.)

There is another database in the same system with a memo field.
I deleted the first four lines of the memo text from one of the
records and added new text, then printed a report which shows
the memo text.  The report was fine.  The deleted text did not
show and the new text did.

Does anyone know why the deleted text from the help.dbf is
showing up on the report and how to get rid of it?

Joan Hughes
University of Virginia
cjh@virignia.edu
Newsgroups: comp.databases
From: lindsey@tincup.enet.dec.com (Randy Lindsey)
Subject: Re: File/Record locking in Foxpro 2.0
Organization: Colorado Software Solutions, Inc.
Distribution: comp
Date: Fri, 20 Nov 1992 00:33:22 GMT


In article <MONTY.92Nov16043550@blackhole.lerc.nasa.gov>, monty@blackhole.lerc.nasa.gov (Monty Andro) writes...
> 
>Hello,
> 
>I have a few questions on a group of Foxpro commands that auto lock
>files and records like READ, SHOW GETS, etc ...  These commands lock
>the record or file before executing.  Do these same commands unlock
>the record or file after they complete?  If these same commands unlock
>the record after completion, do all other previously placed locks on
>other records get released in addition to the one placed by the
>command?

Yes, the commands that auto-lock things also auto-unlock them when done.
I think they do the unlock when you move to another record, rather than
when the command itself completes, but I'm not certain.  The documentation
and/or help file talk about this.

If you're using SET MULTILOCKS ON, I think the assumption is that you're
doing your own locking (RLOCK), since the auto-locking would only lock
a single record at a time.  You might get confused or suffer a deadly
embrace by mixing multiple locks with auto-locking, so you'd probably
be best off to lock manually.  And always lock in the same, predictable
order (e.g. lock the parent before attempting to lock the child) so you
can avoid an embrace.

Randy Lindsey
Organization: University of Illinois at Chicago
Date: Thursday, 19 Nov 1992 18:13:36 CST
From: <U23176@uicvm.uic.edu>
Newsgroups: comp.databases
Subject: Clipper lib UI?

I saw a demo recently of a screen builder, UI, for Clipper.  It looks pretty
cool.  Could anyone who has the experience of using this lib tell me its
merits and flaws?  Thanks in advance.
Newsgroups: comp.databases,comp.databases.oracle,comp.databases.sybase,comp.databases.informix,comp.databases.ingres
From: thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040)
Subject: Validating data imported from text files.
News-Software: VAX/VMS VNEWS 1.4-b1  
Organization: NASA/GSFC-Laboratory for Astronomy and Solar Physics
Distribution: usa
Date: Wed, 18 Nov 1992 21:19:00 GMT

I was just told something startling.  In an E-mail message from Myron China
<mryo@ind_maroon.gwl.com>, I was told

   problem with flat file xfers is verifying successful completions of both
   the dump and the import.  oracle products, for instance, always signal 
   a 0 return code whether or not it had a problem.  so you end up spooling
   log files and checking them for errors yourself.  we also check file
   record layouts for validity before anything goes through.

That's an astonishing statement to me!  Our current plan calls for *ALL* data
imported into the database to come from flat ASCII files generated by other
programs.  Populating the database is supposed to be an automatic process that
works unattended.  Problems are supposed to be signalled when they occur.

Is this the same with the other major SQL databases: Ingres, Sybase, Informix?

Bill Thompson
From: jeffs@matt.ksu.ksu.edu (Jeff Smith)
Newsgroups: comp.databases
Subject: Does the -space option work for any Paradox users?
Date: 19 Nov 1992 17:03:31 -0600
Organization: Kansas State University
NNTP-Posting-Host: matt.ksu.ksu.edu

I'm still trying to get better speed performance out of Paradox 4.0.
I have written a very simple application using the workshop.
It only uses 2 tables, and the menu only has 2 options.

It takes about 30 seconds from the time I choose script play
to the time I finally get the menu at the top.

This is on a 25MHz machine.  It is pulling it off of a Novell
network but the newtork load is not very high.

Anyways I heard of messing with the -codepool argument and in
the Paradox User's Guide page 699 it says you can use the
-space option and it will print out its current memory allocation.

This does not happen for me....  It seems like there might be
something that gets flashed on the bottom right corner, but
there is no way to see it.

This very slow performance is sure turning me off of using
Paradox 4.0.  I got 3.5 to run faster!  I think writing my
own pull down menu scripts will be faster than using the
workshop.  I'm going to try writing my own and see if that
is any faster.

I AM ALSO FOR CREATING A PARADOX ONLY NEWSGROUP!!!!  I know
compuserve has one that is suppose to be pretty good.  They 
supposedly even have a bunch of scripts and utilities you 
can get.  I wish we had a Paradox ftp site........


Newsgroups: comp.databases
From: thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040)
Subject: Re: Normalizing 2NF -> 3NF
News-Software: VAX/VMS VNEWS 1.4-b1  
Organization: NASA/GSFC-Laboratory for Astronomy and Solar Physics
Date: Mon, 23 Nov 1992 16:08:00 GMT

In article <1ejt9qINN340@hrd769.brooks.af.mil>, burgess@hrd769.brooks.af.mil (Dave Burgess) writes...
>  While the statement you make in the example is true, you are not adhering to
>the original statement.  The One to One relationship described in Name, Address
>and Phone is not valid for this question.  Phone Number is Fully Functionally
>Dependent on Address, not Name.  Suppose four students share a house, or (a
>military example) 50 airmen share a single barracks.  The phone is only
>transitively dependent on the name.  It is functionally dependent on the
>address.  It is transitively dependent on the name (if it is dependent at all).

On the other hand, when I move from one house to another, then my phone number
moves with me, as long as I stay within the same exchange area.  Also, when I
move into a new house or apartment, I don't get the same phone number as the
previous owner or tenant.  In fact, since it's a long time since my student
days, the dependence on name struck me before your example of the possible
dependence on address did.

Basically, its a bad example.  Phone numbers, in the most general sense, are
only transitively dependent on both the name and address.

Bill Thompson
From: 20lim@gw.wmich.edu
Newsgroups: comp.databases
Subject: NEED: Good advice on Databases PLEASE!
Date: 20 Nov 92 10:03:11 EST
Organization: Western Michigan University

Greeting Netters,
	I need some good advice on databases for DOS.
Here's the Situation:
	I am going to write a database application that will include
inventory control, technical support, probably billing, and other 
database handling routines. I have already written one in dBase IV but I 
am looking for some input on other database applications. What we need 
is mainly :
	fast execution, 
	creates executables (.EXE) files,
	capable of file sharing (ie Novell networks),
	good easy to write in! (I know dBase but I'm willing to learn 
		others)
	handles menus (pulldown / popup /etc)
	can do multiple choice in fields
	and most of all inexpensive.
	PS: dBase can't hack it (no offense)
Currently we are considering Borland's Paradox, and Fox Pro 2.0. Please
E-mail replies on the pros and cons of you suggestions.

Thanks in advance.
Chris.

  __________________________________________________________________________
 /o Christopher Lim              SiGNaTuRe FiLeS aRe aGaiNST MY ReLiGioN  o/@
|o Western Michigan University   ReLiGioNS aRe aGaiNST MY SiGNaTuRe FiLe o|
|o X90LIM3@GW.WMICH.EDU                                                  o|
|o    C:>echo FLAMES > nul         "this space under construction"       o|
 \_________________________________________________________________________\@
Xref: sparky comp.databases:7917 comp.databases.oracle:2232 comp.databases.ingres:1923
From: lynne@hightop.hac.com (Lynne Case)
Newsgroups: comp.databases,comp.databases.oracle,comp.databases.ingres
Subject: Re: I heard a Rumor about Oracle 7 and Forms
Date: 17 Nov 92 18:34:04 GMT
Organization: Hughes Aircraft Company

In article <1711@niktow.canisius.edu>, pavlov@niktow.canisius.edu (Greg Pavlov) writes:
|> In article <1992Nov13.184731.21707@cs.rochester.edu>, zhang@cs.rochester.edu (Zhang Ju) writes:
|> > 
|> > I heard a rumor which goes that the delay of ORACLE 7 is because of its
|> > incompatibility with Forms 3. So Oracle 7 is actually waiting for Forms 4.
|> > 
|>  I wouldn't worry about this too much.  ORACLE uses product release dates as
|>  a marketing tool:  don't buy Brand x because we have a New Improved coming
|>  out that will run circles around it.  As far as I am aware, ORACLE has never
|>  come close to meeting an ADVERTISED release date  - tho it may be meeting
|>  internally-set deadlines, I don't know - and is usually very creative in
|>  the many reasons given (directly and via "rumor") why the release is "delayed"

I agree.  If you waited this long for Oracle 7 you might as well wait a
little longer.  I went to Oracle's corporate office two years ago so they
could tell us all about how great Oracle 7 is going to be.  We have
since won the contract they were trying to sell us version 7 for.  I am
glad that we know better than to listen to the bull**** that comes out of
their marketing department, because our customer might be expecting us to 
actually deliver something with a product that STILL hasn't been released.

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Lynne Case                      || I generally avoid temptation unless 
Hughes Aircraft Co.             || I can't resist it.
e-mail: lynne@mitchell.hac.com  ||              --- Mae West
 phone: (703) 759-1357 or 1256  ||
   fax: (703) 438-8430          ||
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: zt0@carp.cis.ufl.edu (Ziauddin Tamruddin)
Newsgroups: comp.databases
Subject: Multimedia Object storage
Date: 21 Nov 92 23:36:57 GMT
Organization: Univ. of Florida CIS Dept.

This is with regard to multimedia database management systems.
I intend to develop a multiple transactional store for the storage
of multimedia objects. Basically I  would be extending an existing
object-oriented DBMS to incorporate multimedia features. The existing system
does not have a storage manager of its own, it utilises the storage
manager of a relational DBMS (ingres). Infact the system has been
interfaced to the Unix file system and EXODUS storage manager. Now my
objective is to have decomposed multimedia object handling utilising
the interfaces to the storage managers. The idea is to decompose the
multimedia object into components such as image, text  and store these
components in storages better suited to them. This kind of storage
reduces redundancies which is crucial in multimedia information
mangement 

My question is has this kind of decomposed multimedia object handling
been done before, if so could you please give any references in the
literature . I would appreciate if you could give me any suggestions
or ideas in this regard.

thanks in advance

email address zt0@reef.cis.ufl.edu
From: bwalker@sumax.seattleu.edu (Brian T. Walker)
Newsgroups: comp.databases
Subject: Re: I heard a Rumor about Oracle 7 and Forms
Date: 18 Nov 92 07:15:06 GMT
Article-I.D.: sumax.5839
Organization: Seattle University

>PL/SQL V2.  You can't single-task link Forms 3.0.16 to V7 kernels, otherwise
>no problem.
>
>But who uses single-task anyway ;-)
> 
We have been using forms 3.0.16 against Oracle7 for quite some time with no
visible problems.  Since the PL/SQL engine in forms is seperate from the
kernel PL/SQL, you will often find that the versions are different.  We have
not tried some of the PL/SQL 2.0 features in our forms so maybe that could
cause some problems.

bw...


-- 
--------------------------------------------------------------------------
| Brian Walker               |  o | o  | My comments are my own doings - |
| Boeing Computer Services   |   /     |   not my company's              |
| bwalker@sumax.seattleu.edu | (-----) |                                 |
Newsgroups: comp.databases
From: broy@vaxa.weeg.uiowa.edu (Barbara Roy)
Subject: Paradox 4.0 Report bug?
News-Software: VAX/VMS VNEWS 1.41    
Organization: University of Iowa, Iowa City, IA, USA
Date: Thu, 19 Nov 1992 21:48:00 GMT

I have discovered what appears to be a bug in the Paradox 4.0 reports. When
you have a wordwrapped field placed in a group header and no blank line beneath
it, it doesn't wordwrap the field. However,the wordwrap works properly for the 
first page, but not for the first wordwrapped field on subsequent pages if a 
blank line and/or the keyword "BLANKLINE" was left under the wordwrapped field. 
There seems to be no difference when using Annn type fields or memo type fields. 

I am using the wordwrap number of lines as "v" for variable. According to the 
documentation I shouldn't have to place a blank line for each wordwrapped line, 
but that is the only way it works properly. I've tried different combinations 
of blank lines and the keyword BLANKLINE. Sometimes the use of BLANKLINE "fixes"
things for all but that first group header on the page and sometimes I have to
use that blank line to get things to work. 

Anyone have a clue as to what is going on? I've tried about every combination
and permutation I can think of without success. We tested the same report in
Paradox 3.0 and it worked, but it won't in 4.0.

Barbara Roy, University of Iowa, Weeg Computing Center, Iowa City, IA.  52242
Internet:   broy@vaxa.weeg.uiowa.edu or Barbara-Roy@uiowa.edu
Bitnet:     broyva@uiamvs.bitnet  
Disclaimer: My opinions are solely my own and may change daily.
Newsgroups: comp.databases
From: dtodd@titan.ucc.umass.edu (David M. Todd)
Subject: Re: DB Comparison - Revelation/ARev comments
Organization: University of Massachusetts, Amherst
Date: Thu, 19 Nov 1992 20:21:30 GMT


Just a couple of comments:

I chose Revelation in part *because* I needed variable length fields.
Our database has large amounts of text and even if other database
environments could handle them (most won't), we would waste an
incredible amount of space if we were locked into a fixed format.

Granted that Revelation Tech Support is expensive for the "weekend"
developer, but the Forum on Compuserve is very active and I've gotten
a lot of good help there.


|~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ David M. Todd ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
|Department of Psychology, University of Massachusetts, Amherst, MA 01003 USA|
|Phone: 413/545-0158 ___ <DTodd@Titan.ucc.UMass.EDU> _____  Fax: 413/545-0996|
Newsgroups: comp.databases
From: lindsey@tincup.enet.dec.com (Randy Lindsey)
Subject: Re: FoxPro 2.0 requirements
Organization: Colorado Software Solutions, Inc.
Date: Fri, 20 Nov 1992 00:39:50 GMT


In article <csc4213.722098344@gsusgi1.gsu.edu>, csc4213@gsusgi2.gsu.edu (Uncle Remus) writes...
>bj+@CMU.EDU (Brandon Chin) writes:
> 
>>Anyone know what the minimum hardware requirements for FoxPro 2.0 are?
> 
>>Will it run on a 286? (gasp!) How much memory does it need, etc.

Actually, I have a library cataloging application running in Foxpro 2.0 at my
cooperative nursery school on an 8MHz 8088 (!).  With a Seagate 251 (slow 40MB
drive).  It takes a while to start up (40 sec.) including reading a 150-element
unique index into an array for a popup.  But once loaded, it performs quite
well.  You can page up/down in a browse almost instantaneously.  Reindex on
about 500 records takes only 5 seconds or so.  But I don't know how it will do
on much bigger databases.

Randy Lindsey
Newsgroups: comp.databases
From: mr@ogre.cica.indiana.edu (Michael Regoli)
Subject: Re: How About COMP.DATABASES.PARADOX ?
Organization: Indiana University
Date: Wed, 18 Nov 1992 05:19:52 GMT


>How about a comp.databases.dos?  

I'll vote yes; I'm a new Paradox person who is finding an absolute
dearth of Paradox-related stuff on the Internet.  (Archie reports one
solitary "paradox" subdirectory at iskut.ucs.ubc.ca, that contains
only three little (obscure) utilities.)  I'd definitely like to see a
group for Paradox.


However, in the Grand Scheme of Things, it should probably look
something like "comp.databases.ibmpc" from which, if traffic allows:

  comp.databases.ibmpc.dbase    comp.databases.ibmpc.pdox
  comp.databases.ibmpc.foxpro   comp.databases.ibmpc.pcfile


--
michael regoli
mr@cica.indiana.edu
regoli@indiana.BITNET
..{att,rutgers}!moose!cica!mr
Newsgroups: comp.databases
From: rogerg@bluemoon.use.com (Roger Grywalski)
Subject: Anyone using Agility/VB?
Organization: Blue Moon BBS ((614) 868-998[024])
Date: Sun, 15 Nov 92 17:44:41 EST

Is anyone using Agility/VB.  It is a datbase library for Microsoft Visual 
Basic.  I am thinking about purchasing it and would like some advice from
someone how has used it.  Thanks...

 This is from
     rogerg@bluemoon.use.com
who doesn't have his (or her) own obnoxious signature yet
Newsgroups: comp.databases
Subject: R:Base
From: fogal_te@cs0.lamar.edu
Date: 19 Nov 92 13:08:27 CST

Does anyone know of an R:BASE programming oriented public BBS or an area
on Internet that supports R:BASE?
From: glenn@sw.stratus.com (Glenn Butler)
Newsgroups: comp.databases
Subject: Paradox runtime + C++ 3.1, or wait for CA's aspen??
Date: 19 Nov 92 18:43:40 GMT
Organization: Stratus Computer, Inc.
NNTP-Posting-Host: clueless.sw.stratus.com

I currently am using Clipper, and am quite happy with it.  But, at some
time, it will be time to choose the next generation development platform - one
that is windows based and object oriented.

I have the 30 page CA Statement of direction about CA's replacement for Clipper,
the object oriented windows compiler/db system called Aspen.  Aspen looks
amazingly cool, and should be a full replacement for C for windows programming.

But then there's part of me that says "why not use Borlands C++ 3.1 with their
object vision, and use the Paradox Runtime system?"  I'm sure that Borlands C++
and objectvision will be a few generations ahead of the initial release of
Aspen for user interface stuff.

Has anyone switched from Clipper to C++/paradox runtime, or does anyone have
initial impressions about Aspen (which according to CA is in in Beta right now).

Or are there other alternatives that I am missing??

Any info would be great, and I'll post a summary if people are interested...

Thanks,

Glenn
Newsgroups: comp.databases
From: 900752s@dragon.acadiau.ca (JODY SCHOFIELD)
Subject: Paradox Engine
Keywords: Paradox Engine
Organization: Acadia University
Date: Mon, 23 Nov 1992 14:47:34 GMT

	I've been trying to decide if I should purchase Borland's Paradox
Engine.  If anyone has bought this product could you please email me your
opinions?

Thanks,
900752s@dragon.acadiau.ca
jody

Newsgroups: comp.databases