HDTenEightyP/NetNews huggingface dataset:
From: jordan@warped.pnl.gov (Randy Jordan)
Newsgroups: comp.databases.theory
Subject: Re: New Model
Date: 13 Jan 93 00:14:05 GMT
Article-I.D.: oracle.1993Jan13.001405.24006
Reply-To: jordan@warped.pnl.gov (Randy Jordan)
Organization: Battelle, Pacific Northwest Laboratory


In article <1993Jan7.183127.1418@iscnvx.lmsc.lockheed.com>, myoung@force.ssd.lmsc.lockheed.com writes:
|>Path: pnl-oracle!ogicse!clark!spool.mu.edu!agate!stanford.edu!kronos.arc.nasa.gov!butch!iscnvx!news
|>From: myoung@force.ssd.lmsc.lockheed.com
|>Newsgroups: comp.databases.theory
|>Subject: New Model
|>Message-ID: <1993Jan7.183127.1418@iscnvx.lmsc.lockheed.com>
|>Date: Thu, 7 Jan 93 10:31:27 PST
|>Article-I.D.: iscnvx.1993Jan7.183127.1418
|>Sender: news@iscnvx.lmsc.lockheed.com (News)
|>Reply-To: myoung@force.ssd.lmsc.lockheed.com
|>Organization: LMSC, Sunnyvale, California
|>Lines: 58
|>
|>I read the latest trade magazines on the subject of new distributed
|>processing technology and ATM.  They are close, but haven't quite gotten
|>it as far as it should be.
|>
|>The current client server applications work just fine with the current
|>networking systems.  The issue here is replacing the client server model
|>with the semantic data model, and whether the replacement can be
|>accomplished without some virtual path network technology.
|>
	I think I would object to a database paradigm tied to a network
	protocol layer.

|>We want the data base theoreticians to include virtual path networks into
|>their model.  Hopefully they will begin to see that a traditional router
|>or bridge, is simply an index on some class; that a shortest path is simply
|>a semantic reduction.  Then they can begin to think about the network 
|>management issue in terms of semantic theory; and conversely, think about
|>the virtual path networks as a connectionist machine.
|>
--

	Communications methods change faster than the ether that blows it,
	when ATM is superseded (read obsolete) so will your database schema.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
	To Thyne Own Self be true...
	                             myne opinions are.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: sandahl@byron.u.washington.edu (Bonnie Sandahl)
Newsgroups: comp.databases.theory
Subject: - Normalization - Naming Conventions Question -
Date: 12 Jan 93 17:59:18 GMT
Article-I.D.: shelley.1iv0tmINNafn
Reply-To: sandahl@u.washington.edu
Distribution: world
Organization: University of Washington, Seattle
NNTP-Posting-Host: byron.u.washington.edu


I have a question involving database normalization.   Let's say you create a 
CUSTOMER   table for Accounts Receivable with CUSTOMER-NO as the 
primary key.  Let's go on and say that you have a VENDOR table for Accounts 
Payable with VENDOR-NO as the primary key.

Suppose you have a high percentage of customers that could also be vendors 
and you   didn't wish to keep separate tables. You decided to create a table 
called CUSTVEND with primary key CUSTVEND-NO that would have all entities 
that could be customers or vendors.

In the Accounts Receivable system when you set up an INVOICE table, would 
you call the  key attribute CUSTVEND-NO or CUSTOMER-NO?  Similarly, in the 
Accounts Payable system   when you set up a PAYABLE table would you call 
the key attribute CUSTVEND-NO or   VENDOR-NO?

Thanks - sandahl@byron.u.washington.edu
Newsgroups: comp.databases
From: durai@ortta.umn.edu (Durai Venkatasubramanian)
Subject: Re: UDF problem in FoxBase+
Organization: U of Mn
Date: Sat, 9 Jan 1993 02:09:27 GMT

In article <1ikr8sINN5bq@mizar.usc.edu> lapworth@mizar.usc.edu (Bill Lapworth) writes:
>From: lapworth@mizar.usc.edu (Bill Lapworth)
>Subject: UDF problem in FoxBase+
>Date: 8 Jan 1993 13:21:32 -0800
>
>* I'm playing with FoxBase+ without a manual (it's coming, but not too
>* soon!) and I can't get a UDF to work in the valid clause.
>*
>* If I run the following code, I get a 'file not found' error message
>* upon exiting the get
>
>height = 100.0
>@ 0,0 clear
>@ 3,1  say "Height in CM: " get HEIGHT valid isok(HEIGHT)
>read
>cancel
>
>function isok
>    parameter value
>return iif( value > 150, .F., .T. )
>
>* I tried moving the UDF isok to it's own .prg file and added the following
>* line at line 1: set procedure to c:\spiro\isok
>* This time I got the error message 'No parameter statement found'
>
>* Anybody got any clues?
>
>
you should set procedure to the program calling the function isok.

For example, if function isok is called by program, say, callprg, then the 
first line of the program callprg should be (in your case, the program where 
you have defined height = ...) "set procedure to callprg".

set procedure to callprg
height = 99
get height valid isok(height)
read

function isok
 parameters value
return something
From: rscott@vineland.pubs.stratus.com (Richard Scott)
Newsgroups: comp.databases
Subject: Re: MS Access Optimization
Date: 4 Jan 93 14:46:20 GMT
Organization: Stratus Computer Inc, Marlboro MA
NNTP-Posting-Host: attila.pubs.stratus.com

A couple of people suggested that memory was the problem.  It was.  I cut my  
RAM disk down to 512K and made myself an 8Mb permanent swap file (someone  
subsequently suggested that I turn virtual memory off, but virtual memory was  
already off when I had the problem).  Now things are running at a good clip.   
So I didn't have to take any of the other measures.  (BTW, I am using Norton  
Desktop.)  Thanks for the advice.
-----
Richard Scott
Stratus Computer, Inc.
rscott@vineland.pubs.stratus.com
From: someday@hardy.u.washington.edu (Scott Johnson)
Newsgroups: comp.databases
Subject: Re: Arev 3.02?
Date: 8 Jan 1993 16:52:47 GMT
Organization: University of Washington, Seattle
NNTP-Posting-Host: hardy.u.washington.edu

In article <1525@blue.cis.pitt.edu> jjast7+@pitt.edu (James   J Alles) writes:
>
>Please clarify - I have 3.01 with patch #4.  Haven't seen 3.02 on
>compu$erve.
>-- 
>
>Peace, JA
>--
>But Officer, my car doesn't GO that fast!  alles@med.pitt.edu

CLARIFICATION: I was wrong!  Actually 3.02 should be ready Real Soon
Now.  Sorry about that.  I need to pay more attention to what the
other hand is doing around here...  :)

-Scott Johnson
 (fortunately!) not a spokesman for
 Revelation Technologies, Inc.
Newsgroups: comp.databases
From: twombly@goethe.credtech.com (chris twombly)
Subject: Re: Zip code data base wanted
Keywords: zip code, data base
Reply-To: twombly@credtech.com (chris twombly)
Organization: Credit Technologies Inc.
Distribution: usa
Date: Mon, 4 Jan 1993 16:05:00 GMT

In article <1992Dec31.135907.4829@pinet.aip.org> danny@pinet.aip.org (dan_eikenberry) writes:
>In article <106@timer1.UUCP> john@timer1.UUCP (john) writes:
>>Our company is looking for a postal zip code database. We are willing
>>to pay for a resonable price for it. It will be better if we can
>>get updated if any change is made.
>>John Chan
>
>Well I don't have a name/address of where to get one, but I do know of
>one.
>There is a PC based packed (it might be called zipkey, but don't quote
>me
>on that).  From what I remember of it, you can look up by zipcode or
>by town name or partial town name, etc..  It seemed quite complete.
>I believe that the author offers yearly updates.  You can probably
>find this program in any relatively large Public Domain/Shareware
>catalog
>and order a trial copy of it.  Paying the registration fee (very
>reasonable
>from what I remember) will of course get you the latest version of the
>data files.   Hope this helps.
>
>
>Dan

If you don't mind setting up your own Zip Code database (keeps things
consistant internally  ;-) you can subscribe (or do a one-time purchase)
to a service that offers zip code tapes in either ASCII or (horrors!) EBCDIC
in a variety of formats:

DCC Data Service
1200 18th St. NW  #704
Washington DC 20036

202-452-1419

Cheers-


-- 
******************************************************************************
*                                           * INSERT DISCLAIMER/QUOTE HERE   *
* E-mail   :   twombly@credtech.com         **********************************
*                                           * This space intentionally blank *
Lines: 19
Date: Tue,  5 Jan 93 09:43:16 MST
From: ron@bert.cs.byu.edu (Ron Snyder)
Organization: BYU Computer Science
Newsgroups: comp.databases
Subject: Re: Where are the Borland Tech-Faxes?
Distribution: usa

In article <1993Jan5.081054.1@bigez> dmmatt@bigez (Mike Mattix) writes:
   In article <4r#@byu.edu>, I (Ron Snyder) wrote:
   [message asking for electronic form of Borland's tech-faxes deleted]

   Mike suggested:
   Call 1-800-822-4264.

I just called that number, it's a place called Hanger Type (or something
like that, I didn't ask her to spell it :)) and the receptionist had no
idea what I was talking about.  (BTW, the number for their (Borland's) 
tech-fax dispenser is 1-800-822-4269.)  

Does anybody know where the tech-faxes are available in electronic form
so that I can ftp them?


--
Ron Snyder <ron@bert.cs.byu.edu>   <snyderrj@coned1.byu.edu>
****************************************************************
From: bq035@cleveland.Freenet.Edu (Brian Jepson)
Newsgroups: comp.databases
Subject: Re: Foxpro2 Screen Builder Question
Date: 12 Jan 1993 01:24:06 GMT
Organization: Case Western Reserve University, Cleveland, OH (USA)
Reply-To: bq035@cleveland.Freenet.Edu (Brian Jepson)
NNTP-Posting-Host: hela.ins.cwru.edu


In a previous article, accdak@vaxa.hofstra.edu () says:

>I hope this is a simple Foxpro question.  Using the screen generator I created
>a push button which calls up a procedure in which the user fills in an array
>with a number of items.  
>
>I don't want the items themselves displayed on the screen, but I would like the
>count of the number of items chosen to be displayed in the window next to the 
>push button, Something like this:
>
><Items>       0 chosen     would become -->  <Items>       7 chosen
>
>I tried to do this with a SAY, but the SAY is never updated from the value
>assigned in the window setup code.  I can put the number on the screen by
>issuing an @SAY from within the push button's valid clause.  
>
>Is there a more elegant method?  (Feel free to answer by directing me to the 
>appropriate sample code or the manual.)
>
>David
>

In the @SAY field's dialog box (double-click on it), select [X] Refresh
Then, every time you issue SHOW GETS, it is refreshed. (the screen generator
does exactly what you did, except it goes into the READ SHOW).
-- 
*  __                _____                        Brian Jepson
* /__)  __ . __ __     /  __   _   /  _   __      iqm229@uriacc.uri.edu
*/___) /  / (_// / (__/  (_/  /_) _) (_) / /      bq035@freenet.cwru.edu
*                         `- /
Organization: Arizona State University
Date: Tuesday, 12 Jan 1993 16:02:33 MST
From: <ASNYR@ASUACAD.BITNET>
Newsgroups: comp.databases
Subject: Informix to Paradox-Import?

Hello, As a part of creating an application program I need to import several
tables from Informix to Paradox.I want know how this can be done - either from
Informix or from Paradox.Please help.  Thank You.
Newsgroups: comp.databases
From: durai@ortta.umn.edu (Durai Venkatasubramanian)
Subject: Re: Foxpro: Used() & File In Use
Organization: U of Mn
Date: Sat, 9 Jan 1993 17:06:23 GMT

In article <C0KAy2.E5M@acsu.buffalo.edu> v125qmam@ubvmsb.cc.buffalo.edu (Ami R Pflugrad) writes:
>From: v125qmam@ubvmsb.cc.buffalo.edu (Ami R Pflugrad)
>Subject: Foxpro: Used() & File In Use
>Date: 9 Jan 93 01:05:00 GMT
>Hi All!
>
>	IF Used("AcctMast")
>		Select AcctMast
>	Else
>		Select 5
>		USE \Foxpro2\Develop\FileMain\Accounts\Acctmast
>        EndIF
>

Used() will return T or F, after checking the current work area, or the work 
area specified within the used().  Unfortunately, it does not seem to check 
all the work areas for an open file, wait, unless you open the file with an 
alias.  With an alias, it somehow seems to work.  

Try this:

if used("acctmast")
 select acctmaster
else
 select 5
 use acctmaster alias acctmast
endif
From: WALKERK@ssvax1.ssd.loral.com ('Kent Walker')
Newsgroups: comp.databases
Subject: Re: References for bar coding equipment needed
Date: 12 Jan 93 23:37:17 GMT
Organization: Space Systems/Loral, Palo Alto, CA
X-News-Reader: VMS NEWS 1.20

In <1993Jan11.150543.28920@hellgate.utah.edu> kruckenb%peruvian.cs.utah.edu@cs.utah.edu writes:

> 
> I'm trying to set up a bar-coding system for use in a small warehouse
> along with an computer inventory system (which I've designed).  I need
> some help in finding reputable manufacturers/distributors of the
> reading/scanning equipment.  I'm particularly looking for scanners
> that will easily interface with PC's with little interface change (as
> in one that simulates keyboard input).  
> 
> I'd also be interested in wireless units (RF or IR), or one's which
> can download/upload information (and do some minor manipulations on
> that data, such as comparing a scanned code with a downloaded one, and
> count how many times an item is scanned).
> 
> I don't know what's available, so any pointers to good sources (books,
> magazines, newsgroups, etc) would REALLY be appreciated.
> 
> Thanks for your help (and time).
> Pete.

Well, Pete, that's quite a lot of information you need and probably deserves a
FAQ.  For starters, see if you can get a copy of "The Barcode Book" by Roger
Palmer (Helmers Publishing (603)924-9631 ).  It will answer a lot of your
questions.  One good trade periodical is "ID Systems" - same number as above. 
There is another publication but, alas, I don't have a copy in front of me at
the moment.

There are literally hundreds of vendors of barcode equipment; several are good
and some are not.  Some relatively small firms are listed in the back of most
microcomputer magazines.

The hardware for the "keyboard" interface you mention is known as a "wedge"
reader, a device connected in series between the keyboard and the CPU. 
Portable readers typically dump data through a serial port.  RF portables
(don't know of any IR portables) are usually multiplexed and operate directly,
i.e. they don't dump data.  However, the RF devices are at the high end of the
price range.

Hope this helps.  E-mail me should you need more info.
From: kjell@hut.fi (Kjell Ljungqvist)
Newsgroups: comp.databases
Subject: ODBC status (Btrieve)
Date: 5 Jan 93 15:35:26
Organization: Helsinki University of Technology
Distribution: comp
Reply-To: Kjell.Ljungqvist@hut.fi
NNTP-Posting-Host: bulldozer.cs.hut.fi

Hello !

I would be interested in hearing something about the development
status of ODBC drivers for different database vendors.
I am primarily interested in an ODBC driver for Novell Btrieve,
but I would also like to hear somethng about the general situation of ODBC.

Happy for any information.

--
-------------------------------------------------------------------------------
 	kjell@hut.fi 	kjell@niksula.hut.fi	kjell@vipunen.hut.fi
-------------------------------------------------------------------------------
From: kjell@hut.fi (Kjell Ljungqvist)
Newsgroups: comp.databases
Subject: Re: ODBC/IDAPI API specs
Date: 12 Jan 93 13:00:56
Organization: Helsinki University of Technology
Distribution: comp
	<1993Jan12.073111.10170@nwnexus.WA.COM>
Reply-To: Kjell.Ljungqvist@hut.fi
NNTP-Posting-Host: conan.cs.hut.fi
In-reply-to: mpdillon@halcyon.com's message of Tue, 12 Jan 1993 07:31:11 GMT

In article <1993Jan12.073111.10170@nwnexus.WA.COM> mpdillon@halcyon.com (Michael Dillon) writes:

  : Please post a location where these specs can be gotten by mail server
  : or ftp.  PS or non-PS versions (doesn't matter)

In the vendor/microsoft/odbc-sdk directory at ftp.uu.net you can find the
odbc.exe file. This is a self extracting zip-file that includes the odbc-sdk
v. 1.0 and thus, I believe, includes the API spec.


--
-------------------------------------------------------------------------------
 	kjell@hut.fi 	kjell@niksula.hut.fi	kjell@vipunen.hut.fi
-------------------------------------------------------------------------------

Newsgroups: comp.databases
From: g9utxu@fnma.COM (Tanin Uthayanaka)
Subject: Re: Move XBASE compats to own newsgroup
Reply-To: g9utxu@fnma.COM
Organization: Fannie Mae
Date: Mon, 4 Jan 1993 16:38:42 GMT

In article 726154234@otto, dtb@otto (David Bath) writes:
>I agree with some other netters.
>	fox, clipper, dbase, etc .... all those "xbase" compatibles
>	using "dbase" files deserve their own newsgroup.
>
>	maybe paradox stuff should have theirs as well.
>
>	comp.databases should be a general discussion area, with
>	most of the product specific stuff living in their own
>	newsgroups, as comp.databases.(oracle|ingre|sybase) do.
>
>Who wants to do this ?
>
>
You got my vote.


Newsgroups: comp.databases
From: ynwang@cuse1.se.cuhk.hk (Wang Ying Ngai (GA))
Subject: Help on CLIPPER DBEIDT()
Keywords: CLIPPER
Organization: Faculty of Engineering, The Chinese U. of Hong Kong
Date: Mon, 4 Jan 1993 03:05:16 GMT


Dear Clipper Programming experts,

I am an new user to the CLIPPER 5.01 and recently I try to write my own
version of DBEDIT() with TBrowse. However, a stone stop my road for that

-- How can I implement the PICTURE option into the TBrowse?
   (I try different ways with concept:
      field="QUANTITY"
      column:=TBColumnNew(" ",{ || transform(fieldblock(field,"999,999")} )
    but this concept cannot work)

I would appreciate a lot if you can give any advice on this.

Also, do you know whether there is any site that has CLIPPER sources in
internet?

Regards

Andrew Wang
From: v125qmam@ubvmsb.cc.buffalo.edu (Ami R Pflugrad)
Newsgroups: comp.databases
Subject: Foxpro: Used() & File In Use
Date: 9 Jan 93 01:05:00 GMT
Organization: University at Buffalo
News-Software: VAX/VMS VNEWS 1.41

Hi All!
	Could someone tell me what's going on with my Foxpro Application.

	I Have a program that is called by many differnt apps, as a result
	is has to be flexible enough to handle a variety of different 
	file views.  Therefore I have it programmed to see if the file is
	already open before proceeding.  Heres a portion of the code:

	IF Used("AcctMast")
		Select AcctMast
	Else
		Select 5
		USE \Foxpro2\Develop\FileMain\Accounts\Acctmast
        EndIF

        Now, If the file is already used it will execute the first part
	if not, it should execute the second part. 

	Here's whats happening....

	The File is not already in use when I call the program.
         Therefore the Used() function returns a .F. and the second part of
	the code is executed.  But when it encounters the USE \Foxpro2\etc.
	statement, the app blows up with a "FILE IN USE" Error. 

	Can somone explain why its doing this?  

	Thanks so Much,
	- Ami :)
Newsgroups: comp.databases
From: dlucy@sandr.COM (Doug Lucy)
Subject: WANTED: Shareware MS-DOS db for Text+Graphics
Organization: S&R Software, Inc.
Distribution: usa
Date: Mon, 11 Jan 1993 19:32:55 GMT

I'm looking for a database to try out that can store and display text
(normal database-type fields) and graphics (I don't care what format
they are or how they're stored/referenced in the database) at the same
time.

I've seen the commercial packages, but all I want is a simple
record-by-record display with a area on the screen that displays a
graphic associated with that record.

Anyone know of something like this? Thanks.

-- 
| Doug Lucy, Chief Geek | Xenus - Total Security Automation |
| S&R Software, Inc     | for Classified, Sensative and     |
| dlucy@sandr.COM       | Proprietary Information           |
Newsgroups: comp.databases
From: iano@world.std.com (Ian J Ornstein)
Subject: Questions on MS Access
Organization: The World Public Access UNIX, Brookline, MA
Distribution: usa
Date: Fri, 8 Jan 1993 19:58:30 GMT


I've made a few experiments with mailing labels using the report
wizard. When I choose 1 up or two up labels they are correctly
formatted and printed. However, in the design view I can find no difference!
Where (an how) does Access hide the fact that this particular report
is two up?

Has anyone determined how to view the code generated by the Wizards?

Where is the starting place for coding a custom application in
Access Basic?

					Thanks,
					- Ian -
From: an662@cleveland.Freenet.Edu (Michael Leach)
Newsgroups: comp.databases
Subject: Clipper FTP sites
Date: 6 Jan 1993 13:14:58 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA)
NNTP-Posting-Host: hela.ins.cwru.edu


WUARCHIVE.WUSTL.EDU in /mirrors/msdos/clipper
NIC.FUNET.FI in (I think) /pub/msdos/databases/clipper

both of these sites have a fair supply of Clipper code.  They
also have some dBase/etc. stuff laying around.

Mike Leach
programmer/analyst
University of Cincinnati
an662@cleveland.freenet.edu
leachmj@uc.edu
Newsgroups: comp.databases
From: Larry_Beattie@mindlink.bc.ca (Larry Beattie)
Subject: One to Many or Many to One
Organization: MIND LINK! - British Columbia, Canada
Date: Mon, 4 Jan 1993 14:05:09 GMT

I am setting up a cost analysis system that involves jobs or projects and
their related costs and billings. I am using Alpha4 but could use Paradox 4
just as well.  Not being that used to relational systems, is it better to set
it up with the master being the 'job' database which has only 1 record per
job or using the 'transaction' database which can have many records per job.

I have being trying to do it with a many to one set up but it seems very
clumsy but it may be my lack of experience that is getting in the way.

Thanks for any help you can give to this struggling neophyte.

Larry B
From: lrb@ctrg.rri.uwo.ca (Lance R. Bailey)
Newsgroups: comp.databases
Subject: Welcome to the SiR mailing list (correction)
Date: 7 Jan 93 20:25:56 GMT
Organization: Relayed-by-Sendmail
X-Mailer: ELM [version 2.3 PL11]
To: datamgt@ctrg.rri.uwo.ca, rob@innovus.com, comp.databases@newshost.uwo.ca


A mailing list has been set up to discuss matters pertaining to
the database system SiR. SiR is a product of SiR (Australia) Inc.


WHAT IS A MAILING LIST

Mailing lists are a method of electronic communication.  The concept is that
by mailing to one "person" a letter is distributed to many, many people with
the one action.  Replies to a "posting" are again distributed to many
people.  This allows many people to carry on a discussion on a particular
subject matter.  Mail lists are often used in place of BBS (Bulletin Board
Systems) some popular or widely used mailing lists are often merged into a
BBS.
-----------------------------------------------------------

    Joining the mailing list
    ------------------------
To join the list, send a mail message to sir@ctrg.rri.uwo.ca with the word
"join" as the subject of the message. Alternatively you may mail a note to
sir-request@ctrg.rri.uwo.ca and ask to be placed on the list.

TO POST TO THE MAILING LIST 

To send a letter to all members of the list, send mail to 
	sir@ctrg.rri.uwo.ca
The mail will then be distributed to all members of the list.


    Replying
    --------
When you reply to a letter, or posting, the reply goes to all the members of
the list and NOT the person who originated the letter.  If you wish to talk
to ONLY that person, there should be an Originator:  line stating who sent
the message.

If you wish the mail to be private then addresss your reply to the person
listed on the Originator:  line.


    Help
    ----
To speak directly to the list administrator (problems, new address &c.),
send mail to :
    sir-request@ctrg.rri.uwo.ca


-------
Lance R. Bailey  System/Network Manager         Robarts Research Institute
     NeXT/email: zaphod@ctrg.rri.uwo.ca    box: Clinical Trials Resources Group
            fax: +1 519 663 3789                P.O. Box 5015, 100 Perth Dr.
            vox: +1 519 663 3787 x4108          London, Canada N6A 5K8
Probability: If you have five dogs, three will be asleep.
Newsgroups: comp.databases