HDTenEightyP/NetNews huggingface dataset:
From: carl.pedersen@dartmouth.edu (L. Carl Pedersen)
Newsgroups: comp.databases
Subject: Job opening at Dartmouth College in New Hampshire
Date: 20 Nov 92 15:12:36 GMT
Followup-To: comp.databases
Organization: Dartmouth College

Senior   Programmer/Analyst
Administrative  Computing 
Dartmouth College 

A Senior Programmer/Analyst is being sought  to fill a 2 to 2.5 year
position.   
Strong preference given to applicants with Oracle DBMS programming
experience, VAX/VMS experience is a plus.  Will consider applicants who can
demonstrate experience in systems design and development with other DBMS. 
Extra consideration will be given to applicants with substantive 
experience programming in  Macintosh based DBMS.    Experience in the
design and development of complex administrative systems required. 
Requires a College Degree with six years of related administrative systems
experience, or the equivalent.   The review of applications will begin on
Dec. 1, 1992 and will continue until the position is filled.   

Please submit resume,  cover letter and approximate salary requirements to
William Barry, Director of Administrative Computing, HB 6209 Clement Hall, 
Dartmouth College, Hanover New Hampshire 03755-3574 .   Dartmouth is an
Equal Employment Opportunity/Affirmative Action Employer.  Women and
minorities are encouraged to apply.
From: ivang@cup.portal.com (Ivan - Godard)
Newsgroups: comp.databases
Subject: Re: How About COMP.DATABASES.PARADOX ?
Date: Mon, 16 Nov 92 17:20:44 PST
Organization: The Portal System (TM)


>>Hello,
>>comp.databses is quickly becoming comp.databases.paradox. But I know there
>>still are many user [as I once was] who dont know where to direct there
>>paradox related articles on UseNet. I would really like to see Paradox have
>>its separate and dedicated forum. I guess Paradox has earned this level of
>>recognition.


Wonderful idea! and while you're at it, please make one for the Clipper
people who are the other major plug on this group.
Newsgroups: comp.databases
From: csc4213@gsusgi2.gsu.edu (Uncle Remus)
Subject: Re: FOXPRO2 - Programming question (Menu & Flow)
Organization: Georgia State University
Distribution: na
Date: Fri, 20 Nov 1992 14:10:13 GMT

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

>Background:

>I created a project with a number of screens. I have a menu created a menu
>using the menu builder. I want the menu to show up with the command
>window. I think I need some sort of busy loop.

The menu is the busy loop. Read more about menu's and their us ein programs. 
Like I said before on this newsgroup, Foxpro2.0 isn't a language you can
jump right into without doing a lot of reading.

Josh Guttman
InterMed Corporation
404-355-0001

j
-- 

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
Organization: University of Illinois at Chicago
Date: Tuesday, 17 Nov 1992 10:37:24 CST
From: Tom Ascher <U15310@uicvm.uic.edu>
Newsgroups: comp.databases
Subject: R&R Report Writer for Paradox???

Anyone have any experience/recommendations on the R&R Report Writer?
I need something I can use with Paradox 4.0 that will allow me to produce
PostScript files, scaleable fonts, etc.  I called R&R and they will have
a new module for their product that allows it to work with Paradox 4.0
(in December).
From: ch966@cleveland.Freenet.Edu (Jose M. Febus)
Newsgroups: comp.databases
Subject: CA-ASPEN
Date: 23 Nov 1992 13:31:02 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA)
NNTP-Posting-Host: hela.ins.cwru.edu


Hi...
	I want to know some info about CA-ASPEN i am plannig to buy
Clipper 5.01, but i want to be sure that i won't lose my money...
Thanks...
-- 
	Jose Febus
	"Drinking at Yagrumo"
Newsgroups: comp.databases
From: viking@iastate.edu (Dan Sorenson)
Subject: Re: FoxPro 2.0 requirements
Organization: Iowa State University, Ames IA
Date: Tue, 17 Nov 1992 05:37:29 GMT

In <8f20M4W00VQjA5sqhV@andrew.cmu.edu> 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.

	I've Foxpro 2.0 running on 8MHz 286's with only 480K free.
It isn't speedy, but it will run on them.  I heartily suggest you
benchmark your application with respect to various machines and let
that be your guide to what hardware to get for that application.

< 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                    >

Newsgroups: comp.databases
From: cschmidt@lynx.dac.northeastern.edu (Christopher Schmidt)
Subject: Re: How About COMP.DATABASES.PARADOX ?
Reply-To: cschmidt@lynx.dac.northeastern.edu (Christopher Schmidt)
Organization: Northeastern University, Boston, MA. 02115, USA
Distribution: world,local
Date: Wed, 18 Nov 1992 17:51:11 GMT

briand@anasaz (Brian Douglass) suggests:
> How about a comp.databases.dos?

mr@ogre.cica.indiana.edu (Michael Regoli) suggests:
> comp.databases.ibmpc.dbase    comp.databases.ibmpc.pdox
> comp.databases.ibmpc.foxpro   comp.databases.ibmpc.pcfile

f67700241@violet.ccit.arizona.edu (Greg Franklin) suggests:
> comp.os.msdos.databases        For discussion of MS-DOS databases.
> comp.sys.ibm.pc.databases      For discussion of databases on IBM PCs.

As someone who looks forward to the migration of popular database
products across operating system, I find all these suggestions most
disheartening.

Christopher Schmidt
Waltham, Massachusetts, USA
cschmidt@lynx.northeastern.edu
Newsgroups: comp.databases
From: les@chinet.chi.il.us (Leslie Mikesell)
Subject: Re: Using memo fields in FOXPRO2 reports
Organization: Chinet - Public Access UNIX
Distribution: usa
Date: Thu, 19 Nov 1992 18:44:33 GMT

In article <BxxGwu.8Ms@acsu.buffalo.edu> birgenom@ubvmsb.cc.buffalo.edu (T.B. Shows/ Maureen Sion) writes:
>I would like to print out a memo field in a report using foxpro 2.0
>is this possible and if so how ?

What's wrong with just adding the field name in the report builder?  Set the
width you want and if you expect it to be larger than one line, set the
"Stretch Vertically" attribute for the field.

Les Mikesell
  les@chinet.chi.il.us
From: elgaard@diku.dk (Niels Elgaard Larsen)
Newsgroups: comp.databases
Subject: Re: Normalizing 2NF -> 3NF
Date: 18 Nov 92 10:08:29 GMT
Organization: Department of Computer Science, U of Copenhagen

villas@ax.apc.org writes:


>Considering the normalization of (A*,B,C), where A -> B, B -> C and A* is
>the PK, I would go with (A*,B) and (B*,C). My reasons are:

>   - If you go with (A*,B) and (A*,C), there no longer exists (or can be
>     implied) the B -> C dependencie, so the set of original dependencies
>     is being modified;

Yes, you lose information (I didn't see that in my last posting).

>   - If you get to BCNF (Boyce-Codd Normal Form), you would also go with
>     (A*,B) and (B*,C), since every "determinant" must be a candidate key
in the SAME relation
>     (in this case, they are the PKs in each relation), but that's not 3FN
>     (as a matter of fact, a step further 3FN).

(A*,B) and (A*,C) are on BCNF
-- 
         Niels Elgaard Larsen          
         Institute of Computer Science,        
         University of Copenhagen      
         E-mail: elgaard@diku.dk 
Newsgroups: comp.databases,comp.os.msdos.programmer
From: clyde@hitech.com.au (Clyde Smith-Stubbs)
Subject: Re: FoxBase to `C' Contract: How much should I ask for? Help
Organization: HI-TECH Software, Brisbane, QLD, Australia.
Date: Wed, 18 Nov 92 12:44:11 GMT

bduncan@ve3ied.UUCP (Bill Duncan) writes:

>>tpradeep@cs.tamu.edu (Pradeep K Tapadiya) writes:
>># So far I used to program on per hour basis. This is the first time
>># I have been asked to bid for a project. I do not how many man-hours
>># this work would involve.

Deciding how long a project will take is often difficult, and can really
only be based on experience, but some good rules of thumb are appropriate
(bear in mind I am talking here about quoting a fixed price up front for
a job, so you've got to cover your derrier):

Firstly, work out the WORST CASE time you think it will take. Then
double that and you should have something approaching how long it will
actually take, Then cost your time at a value you are sure is much more
than you are really worth (this helps allow for the hidden time you
will inevitably spend). If you don't cringe when you write down this
figure, it's too low. By the same token, don't be greedy. If you are in
your first year out of uni you can't expect to charge $150/hr.

My estimate for a GENERIC foxbase to C converter? $150K.

--
 Clyde Smith-Stubbs       | HI-TECH Software,       | Voice: +61 7 300 5011
 clyde@hitech.com.au      | P.O. Box 103, Alderley, | Fax:   +61 7 300 5246
 ...!nwnexus!hitech!clyde | QLD, 4051, AUSTRALIA.   | BBS:   +61 7 300 5235
 HI-TECH Software: C Compilers for all manner of machines
From: ehrlich@andromeda.rutgers.edu (Heyward Ehrlich)
Newsgroups: comp.databases
Subject: Re: How About COMP.DATABASES.PARADOX ?
Date: 16 Nov 92 21:14:03 GMT
Organization: Rutgers Univ., New Brunswick, N.J.

Yes!

Heyward Ehrlich (ehrlich@andromeda.rutgers.edu)
From: ch966@cleveland.Freenet.Edu (Jose M. Febus)
Newsgroups: comp.databases
Subject: Clipper Programmers...
Date: 23 Nov 1992 13:34:04 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA)
NNTP-Posting-Host: hela.ins.cwru.edu


Hi Clipper Programmers...
	I want to know is how do you program your long reports. Do
you spend hour coding long reports or do you use an utility?
Please let me know......
	Thanks...
-- 
	Jose Febus
	"Drinking at Yagrumo"
Newsgroups: comp.databases
From: marti@nugget.inf.ethz.ch (Robert Marti)
Subject: Re: Normalizing 2NF -> 3NF
Organization: Dept. Informatik, Swiss Federal Institute of Technology (ETH), Zurich, CH
Date: Mon, 16 Nov 1992 10:33:34 GMT

In article <1992Nov15.223825.16263@odin.diku.dk>, elgaard@diku.dk
(Niels Elgaard Larsen) writes:
|> bonak@herky.cs.uiowa.edu (Esmail Bonakdarian) writes:
|> >E.g., given a relation with three attributes, A, B, and C, where
|> >attribute A is the PK, the following dependencies exist:
|> >  R(A*  ,B   ,C)
|> >    A -> B
|> >         B -> C
|> >i.e, A determines B, and B in turn determines C.
|> >3NF would split this up into two relations:
|> >  R'(A*,B)
|> >  and
|> >  R"(A*,C)  OR  R"(B*,C)
|> >Which of these two latter relations is the "correct" one according to
|> >the theory? Or does it always depend on the given semantics of the data
|> >being modeled? It seems to me that I've seen both.
|> 
|> Both are correct since both (A,C) and (B,C) are on 3NF. That does of course
|> not mean that they are equally good. Depends on the queries on the database.

[note that I have slightly edited the original posting to conserve space]

In the following, I assume that the functional dependency (FD)
B -> A does _not_ hold, since if it did, no normalization would
have been necessary in the first place.

I haven't been looking at the theory books (Maier, Ullman) in a
loooong time, but the solution with R'(A*,B) and R"(B*,C) is much
better than the other one with R'(A*,B) and R"(A*,C).  Why?  Well,
if you perceive an FD B -> C in the real world, you probably would
like your system to enforce this integrity constraint.  (FDs and
MVDs are really just special cases of integrity constraints.)  The
simplest (and in some systems still the _only_) way to enforce an
FD is to make its left hand side a key for a relation consisting of
the attributes listed on both its left and right hand side.  (In
older SQL-based systems, this has to be done by CREATing a UNIQUE
INDEX for column B of table R".)

-- 
Robert Marti                    |  Phone:    +41 1 254 72 60
Informationssysteme             |  FAX:      +41 1 262 39 73
ETH-Zentrum                     |  E-Mail:   marti@inf.ethz.ch
CH-8092 Zurich, Switzerland     |
Newsgroups: comp.databases
From: tleylan@pegasus.com (Tom Leylan)
Subject: Re: How About COMP.DATABASES.PARADOX ?
Organization: Pegasus,  Honolulu
Date: Fri, 20 Nov 92 05:59:59 GMT

mikef@som.yale.edu (Michael Fanara) writes:

> I think that a seperate group for Paradox would be an excellent idea.  I've
>spent days, that's right days, trying to get through to Borland Tech Support.

>Access to the USENET is a very easy task for me and would prove to be an
>invaluable service to me.

Mike... dividing up comp.databases comes up every so often (there was talk
of a separate "xBase" newsgroup some time back) and I oppose them in
general because the traffic on comp.databases doesn't warrant it.

I don't use Paradox but even if I did (I believe) I would oppose fragmenting
sources of information.  Just using myself as an example (rather than make
up a mysterious "somebody") suppose that I used to use Paradox and that I
know bunches about it but I don't use it any longer.  It isn't likely that
I would bother to read comp.databases.paradox but I would continue to read
messages here.  That means (in my example) that you would lose one source
of potential answers.

In any case, I just noted 14 messages in comp.databases if we divide them
up by product we can have four new newsgroups and average 3.5 messages in
each... but there will be more than that because somebody in .paradox is
going to post a generic question like "what is normalization" and just to
be certain they've asked everybody they'll repeat it in every group.

To make a long story even longer, your posted difficulties with telephone
support won't vanish if .paradox is created, you can post the identical
questions right here.  CIS is a good idea however because you will have
access to many more "users" and Borland also.

tom

Newsgroups: comp.databases
From: boerncke@kirk.fmi.uni-passau.de (Frank-Roland Boernke)
Subject: What is IQL?
Organization: University of Passau, Germany
Date: Fri, 20 Nov 1992 14:45:52 GMT

Hi,

in Database-Lectures I heard about a Database-Language named IQL. It
must be kind of a experimental language with no implementation yet. As
far as I know, it was introduced by Serge Abiteboul. Can anybody tell
me, if this is from interest for nowadays database theory? If yes,
what features make IQL an interesting language?

Thanks in advance,

Frank

-------------------------------------------------------------------------
Frank Boerncke                       ,,,   University of Passau - Germany
boerncke@kirk.fmi.uni-passau.de     (.~.)            phone: +49 0851 2267
--------------------------------oOO--(_)--OOo---------------------------

Newsgroups: comp.databases.theory
From: dc@dcs.qmw.ac.uk (Daniel Cohen)
Newsgroups: comp.databases.theory
Subject: Re: OO Common Data Model - References?
Date: 23 Nov 92 17:17:36 GMT
Organization: Computer Science Dept, QMW, University of London

In <1992Nov13.125110.8842@ida.liu.se> gusfa@ida.liu.se (Gustav Fahl) writes:


>I am looking for references to any work done on using
>an object-oriented common data model in a heterogeneous
>database system (federated DBS, multi-DBS,...).

You may be interested in:
"Query Transformattion for Accessing Heterogeneous Databases" by
Lefebvre, Bernus and Topor which was presented at the workshop on
Deductive Databases after JICSLP92 in Washington DC this month. They
discuss using a deductive object-oriented language to overcome schema
conflicts across relational databases.

The contact addresses are given as:
{ajl,bernus,rwt}@cit.gu.edu.au

Daniel Cohen              Department of Computer Science 
Email: dc@dcs.qmw.ac.uk   Queen Mary and Westfield College
Tel: +44 71 975 5245/4/9  Mile End Road, London E1 4NS, UK
Fax: +44 81 980 6533      ******* Hit the North!!! *******
Newsgroups: comp.databases.theory
From: boerncke@kirk.fmi.uni-passau.de (Frank-Roland Boernke)
Subject: What is IQL?
Organization: University of Passau, Germany
Date: Fri, 20 Nov 1992 14:55:05 GMT


Hi,

in Database-Lectures I heard about a Database-Language named IQL. It
must be kind of a experimental language with no implementation yet. As
far as I know, it was introduced by Serge Abiteboul. Can anybody tell
me, if this is from interest for nowadays database theory? If yes,
what features make IQL an interesting language?

Thanks in advance,

Frank

-------------------------------------------------------------------------
Frank Boerncke                       ,,,   University of Passau - Germany
boerncke@kirk.fmi.uni-passau.de     (.~.)            phone: +49 0851 2267
--------------------------------oOO--(_)--OOo---------------------------
From: weik@PrakInf.TH-Ilmenau.DE (Thomas Weik)
Subject: DOOD '93
Reply-To: weik@PrakInf.TH-Ilmenau.DE (Thomas Weik)
Organization: Technische Universitaet Ilmenau
Date: Mon, 16 Nov 92 10:00:14 GMT

Hi,
does anyone of you guys out there know the dates and place where DOOD '93 will
take place??
Thomas

-- 
_________________________________________________________________________
| Thomas Weik                      |                                     | 
| Institut Praktische Informatik   |                                     |
| TU Ilmenau                       |                                     |
| Postfach 327                     | Tel.: +49-3677-691207               |
| O-6300 Ilmenau                   | Fax:  +49-3677-691201               |
| Germany                          | e-mail: weik@PrakInf.TH-Ilmenau.DE  |
|__________________________________|_____________________________________|

   There is a theory which states that if ever anyone discovers
   exactly what the Universe is for and why it is here, it will
   instantly disappear and be replaced by something even more
   bizarre and inexplicable.

   There is another which states that this has already happened.

Douglas Adams: The Restaurant at the End of the Universe

Newsgroups: comp.databases
From: cjh@holmes.acc.Virginia.EDU (Carol J. Hughes)
Subject: Re: Clipper 5.01 array problem
Organization: University of Virginia
Date: Wed, 18 Nov 1992 16:40:21 GMT

In article <1992Nov17.102200.12123@fwi.uva.nl> timmer@fwi.uva.nl (Ralf Timmer (I89)) writes:
>Hi,
>
>I've got a Clipper 5.01 question about passing array elements by
>reference.
>To manage this I use Straleys :
>
>  #xtranslate @@<exp> => {|x| IF( x = NIL, <exp>, <exp> := x) }
>
>I use this as follows:
>
>  IF aExtra[1,1] != ""
>     @ nRegel++,47 GET aExtra[1,2] VALID Control(@@aExtra[1,2], nX)
>  ENDIF
>
>where Control is like:
>
>  Function Control(Item,X)
>     ...
>     LOCAL nTemp,....
>
>     IF VALTYPE(Item) = "B"
>        nTemp := EVAL(Item)
>     ELSE
>	nTemp := Item)
>     ENDIF
>     ....
>     ...
>     ..
>   RETURN .T.
>
>This works.
>
>But, if I place the above IF..GET..ENDIF in a FOR..NEXT loop, with
>the index of aExtra is the same as the loop counter it doesn't work
>anymore!?
>
>   FOR i:= 1 TO 6
>      IF aExtra[i,1] != ""
>         @ nRegel++,47 GET aExtra[i,2] VALID Control(@@aExtra[i,2], nX)
>      ENDIF
>   NEXT
>
>I get an array boundary error at the EVAL call, why?
>
>
>-- 
>Ralf Timmer                                     Department of Computer Science
>Email: timmer@fwi.uva.nl                        University of Amsterdam
>--

I think the answer to your question is in Nantucket News
Volume 5, Number 3 April/May 1992 on page 22.
There is a similar example there.

Joan Hughes
Newsgroups: comp.databases
Subject: Re: MANY-TO-MANY mess in Paradox!!!
From: david@datamark.co.nz (David Rowland)
Date: Mon, 23 Nov 1992 00:32:05 GMT
Organization: Datamark International Ltd.

In article <Bxzoqw.6xo@ccu.umanitoba.ca> ummalik@ccu.umanitoba.ca (Ijaz Rashid Malik) writes:
>
>Is it just me or does every one is unhappy withg Paradox's way of handling
>many-to-many links. I always end up with extra tables and lots of redundant
>information. In a typical scenerio (sp?), a product can be supllied by
>many vendors and a vendor can suplly many products. When it comes to 
>displaying either side of this info, paradox suggests extra tables and their
>use in the "form" display/generation. It, however, doesnot suggest an
>answer to following problem....
>
>say, from an input screen I am entering info about new products or new
>suppliers. If its products, it can have a variable number of vendors and
>if it is a vendor, there could be a variable # of products for it. How can
>I design an input screen/form that has linked tables on it and handeles
>multiple entries for a given field. I mean I can use Products as master
>form and use vendors as linked embeded form. Now when ever I enter a new
>product, I am not sure how many vendors for this product there will be.
>Could be 0,1, or 10000!!! How can I design an input screen and then table
>which would handle this situation????
>
>Thanks very much for help.
>

This seems to be a problem with your database design.  Try to create a
link database between these two files.

e.g.

Parts              PartSupp           Suppiers
Part Number  ->    Part Number
                   Supplier Code  ->  Supplier Code

If each supplier has their own number, you can add a third field to
PartSupp which contains this number and have an inhouse part number
which is used by the company.

The idea of many to many relationships should be avoided when ever
possible in order to maintain good database integrity for the future.
-- 
| 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.                           |
From: bq035@cleveland.Freenet.Edu (Brian Jepson)
Newsgroups: comp.databases
Subject: Foxpro 2 stuff available via ftp
Date: 21 Nov 1992 11:56:08 GMT
Organization: Case Western Reserve University, Cleveland, OH (USA)
Reply-To: bq035@cleveland.Freenet.Edu (Brian Jepson)
NNTP-Posting-Host: hela.ins.cwru.edu


  Hi all. I just wanted to clue you in as to some of the fine software available
at msdos.archive.umich.edu (uploaded by myself and my good friend, Raphael
Pungin).

  A while ago, Raph wrote an excellent Tetris clone for Foxpro2. This was, to my
knowledge, the first foxpro thing available via ftp. After he had uploaded it,
I noticed that they had created a directory under /msdos/database called
'foxpro.'

   I said to myself, 'this little directory seems a lonely place, with only one
file in it...' 

   So I put some files in it, and now there's more...
foxtris.txt
foxtris.zip     Raphael's most excellent Tetris clone. 100% Foxpro.

message.zip     My program to facilitate SENDing messages across a Novell
                Network (Source & Compiled forms)
slider.zip      My program to demonstrate how to implement a sliding control
                device. It is used, in this example, to control the mouse
		speed. (Source and Compiled forms)
whoami.zip      Based on message, this obtains your Novell Username. (Source
                and Compiled)

also, still in the /msdos/UPLOADS directory:

smartpop.zip    A little thing I wrote that demonstrates an all-purpose routine
                for popping up a list of available database records according
                to whatever field you want. It will limit the records selected
		according to what has already been typed. You get the idea.
		Includes the Oatbran Scroller and a nifty little alert()
		routine. (Source and Compiled)

Anyway, our addresses are in these files, so send us postcards or emails if you
enjoy them!

Coming soon:
Box Magic! A screen which accepts a bunch of text, and however you like it,
puts it in boxes, or cells of boxes. This is pretty useful for help screens,
and anything else you want to look pretty. It has four box styles, including
the mixed single/double help screen title boxes, three alignments, and custom
cell configuration.
-- 
*********************
* "Nothing is true; Everything is permitted" - Hassan i Sabbah *
                                         ***********************
Brian Jepson = iqm229@uriacc.uri.edu || bq035@cleveland.freenet.edu
Newsgroups: comp.databases