HDTenEightyP/NetNews huggingface dataset:
From: viking@iastate.edu (Dan Sorenson)
Subject: Re: Foxpro 2.0 on a network 
Organization: Iowa State University, Ames IA
Date: Sun, 13 Dec 1992 06:53:18 GMT

csc4213@gsusgi2.gsu.edu (Uncle Remus) writes:

>The "Six-pack" version is referring to use of the actual foxpro environment. 
>Distributed exe's have unlimited network usage. BTW, this has been the only
>way to get foxpro 2.0 lan since a little while before micosoft bought out fox.

	Then Microsoft won't mind if I hang onto my money.  I bought the
distribution kit, but there is no way I am going to make all of my code
individual .exe's and forsake the fox environment for my users just to stay
within some software license.

	Sorry, Microsoft, but I refuse to limit myself because you think
I should.  Your 2.0 environment is perfect for my needs, and I won't change.

< 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: TX_WAYNE@rrivax.rri.uwo.ca (Wayne Johnson)
Subject: Mailing List for SIR Database?
X-News-Reader: VMS NEWS 1.20
Organization: Robarts Research Institute
Date: Sat, 19 Dec 1992 03:22:05 GMT

Hi, 

Does anyone know if there is a mailing list for SIR???



Wayne Johnson 
"w.johnson@ctrg.rri.uwo.ca"
From: mservmrw@vax.oxford.ac.uk
Newsgroups: comp.databases
Subject: Read/write Ingres tables from Foxpro?
Date: 18 Dec 92 09:55:59 GMT
Organization: Oxford University VAX 6620

Hi!,

	We have a couple of large Ingres databases on UNIX (Ultrix) boxes that
we'd like to be able to get at from Foxpro 2.0 on a NetWare 3.11 server.  I
think that there are some third party goodies for doing this with Oracle, SQL
Server and the like but I've never heard of an Ingres one.  Anybody know
better?

Thanks in advance.

===============================================================================
Mark Walters                       | E-mail: mark@university.offices.ox.ac.uk
Micro-Computer Support             | JANET:  mservmrw@uk.ac.ox.vax
University Offices                 | Compuserve 100010,1511
Wellington Square                  | Tel: +44 (0)865 270246
Oxford    OX1 2JD                  | FAX: +44 (0)865 270708
===============================================================================
From: beh@po.CWRU.Edu (Bob E. Hetzel)
Newsgroups: comp.databases
Subject: Re: Paradox 4.0 ShowDialog CheckBoxes question
Date: 15 Dec 1992 04:59:16 GMT
Organization: Case Western Reserve University, Cleveland, OH (USA)
Reply-To: beh@po.CWRU.Edu (Bob E. Hetzel)
NNTP-Posting-Host: slc12.ins.cwru.edu


In a previous article, ISPAJW@ASUACAD.BITNET (Robert's Dad) says:

>Hi,
>  I would like to create a dialog box in such a way that the user can
>select one or more ID numbers to process.  I know that I can use the
>ShowDialog CheckBoxes feature.  Here's the fun part:  The list of ID
>numbers is not static.  They are contained in a table which I load into
>an array using Scan.  Is there a way to use CheckBoxes (or another,
>similar feature) so that the user can select one or more ID numbers
>when the number of ID numbers is not known until runtime?

Faced with the idea of having several dialog boxes pop up at the
user when appropriate fields are entered in formview, I decided
to make a procedure I called showdialogbox.  as parameters, I passed
all information needed, such as the pickarray name, size of the 
pickarray, location, width, height, location of the ok button, etc.
You can then just call the procedure with one line of code whenever
you need a popup that is different from others you need to have.
Sound logical?  

It worked for me--reducing 10-15 lines of code x 10 popups to only
about 25-30 or so lines of code.
-- 
"I held the blade, in trembling hands,
 Prepared to make it hurt.
 Just then the phone rang... 
 I never had the nerve to make the final cut".-- Pink Floyd, 1983.
Newsgroups: comp.databases
From: aahz@netcom.com (Mean Green Dancing Machine)
Subject: Re: Paradox 4: Problem with PushButton and ShowDialog
Organization: Don't blame me, I voted for Bill 'n' Opus
Date: Tue, 15 Dec 1992 19:08:12 GMT

In article <1gj5bqINNfj3@grasp1.univ-lyon1.fr> jcberger@grasp1.univ-lyon1.fr (Jean-Claude Berger) writes:
>I don't know what says the US documentation but the french one
>state that "the variable gets its value as soon as the dialog
>is accepted".
>
>As you can only accept a dialog with a OK button...

That's correct.

>By the way, I can't figure a use for a CANCEL button. Got an
>idea ?

Think of it like SQL: ACCEPT == COMMIT and CANCEL == ROLLBACK.
-- 
                         --- Aahz (the *other* Dan Bernstein)
                             @netcom.com 

Hugs and backrubs -- I break Rule 6

"Would you like some toast?!"
From: csa09@seq1.keele.ac.uk (Paul Singleton)
Newsgroups: comp.databases.theory
Subject: Re: date -> day of week conversion
Date: 14 Dec 92 16:03:11 GMT
Organization: Keele University, England

From article <dtb.724154401@otto>, by dtb@otto (David Bath):

> csa09@keele.ac.uk (Paul Singleton) writes:
...
>>Am I right in thinking that this is *not* the sort of functionality which
>>SQL was designed to express, and that in general it is not feasible to
>>define a relation by algorithm (in the way that Prolog programmers are so
>>accustomed to doing)?

> Rumor has it that one SQL based DB, Empress, running on UNIX and VMS,
> permits you to define your own functions that can be embedded in the
> sql, letting you define that function and then
> 	select surname, givname
> 	where	day_of_week(birthdate) = 'Saturday'
> 	from 	emp;

OK so I can define a function for use in a join condition, but I really
want to define a virtual table, some of whose columns are functions of
other columns.  I can see that SQL syntax doesn't accommodate this concept,
although I claim it is a reasonable thing to want to do.
----
  __   __    Paul Singleton (Mr)           JANET: paul@uk.ac.keele.cs
 |__) (__    Computer Science Dept.        other: paul@cs.keele.ac.uk
 |  .  __).  Keele University, Newcastle,    tel: +44 (0)782 621111 x7355
             Staffs ST5 5BG, ENGLAND         fax: +44 (0)782 713082
Newsgroups: comp.databases.theory
From: stroup@aspen.ops.lmsc.lockheed.com ()
Subject: Re: date -> day of week conversion
Reply-To: stroup@aspen.ops.lmsc.lockheed.com ()
Organization: Lockheed Missiles And Space Co.
Date: Mon, 14 Dec 92 17:45:50 GMT


>
csa09@keele.ac.uk (Paul Singleton) writes:

>Can anyone produce SQL code to convert a date from DD/MM/YY (or MM/DD/YY)
>format into the corresponding day of the week?  I assume that you can
>get at the individual DD, MM and YY fields (as integers?).

>

Maybe I'm missing the point here (or maybe this is an Oracle extension to 
SQL) but can't you just use the to_char function:

	Select to_char(my_date,'DAY') from my_table;

According to the doc, DAY gives you the name of the day, padded with blanks 
to a length of nine characters.

						judie
From: 881244y@dragon.acadiau.ca (Choon Lin Yeo)
Newsgroups: comp.databases.theory
Subject: Questions on Concurrency Control (CC) for Knowledge Bases
Date: 20 Dec 92 18:29:04 GMT
Organization: Acadia University

Hi there, 

	I have a few questions on the topic of CC methods for  
Knowledge Bases: 

1) What are the methods used for CC in the existing commercial  
   knowledge bases? Example of how they are applied in this context.  

2) Are Timestamp Ordering (TO) and Two Phase Locking protocols feasible  
   methods? 

3) Which of these methods gives a better performance in the context of 
   knowledge base? 


I sincerely appreciate any input. Thanks in advance. 
My e-mail address is 881244y@dragon.acadiau.ca  
-- 
			    _ _ 
------------------------ooo--U--ooo-------------------------------
* Acadia SUB Box 6732		Choon Lin, Yeo	
* Wolfville, Nova Scotia 	e-mail: yeo.choon.lin@acadiau.ca
Newsgroups: comp.databases.theory
From: hellers@cs.wisc.edu (Joe Hellerstein)
Subject: Re: date -> day of week conversion
Organization: Univ. of Wisconsin @ Madison, CS Dept.
Date: Tue, 15 Dec 1992 00:18:50 GMT

In article <Bz9B9C.BBD@gabriel.keele.ac.uk> csa09@seq1.keele.ac.uk (Paul Singleton) writes:

>   > Rumor has it that one SQL based DB, Empress, running on UNIX and VMS,
>   > permits you to define your own functions that can be embedded in the
>   > sql, letting you define that function and then
>   > 	select surname, givname
>   > 	where	day_of_week(birthdate) = 'Saturday'
>   > 	from 	emp;
>
>   OK so I can define a function for use in a join condition, but I really
>   want to define a virtual table, some of whose columns are functions of
>   other columns.  I can see that SQL syntax doesn't accommodate this concept,
>   although I claim it is a reasonable thing to want to do.

If I read you right, all you want is a view, with a function in the
select list, e.g.:

DEFINE VIEW function(domaintype fc1, rangetype fc2, ...) AS
  (SELECT c1, f(c1), ...
     FROM ...
    WHERE ...   
  ) ;

No?  This would be supported, for instance, in Starburst's version of
SQL, or with similar syntax in POSTGRES' Postquel language.  And if
Empress is as described above, I'd have to guess it would work there
too.  No big tricks here.

Joe Hellerstein
Newsgroups: comp.databases.theory
From: sethi@cse.uta.edu (Tarminder S Sethi)
Subject: Request: Nested Transactions 
Organization: Computer Science Engineering at the University of Texas at Arlington
Date: Sun, 13 Dec 1992 23:17:34 GMT

I am on the lookout for relevant papers or information on nested
transactions. I need some information on lock based concurrency
controllers for a database having these nested transactions. If you have
some papers on the disk could you mail them to me please at

sethi@cse.uta.edu

Especially something by
Moss, J.E.B on Nested Transaction and Reliable Computing in Proc 2nd
IEEE Symp on Reliablity in Dist S/W and Database Sys. July 1992

Beeri, C; Bernstein, N.A, Goodman ,N on Model for concurrency in nested
transaction systems in Journal of ACM, April 1989 36(2) pg 230-269

Lynch, N.A. on Multilevel ATomicity - A new correctness criterion for
database concurrency control in ACM Trans on Databse Sys 8(4) pg 484-502
Dec 1983

Walter B: Multilevel Synchronization and Nested Transaction in Advanced
Information Sys in Proc GI conference on Database systems for office
automation,engineering and application, 1985

C. Pu in Replicated and nested Transaction from Univ of Washington. This
was a PhD Thesis. TR-86-08-02

Thanks.
Terry
Newsgroups: comp.databases.theory
From: colin@us-es.sel.de (Colin Flanagan (US/ESB))
Subject: b-tree
Keywords: database, b-tree
Organization: SEL-Alcatel LTS Dept. US/ES
Date: Mon, 14 Dec 92 16:37:23 GMT


Sorry if this is the wrong group.

Can anyone tell if there any sources available for b-tree(s) in C/C++.

My requirements are that it is fast, not to costly and/or public domain.
			       ----

I already have a trial version of a product called B-PLUS by Hunter and associates. This seems to be pritty good so if any body knows of their email address or if you are out there get in contact.



			Colin Flanagan
			Stuttgart 
			Germany
From: dtb@otto (David Bath)
Newsgroups: comp.databases.theory
Subject: Re: date -> day of week conversion
Date: 12 Dec 92 10:00:01 GMT
Organization: RMIT Computer Centre
NNTP-Posting-Host: otto.bf.rmit.oz.au

csa09@keele.ac.uk (Paul Singleton) writes:

>Can anyone produce SQL code to convert a date from DD/MM/YY (or MM/DD/YY)
>format into the corresponding day of the week?  I assume that you can
>get at the individual DD, MM and YY fields (as integers?).

>Am I right in thinking that this is *not* the sort of functionality which
>SQL was designed to express, and that in general it is not feasible to
>define a relation by algorithm (in the way that Prolog programmers are so
>accustomed to doing)?

Rumor has it that one SQL based DB, Empress, running on UNIX and VMS,
permits you to define your own functions that can be embedded in the
sql, letting you define that function and then
	select surname, givname
	where	day_of_week(birthdate) = 'Saturday'
	from 	emp;

David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:03-3477511
Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
"Failure to emulate is the best revenge" - Marcus Aurelius
-- 
David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:03-3477511
Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
"Failure to emulate is the best revenge" - Marcus Aurelius
From: carl.pedersen@dartmouth.edu (L. Carl Pedersen)
Newsgroups: comp.databases.theory
Subject: Re: date -> day of week conversion
Date: 15 Dec 92 01:51:07 GMT
Followup-To: comp.databases.theory
Organization: Dartmouth College

In article <1992Dec14.174550.24045@enterprise.rdd.lmsc.lockheed.com>,
stroup@aspen.ops.lmsc.lockheed.com () wrote:
> 
> 
> >
> csa09@keele.ac.uk (Paul Singleton) writes:
> 
> >Can anyone produce SQL code to convert a date from DD/MM/YY (or MM/DD/YY)
> >format into the corresponding day of the week?  I assume that you can
> >get at the individual DD, MM and YY fields (as integers?).
> 
> >
> 
> Maybe I'm missing the point here (or maybe this is an Oracle extension to 
> SQL) but can't you just use the to_char function:
> 
> 	Select to_char(my_date,'DAY') from my_table;
> 
> According to the doc, DAY gives you the name of the day, padded with blanks 
> to a length of nine characters.
> 
> 						judie

Yes.  That is an ORACLE extension, obviously a good one.  Does anyone know
if the SQL92 standard provides something like this?  It doesn't seem to be
mentioned in the Melton/Simon book.

I agree with whoever said this is not the sort of functionality SQL was
designed for, but 	 think it's still be possible to do the translation in a
non-procedural way, depending on what functions are available in your local
SQL dialect.  

In the gregorian calendar, the remainder of the year divided by 400
determines whether or not it's a leap year.  If you can extract the year,
and determine the remainder mod 400, you could use that as an index into a
table of year types (400 rows, values leap or normal).

If you can extract the month, then the month combined with the year type
can be used as a composite key into a table that tells how many days in the
year preceded that month.  (24 rows).

Given all of the above, a complex expression can be written that converts a
date to a number of days since the beginning of year zero.  If you know
what day of the week that was, you can use the result + the beginning day
to look up in a little table of days.

I make no claims that this is the best way to do this.  I also do not claim
that it takes into account any special cases, like historical changes to
the calendar etc.
From: csa09@keele.ac.uk (Paul Singleton)
Newsgroups: comp.databases.theory
Subject: Types in DB query/DML languages
Date: 18 Dec 92 17:28:55 GMT
Organization: Keele University, England

Please can anyone refer me to a survey of academic or commercial efforts
in the area of type schemes and type checking in database query
languages?  Has there been enough work to warrant a survey?!

I am interested in application-specific types, not CHAR and NUMBER.  There
seems to me to be plenty of scope for using type schemes e.g. to check
that a query is plausible, or to disambiguate vague queries.  There seems
to have been lots of work on types in non-database programming languages,
and lots of neglect in the database field.  Strongly-Typed SQL, anyone?!
----
  __   __    Paul Singleton (Mr)           JANET: paul@uk.ac.keele.cs
 |__) (__    Computer Science Dept.        other: paul@cs.keele.ac.uk
 |  .  __).  Keele University, Newcastle,    tel: +44 (0)782 621111 x7355
             Staffs ST5 5BG, ENGLAND         fax: +44 (0)782 713082
Newsgroups: comp.databases
From: David Ruggiero <osiris@halcyon.com>
Subject: Re: Advanced Revelation information request
Originator: osiris@halcyon.com
Reply-To: osiris@halcyon.halcyon.com (David Ruggiero)
Organization: [none - why fight entropy?]
Date: Fri, 18 Dec 1992 08:02:46 GMT

price@helios.unl.edu (Chad  Price) writes:

  CP> ARev, in all of its versions, has what I call a passive data diction-
  CP> ary. The rules and data dictionary can be put in place, but the user
  CP> must explicitly choose to use them. In particular, as mentioned, you
  CP> can completely by-pass the referential integrity rules. In fact, you
  CP> can edit any record, including data dictionary records and compiled
  CP> code, using the ARev text editor...

A very good point, which I would expand upon (possibly to the distress
of some :). Revelation (and the Pick Operating System, upon which its
data model is almost entirely based), can arguably be said not to be a
databases at all, because they impose no rules, constraints, or defini-
tions on the makeup or structure of data (records) in any particular
file - even after the application (database) is up and running.
In this sense, Pick (and Revelation) are only an extremely flexible and
efficient _file_managers_, from which applications which have normal
database-like functions can easily be built.

It is rather like the difference between being given a car versus being
given a machine shop with all the tools necessary to make a car.
Much more power, much more flexibility, much more room to be creative
and produce useful systems in very little time...but much more rope to
do *really* stupid things. (After thirteen years working with
Pick/Rev/ARev/Universe, I know of what I speak).


-- 
David Ruggiero  (jdavid@halcyon.com)       Seattle, WA: Home of the Moss People
Newsgroups: comp.databases,comp.databases.theory
From: gold@ilp.mit.edu
Subject: Logical design experiences?
Organization: MIT Industrial Liaison Program
Date: Wed, 16 Dec 1992 01:56:23 GMT

Hi!
	I am currently working on a large database project and am
trying to convince some co-workers that a quality logical design is 
more than just "window dressing."  I am able to present what I 
believe are fairly detailed explinations of the benefits of creating 
and maintaining a quality logical design on the creation of the 
physical database, the creation of the application program, and the 
maintenance of the system.

	However, since it's difficult for me to come up with many 
scenarios where a poor logical design will cause problems in 
different areas, I am seeking other people's experiences to show these 
co-workers how the logical design affects development and maintanence
of a system.  Please tell me of any positive or negative experiences you
have had with developing databases with or without quality logical
designs.  Any stories would be more than welcome.  If you know of any
studies along these lines, please let me know.  Thank you very much.

				- Mark Gold
				  gold@ilp.mit.edu
Newsgroups: comp.databases
From: "tom frazer" <tom.frazer@canrem.com>
Subject: dbase iv color attributes
Reply-To: "tom frazer" <tom.frazer@canrem.com>
Organization: Canada Remote Systems
Distribution: comp
Date: 15 Dec 92 02:26:55 EST

AB> Is there any way to change color attributes of FMT files in dBASE IV
AB> runtime environment?
AB> I have tried macro substitution, but it doesn't seem to work.
AB> I have also tried to write unique FMT files with SET ALTERNATE ON/OFF
AB> command, but the runtime environment obviously can't use FMT files
AB> instead of FMO files.

    Dbase doesn't use .fmt files, it compiles them into .fmo files and
uses those when running an application. You are better off converting your
.fmt files to .prgs and using memory variables anyway(safer), and you can
use macro substitution, do cases, etc. in the .prg files.

AB> BTW, is it allowed to upload dBASE IV runtime module along with a
AB> pd or shareware dBASE application?

    Wondered about this myself, going to be a _BIG_ file though isn't it.
---
 . MegaMail 2.10 : There's a lot of trial & error here-100% of each
--
Canada Remote Systems  - Toronto, Ontario
World's Largest PCBOARD System - 416-629-7000/629-7044
Newsgroups: comp.databases
From: werner@s1.gov (Nancy E. Werner)
Subject: Need Rtree indexing
Organization: LLNL
Date: Mon, 14 Dec 1992 22:49:54 GMT

I am working on a project at LLNL that requires the rapid retrieval
of geographical data. We plan to store the data using an object oriented 
database system and mass storage.
We need a two dimensional indexing scheme such as Rtree to find the data
for a specified area. Does anyone know of some existing software that
runs on Unix or have some references to some recent algorithms for
developing such software?
Please reply using email. My email address is nwerner@llnl.gov.
Nancy Werner
From: skt@stan.xx.swin.oz.au (TANG S)
Newsgroups: comp.databases
Subject: Help in Rbase!
Summary: Help in Rbase
Keywords: Rbase, Database
Date: 14 Dec 92 06:23:56 GMT
Organization: Comp. Centre, Swinburne University of Tech., Melbourne, Australia

I am a new user of Rbase.  I have a simple problem here with Rbase.  I hope 
someone out there who are familiar with Rbase can help me.  I am using Rbase 3.1.
I want to check if a variable is already in a column of a specified table. 
I have tried several ways, but did not work.  The following are some of the 
IF statements I have tried.


(1)
IF itemid EXISTS (SELECT EE# FROM LTrans WHERE EE# = .itemid) THEN
  ...
ELSE
  ...
ENDIF



(2)
IF itemid IN (SELECT EE# FROM LTrans WHERE EE# = .itemid) THEN
  ...
ELSE
 ...
ENDIF


(3)
IF (SELECT EE# FROM LTrans WHERE EE# = .itemid) IS NOT NULL  THEN
...
ELSE
...
ENDIF


Thanks in advance.  Please email to me.



Newsgroups: comp.databases
From: rogers_m@watson.bms.com (MICHAEL ROGERS)
Subject: Microsoft Access
News-Software: VAX/VMS VNEWS 1.4-b1  
Keywords: SLOW
Organization: Bristol Myers Squibb Pharmaceutical Research Institute
Date: Sat, 12 Dec 1992 16:53:00 GMT

I got Access yesterday, dismayed to learn there is no runtime license 
included, supposed to be a runtime kit in Feb. which will list for $495.

The program is _S_L_O_W_.  It does disk read/writes while nothing seemingly is 
going on, i.e., you're sitting there reading the help screen for a few 
minutes, and the hard drive kicks in for a few seconds for no obvious reason.

I admit I'm a newbie dbms user, but I never thought it would be like this.
Wait for Paradox Win, seems this was rushed to market to get the jump on 
Borland and still needs a good bit of optimization.  


Newsgroups: comp.databases
From: g9utxu@fnma.COM (Tanin Uthayanaka)
Subject: Re: Clipper 5.01 DBF recovery problem
Reply-To: g9utxu@fnma.COM
Organization: Fannie Mae
Date: Fri, 18 Dec 1992 13:49:25 GMT

In article ABaAOBh0x3@consum.moldova.su,  wld@consum.moldova.su (Yakhnenko Vladimir L.) writes:
>      Hi, there!
>  Using Clipper applications corruption of database files sometimes appears.
>Some variables of error object are: CanRetry=.F., CanDefault=.F.,
>CanSubstitute=.F. .  My application perfoms copiing of backup file instead
>corrupted and tryes to open again this area. Error of recovery in
>DBUSEAREA(0) appears, i.e. restarting of application is necessary.
>      Can anybody give more information about this trouble.
>      Regards.
>   ???????????????????????????????????????????????????????????
>   ?     Vladimir Yakhnenko     ? VOICE: SU (0422) 24-41-32  ?
>   ?   wld@consum.moldova.su    ?  FAX:  SU (0422) 24-41-32  ?
>   ???????????????????????????????????????????????????????????


Like No. 5 use to say...need more input.

How many areas and indices do you have opened ? Is the the program consistantly 
crashing at the same location ? Can you use the debugger to stop the program just 
before it crashes and look at all the symptoms that may be causing the crash ? 

TU




Newsgroups: comp.databases