HDTenEightyP/NetNews huggingface dataset:
From: hasko@heeg.de (Hasko Heinecke)
Subject: Re: New Group for OODBMS
Organization: Georg Heeg Objektorientierte Systeme, Dortmund, FRG
Date: Thu, 21 Jan 1993 14:06:16 GMT

In article <1993Jan18.143601.14908@zoe.network23.com> terry@zoe.network23.com (Terry) writes:
>> In article <1993Jan14.225305.23525@dragon.acadiau.ca>, 890179s@dragon.acadiau.ca (Michael R. Smith) writes:
>>How about starting a new group for Object Oriented Databases or
>>is there already one that I don't know about.
>>
>>Either comp.databases.object
>>or     comp.databases.oodbms
>>or     comp.object.databases   
>>
>>I'm sure the demand is there.
>
>There might be sufficient demand, but because OODBMs are so closely related
>to OOP there would be an excessive amount of cross-posting to comp.object
>which would be a good reason NOT to create a new group.

But ther _is_ already an excessive amount of crossposting in comp.object.
Look at the Newsgroups: header line in this very posting.

Would someone just post a RFD?

Hasko Heinecke


-- 
+-------------------------------------------------------+
| Hasko Heinecke @ Georg Heeg Objektorientierte Systeme |
| I _never_ mean what I say - and nobody else does...   |
+-------------------------------------------------------+
Newsgroups: comp.databases
From: kcschoepflin@happy.colorado.edu
Subject: Help de-duping an existing database
Organization: University of Colorado, Boulder
Date: 22 Jan 93 09:09:15 MDT

I need a way to search a database and flag records that have duplicate fields
so that I can then examine the records to see if they need to be deleted.
I can use DBase III, MS Access, or dos text files.  If you have information
please e-mail me at kcschoepflin@happy.colorado.edu of post here.
Thanks in advance. Keith

Newsgroups: comp.databases
From: iano@world.std.com (Ian J Ornstein)
Subject: ? Microsoft Access
Organization: The World Public Access UNIX, Brookline, MA
Distribution: usa
Date: Tue, 26 Jan 1993 19:37:04 GMT

1.- How can I have a date automatically changed in the TABLE
    when any field in a form is changed? I know I can use =Date()
    in a form field. Can I do this without having a date field on
    the form?

2.- I'm using counter data type as keys for my tables.
    I'd like to be able to do some sort of look up with the form
    so that the text name from the reference table is displayed in the
    form but only the value of the foreign key is stored in the table.
    How can I do this?

ExampLe:
--------

C O M P A N I E S

Company_id (Counter)  Company_name (Text)
1		       First company name
2                      Best company name
3                      Modem company
4                      Monitor company name



R E P S

Rep_id (Counter) Company_id(Number) [Same as Company_id in table COMPANIES]
Alice		  2
Betty		  2
Carol		  4


FORM_Rep should show the Company_name that corresponds to the 
Newsgroups: comp.databases
From: lindsey@tincup.enet.dec.com (Randy Lindsey)
Subject: Re: Program Rights in NetWare?
Organization: Colorado Software Solutions, Inc.
Date: Thu, 28 Jan 1993 19:13:46 GMT


In article <C19KDv.1JH@ms.uky.edu>,  hgpeach@ms.uky.edu (Harold G. Peach, Jr.) writes...
>I am designing a database for use on a NetWare 386 LAN.  What I would like
>to setup is a system where users enter information into a temporary file
>stored in a directory they have RW access to.  Then after validation,
>have the entry program append the transaction file to a master file
>kept in a subdirectory that only the supervisor has RW access to.  Is
>there a way to give a program file/subdirectory access that the user using
>the program does not have?  I know this can be done under UNIX and several
>other platforms, but don't see anything in my Novell reference about how
>to do it in NetWare.
>---
>Harold G. Peach, Jr.                              Home Phone:  (606) 271-6393

On a network, you can't allow programs to have rights--because anybody
could create their own program and endow it with any rights they wanted
to give it.  The network can't guarantee that the program you *say* you're
running on your remote system is the one it *thinks* you're running.  So
only the user has any rights.

That said, you can give everybody Write-only access to a directory.  They
can put data into it, but can't view or change data, including overwriting
existing files.  So anybody could copy an entire file to that directory.
They couldn't, however, append to an existing file.  You'd just have to
have a privileged user periodically run a program to collect all the little
files and append them to the main one.  This applies to Novell, anyway.

-Randy
Newsgroups: comp.databases
From: mcdonald@aries.scs.uiuc.edu (J. D. McDonald)
Subject: Re: Paradox question
Organization: UIUC SCS
Date: Thu, 28 Jan 1993 02:25:19 GMT

In article <s1#@byu.edu> ron@bert.cs.byu.edu (Ron Snyder) writes:
   >it.  Use this second table to design reports, forms etc.  Every time
>   >you do a query and want to use one of the reports or forms, do a F10
>   >Tools Copy Justfamily "skeleton" "Answer".
>   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>
>   I believe "Copy" overwrites the table and could hose your reports....it
>   is safer to empty "skeleton", add "answer" "skeleton" from a script ...
>   that way you know exactly what is in the skeleton table at all times.
>
>When you Copy JustFamily, it leaves the destination table (in this 
>case, the answer table) alone, and just replaces any forms and reports
>that existed for the answer table.  As to your other advice, in general
>is a better idea to not empty "skeleton" and then add "answer" "skeleton",
>because of the time involved in this procedure, especially when there is
>a large amount of data that would have to be moved.  I have seen
>several suggestions from the 'experts' to do a 
>
>     copyreport "skeleton" "1" "answer" "1"
>     report "answer" "1"
>
>when this will do what is needed.  (Of course, you would have to pick
>your own table names and report numbers.)  The advantage that this
>method has over doing a "Copy JustFamily" is that if "skeleton" has
>a lot of reports and forms, then that extra baggage stays where it
>is, and you only copy the report that you want.
>



I asked the original question. Waht I finally did was make a macro (i.e.
Script) that copies just the report template from my normal data table to
the table created by Answer, which happens to have the same structure.

Doug McDonald
From: field@.cs.pitt.edu.cs.pitt.edu (Brian Field)
Newsgroups: comp.databases
Subject: paradox 1) postscript q, 2) path q
Date: 28 Jan 93 15:02:47 GMT
Reply-To: field@cs.pitt.edu
Organization: University of Pittsburgh, Department of Computer Science
X-Newsreader: Tin 1.1 PL3


Two questions regarding paradox 4.0.

1) I'm using the report generator to generate reports that are sent to a
    postscript printer.  Under certain conditions, I would like some
    field values to be printed in bold, italics, a larger font, etc.  Is
    it possible from to get the report generator to generate appropriate
    postscript output?  If so, what hacks (if any) are necessary...

2) Is it me, or does paradox not support relative path addressing? i.e.
   If I perform a copy from one directory to another, I must specify
   the absolute path if it is not the current directory...

Thanks
Brian
-----
field@cs.pitt.edu

Newsgroups: comp.databases
From: umnoor@ccu.umanitoba.ca (Nasir Ahmed Noor)
Subject: Re: Two-dimensional array simulation in Paradox
Keywords: PARADOX ARRAYS
Organization: University of Manitoba, Winnipeg, Canada
Date: Mon, 25 Jan 1993 02:28:01 GMT

dcm@world.std.com (David C McGaffin) writes:

>    However, I can think of no way to get the size of the 
>    array, without passing it to the procedure.

The proc you are using is closed. It means it does not know of anyother
var that exists outside of it UNLESS you tell it so. In your proc, add 
following as line #2
                   UseVars aArray
UseVars is followed by a comma separated list of variables you want your
'closed' proc to use.

--nasir
From: umnoor@ccu.umanitoba.ca (Nasir Ahmed Noor)
Newsgroups: comp.databases
Subject: Re: How does ones...
Date: 24 Jan 93 15:01:25 GMT
Organization: University of Manitoba, Winnipeg, Canada


I am not DBase user but your problem calls for use of Format statement/fn.

--nasir
From: trinhm@hercules.cs.uregina.ca (Muoi-Ky Trinh)
Newsgroups: comp.databases
Subject: zim  3.3.11 & 4.01
Date: 27 Jan 93 07:17:41 GMT
Organization: University of Regina, SK, Canada

Hi,
Does anyone out there have any informations on ZIM 3.11 & 4.01.
Thanx....
  ............................   ........................................   
.'                            `.'  Faculty of Computer Science           '. 
:                              :   University of Regina                   : 
:                              :   Regina, SK., CANADA                    : 
:       Muoi-Ky Trinh          :                                          :
:                              :   Email:  trinhm@hercules.cs.uregina.ca  :
:                              :           trinhm@meena .cs.uregina.ca  :
:                              :           trinhmuo@max.cs.uregina.ca     : 
 `............................' `........................................'
Newsgroups: comp.databases
From: nigelc@cognos.com (Nigel Campbell)
Subject: MIA dbms compliance - need info
Organization: Cognos Incorporated, Ottawa CANADA
Date: Wed, 27 Jan 1993 23:14:06 GMT

What is MIA, who besides DEC with Rdb are doing anything with it
in their DBMS engines. Does anyone have address/contact info.

-- 
Nigel Campbell          Voice: (613) 738-1338 ext 3016    P.O. Box 9707
Cognos Incorporated       FAX: (613) 738-0002             3755 Riverside Dr.
Database and Connectivity MCI: nigel campbell || 307-4729 Ottawa, Ontario
UUnet: nigelc@cognos.COM                                  CANADA  K1G 3Z4
From: brousseau@helix.mgh.harvard.edu
Newsgroups: comp.databases
Subject: menu
Date: 21 Jan 93 12:41:03 GMT
Organization: Mass General Hospital

I've encountered a problem with PAL that I need help with. Simply,
how can I perform a query / endquery, using a string variable which
contains operators? 
Example, I want to ask the user to input a (limited) range of 
days by checking a box either Y = Yes, include Monday or N = No, 
do not include Wednesday. I've gone through the response and
made a string that would look something like this: "..MON.. AND NOT ..WED..",
placed it into the query form, Database | ~string |, but it doesn't work.
I think it is because the query is looking for a literal interpretation of
the string, instead of parsing the data and operators. Anyone? The best I
can think of at the moment is multiple queries, but that can take a _long_
time. Thanks.
From: srg3sir@grace.cri.nz
Newsgroups: comp.databases
Subject: PC Client/Server databases
Date: Fri, 29 Jan 93 05:21:46 GMT
Organization: Industrial Research Ltd., New Zealand.
NNTP-Posting-Host: grv.grace.cri.nz

Does anyone know of any true client/server database systems for PC?
ie the processing must be done on the server machine, passing only
the result back to the client. Transferring huge tables over the
network for procesiing on the client machine is out.

The system has to be good for bibliographic data (library application)
and relational & distributed would be added bonuses!

Please mail replies to
srg3sir@grv.grace.cri.nz

TIA, 
Richard Mayston
From: ken.lundberg@tfd.coplex.com (Ken Lundberg) 
Newsgroups: comp.databases
Subject: dBase & Oracle
Date: 21 Jan 93 21:55:00 GMT
Distribution: world
Organization: Ky/In PC User's Group - Louisville, KY - 502-423-8654
Reply-To: ken.lundberg@tfd.coplex.com (Ken Lundberg) 

TO: gerrit#vtm.be

FR: ken.lundberg@coplex.com

 On Wed, 20 Jan 1993, Gerrit Cap wrote:

>I have to transform dBase files into Oracle tables (on a rs6000). Does
>anybody have experience with this stuff? You could classify me as a total
>ignorant when it comes down to dBase...

 Gerrit,

 Perhaps I'm mistaken, but isn't one of Oracle's main selling points the
 fact that it can read native dBASE files? Correct me if wrong, OK?

 * SLMR 2.1a * ------------------------------------------Ken-in-Kentucky
         
Newsgroups: comp.databases
From: thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040)
Subject: JYACC JAM, Uniface, Power Builder
News-Software: VAX/VMS VNEWS 1.4-b1  
Organization: NASA/GSFC-Laboratory for Astronomy and Solar Physics
Distribution: usa
Date: Tue, 26 Jan 1993 19:06:00 GMT

Can anyone give me any U.S. contact information for the following 4GL products:

	* JYACC JAM

	* Uniface

	* Power Builder

Thank you,

Bill Thompson
From: zzz@byron.u.washington.edu (Sample)
Newsgroups: comp.databases
Subject: FoxPro2 & Scrollable windows
Date: 28 Jan 1993 05:45:03 GMT
Organization: University of Washington
NNTP-Posting-Host: 128.95.56.210

Someone wrote:
      "If it's a file or something you can output 
      to a file before viewing, use MODIFY FILE . . ."

I want the output of things like "?" to go to
a scrollable window.  Sending the "?" output
to a file (for later viewing) works but it requires
several extra steps.  If things like "?5+4" went to
a scrollable window then I would have a "history"
of, say, the last 1000 lines of my "workspace".
Does Foxpro2.5 do this?

> * Is there a way to have a [PROJECT-type] file 
> opened up automatically when foxpro is evoked?

      "What do you mean by "project".  If you mean an 
      application generated by the program manager (
      an .app file) or a program file, yes just put 
      the name on the command line."

I mean a .PJX (I think) file -- You can create one
by selecting New from Foxpro2's File menu and
choosing "project" as the file type (rather
than database or program or report etc.)
From: mcsdc1sjt@dct.ac.uk (Gonzo)
Newsgroups: comp.databases
Subject: Re: Clipper under Windows
Date: 26 Jan 93 18:48:43 GMT
Organization: Dundee Institute of Technology

In article <C180GG.3nw@sdf.lonestar.org>, labamba@sdf.lonestar.org (Peter Steiger) writes:
>> Grumpfish has recently released Clip4Win, a product similar to
>> Dolce Vita.  It lets Clipper programs run as Windows programs.
> 
> Mike, I just saw Clip4Win's ad this month (it was not in the December
> Databased Advisor).  It didn't make clear whether that product provides
> a true GUI with Clipper access to .DLLs the way Dolce Vita does.  Can
> you tell from the demo if it's a true Windows environment or just a
> Windows kludge of a text environment?
> 

Can anyone provide me with either demos of Dolce Vita or Clip4Win???




> If Clip4Win does real windowing and not just CUA (the way Provision:Windows
> does), I'd be more inclined to trust a Greg Lief product.  I, too, was 
> disconcerted by the two database engines that invited themselves onto my
> desktop when I fired up the DV demo.
> 
> pbs

Thanks Gonzo.

-- 
================================================================================
| <<<< Gonzo >>>>		| "Life can be pleasent as well as nasty."     |
|				|					       |
| JANET : MCSDC1SJT@UK.AC.DCT	|	"Always trust your fealings."          |
================================================================================
From: adc@tardis.cl.msu.edu (Alan D. Cabrera)
Newsgroups: comp.databases
Subject: Re: New Group for OODBMS
Date: 23 Jan 93 15:59:07 GMT
Reply-To: adc@tardis.cl.msu.edu
Organization: Michigan State University
NNTP-Posting-Host: tardis.cl.msu.edu

In article 1331@procor.UUCP, jamesm@procor.dialogic.com (Mark James) writes:
>
>In article <19705@mindlink.bc.ca> John_Carson@mindlink.bc.ca (John Carson)
>writes:
>>The only problem I have with a object oriented group is I don't see enough
>>volume here to qualify another group.
>
>Really?  Out of 43 messages in comp.databases today, seven of them deal
>with object-oriented databases, not counting the three discussing the
>possible creation of the new newsgroup.  That's plenty to justify a new
>group.  Plus, I'm sure that people who have to wade through the 
>overly-broad coverage of comp.databases will appreciate having that
>many fewer articles to wade through.
>

In my opinion, seven articles a day does not justify creating a new
group.  Seven less articles, again IMHO, is not that significant.


---
Alan Cabrera				internet:  adc@tardis.cl.msu.edu
Computer Laboratory			phone:     (517) 353-3027
Michigan State University		fax:       (517) 353-9847
514 Computer Center			bitnet:    CABRERA@MSU
East Lansing, MI 48824
Newsgroups: comp.databases
From: moursand@lonestar.utsa.edu (Bowen M. Moursund)
Subject: Re: dBase 4v1.1:can I change directories on the fly?
Organization: University of Texas at San Antonio
Date: Tue, 26 Jan 1993 23:20:22 GMT

Jonathon - Check out the SET DIRECTORY command.
From: jbc@cunyvms1.gc.cuny.edu (CASSEL J BRIAN)
Newsgroups: comp.databases
Subject: trouble using Foxpro to index when using ctod(x) function
Keywords: foxpro, index, ctod
Date: 23 Jan 93 20:19:00 GMT
Organization: Graduate School and University Center, CUNY, New York
News-Software: VAX/VMS VNEWS 1.41

I have a database with a character-type field for dates
in this format -- 01/01/92.  I used the following index command,
	index on ctod(datefield) to dates.idx
and it seemed to work okay.  But when I listed off some records
using a filter, I found that one record did not list in the 
proper order - it was out of place by about 5 records.  There
was nothing wrong with the data; and I deleted that record and
re-entered it just to make sure...

Does anyone know why this index did not work?

Thanks in advance.

Brian Cassel
jbc@cunyvms1.gc.cuny.edu
======================== disclaimed - does not represent CUNY.
Newsgroups: comp.databases
From: gaede@faw.uni-ulm.de (Volker Gaede)
Subject: Re: New Group for OODBMS
Organization: FAW (Research Institute For Applied Knowledge Processing, Ulm, Germany)
Date: Fri, 22 Jan 1993 13:15:44 GMT

In article <1331@procor.UUCP>, jamesm@procor.dialogic.com (Mark James) writes:
|> 
|> In article <19705@mindlink.bc.ca> John_Carson@mindlink.bc.ca (John Carson)
|> writes:
|> >The only problem I have with a object oriented group is I don't see enough
|> >volume here to qualify another group.
|> 
|> Really?  Out of 43 messages in comp.databases today, seven of them deal
|> with object-oriented databases, not counting the three discussing the
|> possible creation of the new newsgroup.  That's plenty to justify a new
|> group.  Plus, I'm sure that people who have to wade through the 


Sorry, but I just read 84 messages in comp.databases and there was only 
*one* OOBMS (Ontos) relevant question beside the FAQ for OODBMS and the discussion
about the setting up an OODB-group. Where are the other messages?

	Volker

------------------------------+-------------+----------------------
Volker Gaede                  +   \\\|//    + Tant d'histoire pour 
                              +   |o o |    + rien de tout.
gaede@main01.rz.uni-ulm.de    +  O| L  |D   + 
gaede@faw9370.faw.uni-ulm.de  +   |\_/ |    +
gaede@faw.uni-ulm.de          +   \___/     + 
------------------------------+-------------+----------------------
Newsgroups: comp.databases
From: nrh@philabs.philips.com (Nikolaus R. Haus)
Subject: Re: FoxPro2 & Scrollable windows
Originator: nrh@philcat1
Reply-To: nrh@philabs.philips.com (Nikolaus R. Haus)
Organization: Philips Laboratories, Briarcliff, NY 10510
Date: Thu, 28 Jan 1993 14:46:47 GMT


In article <1k7rsvINNbi1@shelley.u.washington.edu>, zzz@byron.u.washington.edu (Sample) writes:
>Someone wrote:
>      "If it's a file or something you can output 
>      to a file before viewing, use MODIFY FILE . . ."
>
>I want the output of things like "?" to go to
>a scrollable window.  Sending the "?" output
>to a file (for later viewing) works but it requires
>several extra steps.  If things like "?5+4" went to
>a scrollable window then I would have a "history"
>of, say, the last 1000 lines of my "workspace".
>Does Foxpro2.5 do this?

Someone a little while ago posted that there is something on CompuServe
in the fox forum that lets you do scrollable windows a-la the command
window. I havent tried it, but the basic comment sounds like it's a
pain in the neck, but it works well.

>> * Is there a way to have a [PROJECT-type] file 
>> opened up automatically when foxpro is evoked?
>
>      "What do you mean by "project".  If you mean an 
>      application generated by the program manager (
>      an .app file) or a program file, yes just put 
>      the name on the command line."
>
>I mean a .PJX (I think) file -- You can create one
>by selecting New from Foxpro2's File menu and
>choosing "project" as the file type (rather
>than database or program or report etc.)

You can do whatever you want at startup- with the COMMAND= line in your
CONFIG.FP. I have COMMAND=init, then init.prg has all the stuff I want to
do- setting global variables etc, and the line 'modify project <pname>
nowait'. The nowait is important- it tells foxpro to continue the .prg
before the project being modified is closed.

-nik
From: rlalwani@hpcupt1.cup.hp.com (Rajesh Lalwani)
Date: Fri, 22 Jan 1993 18:43:41 GMT
Subject: Information on Microsoft ODBC?
Organization: Hewlett Packard, Cupertino
Newsgroups: comp.databases

Can someone please tell me if there is any book on Microsoft ODBC?
Or can you please point me to where I can get information on ODBC?
Thanks.

-- Rajesh 
Newsgroups: comp.databases
From: Terje Tvers <tert@cc.uib.no>
Subject: Omnis 7
X-Xxmessage-Id: <A78DA6B3C101C88A@tert.uib.no>
X-Xxdate: Thu, 28 Jan 93 15:05:23 GMT
Organization: Univ. of Bergen
X-Useragent: Nuntius v1.1.1d17
Date: Thu, 28 Jan 93 14:01:58 GMT

I am searching for universities in the US or Canada where Omnis 7 is
installed with a site licence. Please contact me directly, I have some
questions on support experience etc.

Terje Tveras, Univ. of Bergen, Norway
tert@cc.uib.no
edptt@nobergen.bitnet
Newsgroups: comp.databases
From: nathans@pacifier.rain.com (Nathan Silva)
Subject: File/record locking in Clipper
Organization: Pacifier BBS
Date: Mon, 25 Jan 1993 22:23:13 GMT



How does Clipper perform file locking (internally)?  I am trying to
write a C program that can access Clipper .DBFs.

I've figured out that when you RLOCK(), Clipper locks one byte of the
file, beginning at logical byte 1 billion + <record number>.  I've also
had success duplicating FLOCK() by locking a region <# of records> long,
beginning at byte 1 billion.

But what if I need to update something that is stored in the
header -- for example, the LASTREC() value. Is there a "magic" region
that I should lock, such as byte 999,999,999?  Or should I actually
physically lock the header region.


Nathan

-- 
 -------------------------------------------------------
| Nathan Silva               |                          |
| nathans@pacifier.rain.com  | Do the World News Polka! |
 -------------------------------------------------------
Newsgroups: comp.databases
From: pnguyen@staff.tc.umn.edu ()
Subject: Pdox4.0 on Novell Lite LAN v1.1
Organization: University of Minnesota
Distribution: ?
Date: Wed, 27 Jan 1993 17:00:44 GMT

I am currently running Pdox4.0 on a Novell Lite LAN v1.1.  My problem is
when i try to view a table on the server from my workstation, it would
just hang.  Paradox comes up just fine from my workstation; i can edit
and compile scripts without any problem.  The weird thing is that when i
run another copy of Paradox on the server first, i don't have any problem
with accessing the tables on the server from my workstation.  I hope this
is clear enough.  Any help will be greatly appreciated.

pnguyen.staff.tc.umn.edu
Newsgroups: comp.databases