HDTenEightyP/NetNews huggingface dataset:
From: price@helios.unl.edu (Chad  Price)
Newsgroups: comp.databases,comp.os.msdos.programmer
Subject: Re: FoxBase to `C' Contract: How much should I ask for? Help
Date: 10 Nov 1992 06:02:05 GMT
Organization: University of Nebraska--Lincoln	
Distribution: usa
NNTP-Posting-Host: helios.unl.edu

rkinder@iat.holonet.net (Robert J. Kinder) writes:

>tpradeep@cs.tamu.edu (Pradeep K Tapadiya) writes:
>: I have been approached by a company to write a generic FoxBase to
>: `C' converter. The user-interface needs to be converted to "printf"
>: kind of statements. The database calls need to be converted to
>: db-vista calls. Efficiency doen't seem to be an important
>: consideration. 
>: 
>: 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. Since this is my first break, I do not
>: wish to loose this contract. Would the experienced readers on the
>: net advice me on how much I should bid for this contract? Any
>: kind of advise/strategy is appreciated.
>: 
>Whooaaahh!  Converting by hand wouldn't be so bad, but an automatic
>translator will be a real *big* project.  My gut feeling would be 2 real
>solid people for 14 months, if they know FoxBase, db-Vista, and C inside
>and out with compiler/interpreter experience.

> Lots of good comments omitted! <

I agree that it will be a LARGE job. I have also been asked to similar work
and have without exception turned it down when asked to work on a job like
that on anything but a time and materials basis. It actually sounds as if the
company does not understand enough of what is involved to know what they are 
asking for!

Approach this one very cautiously! and make sure ahead of time that both you
and the comany know what the contract is. If the company cannot agree to
the multistep approach, starting with a feasibility study and a definite
contract you may want to pass on the job. 

My experience with Foxpro is limited to a couple of months of attempting to
understand enough to write a small database. I was very unimpressed with 
the documentation, and think that if you don't already know it, you will have
trouble. Remember that there data entry screens are based on a very inter-
twined mixture of painted screen template and actual program code. It is
not clear to me how you would go about doing a direct translation of that
and I would be more prone to thinking that you should do hand translations
based on functionality.

my $.02

--
chad
price@helios.unl.edu
cprice@molecular.unmc.edu
Xref: sparky comp.databases:7805 comp.databases.oracle:2192 comp.databases.ingres:1871
From: hans@iris.mincom.oz.au (Hans Plambeck)
Newsgroups: comp.databases,comp.databases.oracle,comp.databases.ingres
Subject: Re: DB Comparison - DISAPPOINTING RESULTS
Date: 12 Nov 92 21:34:54 GMT
Organization: Mincom, Brisbane, Australia
X-Newsreader: TIN [version 1.1 PL6]

Understandable, because this question pops up every few weeks/months or so.
I responded twice, but never a summary got posted.
Jun92 Ed.Steinman@.... was collecting Oracle/Ingres comparisions, maybe
he is in a position to post one. (The address is on purpose truncated)

Should be really some sort of regular posting, maybe even part of a FAQ.

-- 
Hans-J Plambeck   Mincom Pty Ltd       hans@mincom.oz.au  +61 (7) 364 9999
Newsgroups: comp.databases
From: cpetersn@iastate.edu (Clifton R Peterson)
Subject: Re: Abstract DATA storrage
Keywords: Abstract database
Organization: Iowa State University, Ames IA
Date: Fri, 13 Nov 1992 20:51:27 GMT

In <1992Nov13.170506@cc4.kuleuven.ac.be> stud11@cc4.kuleuven.ac.be (Lode Vande Sande) writes:
You might want to check AREV by Revelation Technologies.  It allows for 
variable length records and fields within the records up to a current max
of 64K per record.  It has the abilities to do intertable links in whatever
fashion you design.  It has SQL query incorporated into it.

I'm not sure that it'll do what you're thinking of but it might be worth
investigating more deeply.  By the way, it only runs on ibm/ms style DOS.

I'm not associated with Revelation Technologies in any way other than I
develop in AREV so I like to see its user base get larger so it becomes an
even more stable product.  It has evolved continually over the last 10 years
from a near PICK spinoff to much more (at least as far as I can tell by
listening to the old timers that use it).

>Hello I would like to make a relational database for abstract objects.

>Ex: I would like to link VIRTUAL_POSITIONS to other VIRTUAL_POSITIONS and
>FILES to those positions to get a filesystem (Virtual). I also want to link
>some kind of ofbjects to the files. (Ex: A mail or a book).

>Till now I haven't found a databse being able to store an abstract amount of
>data.

>Do I really need to write it myself AGAIN ?

>Thankx.
-- 
 _________________________________________________________________________
/ Clifton R. Peterson    1108 Burnett		(515)232-5254	    	  \
| B.S. Chem E            Ames IA  50010                                   |
\_______________"42"_is_one_hell_of_an_answer!!___________________________/
Newsgroups: comp.databases
From: wright@hsi.com (Gary Wright)
Subject: Looking for DAL, XA, EDA/SQL info
Organization: 3M Health Information Systems, Wallingford CT
Date: Fri, 6 Nov 1992 21:15:07 GMT

Can anyone provide details on DAL, XA, or EDA/SQL?  I'm looking for
source documents, comparisons of the approaches, vendors
and software that support the standards etc.

I'll summarize any information I get.
-- 
Gary Wright                                                 ...!uunet!hsi!wright
3M Health Information Systems                                     wright@hsi.com
From: mt1p+@EDRC.CMU.EDU (Michael Terk)
Newsgroups: comp.databases
Subject: Price information for Sybase, Oracle, Informix
Date: 5 Nov 92 21:50:09 GMT
Distribution: usa
Organization: Carnegie Mellon University

I need to find out price information for Sybase, Oracle and Informix running
on DecStation 5000/240. Does anybody have e-mail addresses or phone numbers
for the marketing depts of these companies? 

Thanks in advance,

M. Terk
mt1p@cs.cmu.edu
Newsgroups: comp.databases
From: thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040)
Subject: Re: Price information for Sybase, Oracle, Informix
News-Software: VAX/VMS VNEWS 1.4-b1  
Organization: NASA/GSFC-Laboratory for Astronomy and Solar Physics
Distribution: usa
Date: Fri, 6 Nov 1992 14:16:00 GMT

In article <Bx9JBo.4L8.1@cs.cmu.edu>, mt1p+@EDRC.CMU.EDU (Michael Terk) writes...
>I need to find out price information for Sybase, Oracle and Informix running
>on DecStation 5000/240. Does anybody have e-mail addresses or phone numbers
>for the marketing depts of these companies? 

The following should help you

Bill Thompson
===============================================================================
A while back I asked for names of vendors of SQL relational database engines
for Unix.  I got a number of responses, some of which were posted to this
newsgroup, and some of which were E-mailed to me directly.  I thank everybody
who responded.

The responses I got covered a wide range of issues.  Rather than try to list
them all, I've decided to list only those companies I've been able to track
down as meeting my specifications.  All of the companies listed supply
(back-end) relational database engines.  Many also supply other (front-end)
database products, but that was not the focus of my current survey effort.  All
support SQL, either directly or indirectly through support products, which was
a hard requirement at our site.  Each of these products will run on a mix of
Unix platforms, and may run in other OS environments as well, such as VMS or
DOS, although again the focus of the survey was Unix.

I make no claims for any of these products.  Nor do I claim that the list is
complete.  If anyone knows of any other database engines meeting our base
requirements (SQL, Unix) not listed here, I would be happy to hear about them.
The products are listed in alphabetical order.

Bill Thompson

===============================================================================
c-tree Plus				Faircom Corporation
					4006 West Broadway
					Columbia, MO 65203

					800-234-8180


Informix				Informix Software, Inc.
					4100 Bohannon Drive
					Menlo Park, CA 94025

					800-331-1763


Ingres					Ingres
					An ASK Company
					1080 Marina Village Parkway
					Box 4026
					Alameda, CA 94501

					800-4-INGRES


Interbase				Borland
					1800 Green Hills Road
					P.O. Box 660001
					Scotts Valley, CA 95067-0001

					800-245-7367


Oracle					Oracle Corporation
					20 Davis Drive
					Belmont, CA 94002

					800-345-DBMS


Progress				Progress Software Corporation
					14 Oak Park
					Bedford, MA 01730

					617-275-4500


Raima Data Manager			Raima Corporation
(formally db_VISTA III)			Lincoln Executive Center III
					3245 - 146th Place SE #230
					Bellevue, WA 98007

					800-DB-RAIMA


Sybase					Sybase, Inc.
					6475 Christie Avenue
					Emeryville, CA 94608

					800-8-SYBASE


Unify 2000				Unify
					3901 Lennane Drive
					Sacramento, CA 95834-1922

					800-24-UNIFY
Newsgroups: comp.databases,comp.sys.ibm.pc.misc
From: lindsey@tincup.enet.dec.com (Randy Lindsey)
Subject: Re: Read-Only .dbf Files in FoxPro 2.0
Organization: Colorado Software Solutions, Inc.
Date: Thu, 5 Nov 1992 19:16:50 GMT


In article <1cvmhnINN8to@iskut.ucs.ubc.ca>, comm117@unixg.ubc.ca (Chin) writes...
> 
>I am using FoxPro 2.0 on Novell 3.11.  I flagged my dbf files as SRO 
>(shareable read-only) using the "flag" command in DOS.  However, I now need 
>to change the data on those files.  "Simple enough", I thought,
>"I'll just use the flag command again and change it to SRW (shareable 
>read-write)."  
> 
>The problem is, once I do that, FoxPro will not let me open the database.
>I need to change it back to SRO before I can open it.  Of course, I can't
>edit the database, so either way, I'm stuck.  Does anybody have any
>ideas on where to start before I go off screaming and mindless pandemonium?
> 
>- Gavin

Hmmm, haven't encountered that, and I almost always work on a 3.11 network.
I assume you're using "native" Foxpro commands or menus to USE the DBF's,
not a program you or someone else wrote.  If not, try that.

Also, try flagging one of the DBF's to NSRW (non-shareable, read-write).
I've never flagged my DBF's, so the shareable attribute may be causing
trouble.

Good luck,
Randy
Newsgroups: comp.databases
From: ua121aa.sun1.lrz-muenchen.DBP (Stephan Saur)
Subject: small TSR database with easy to use paste function WTD
Keywords: TSR, paste, dos
Reply-To: ua121aa@sun1.lrz-muenchen.dbp.de
Organization: Institut fuer Philosophie II, JENA-Projekt              Universitaet Muenchen (Germany)
Date: Thu, 12 Nov 1992 13:10:50 GMT


  I'm looking for a small and simple general purpose database
  for text-based applications with the following features: 
 
  - It should work as TSR in parallel with spreadsheets, word
    processors, modem programs, databases or other
    applications.  Instantaneous swapping to memory or disk
    would be nice. 
    
  - The cutting and pasting of a chosen record should be
    easily handled. Ideally a single keystroke should perform
    it.   
    
  - In order to improve search performance the database files
    should be indexed.   
   
  I am not looking for an all-singing all-dancing database
  management system. Simplicity should be the overriding
  factor. The goal is merely to paste adresses, bibliographic
  references etc. in a word processor.
 
  Yes, I have looked on archive sites. I am aware of ZEPHYR,
  dLITE, FASTFILE, READYREF, SIDEKICK, and the desktopmanager
  which comes with PCTOOLS, but none of them provides all the
  features I imagine. 
 
  The main problem with these programs is that the cutting and
  pasting of a record is much too much complicated. It can be
  a nuisance getting at the information you require and paste
  it in your application. To give an example I quote the
  manual of ZEPHYR 2.0, a database manager which can be loaded
  as TSR and which provides a cut and paste utility:

    "The cut and paste functions are executed OUTSIDE of
    Zephyr only at this point. To block text from the top of
    the screen to a particular point on the screen and save
    it to the clipboard file, press <ALT-DEL> keys and move
    the cursor keys to highlight the desired text. Then
    press <ENTER> to complete the save. To paste the text
    which has been cut to the current position on the
    screen, press <ALT-INS> keys simultaneously." 

  What an awkward procedure!

  Can anyone recommend a database, whether commercial or
  shareware, that has the afore-mentioned features? I'd write
  it myself, but I've never written a TSR and can't afford the
  time to learn how now. 
  Any suggestions will be greatly appreciated. 

  Thanks in advance. 
 
  =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
  Stephan Saur  
  Institut fuer Philosophie II der Universitaet Muenchen, 
  Geschwister-Scholl-Platz 1, D-8000 Muenchen 22 
  Internet: ua121aa@sun1.lrz-muenchen.de 
  =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Newsgroups: comp.databases
From: leeshyan@iti.gov.sg (Chan Lee Shyan (SE))
Subject: OODB recommendation needed
Reply-To: leeshyan@iti.gov.sg
Organization: Information Technology Institute, National Computer Board, S'pore
Date: Thu, 5 Nov 1992 14:07:29 GMT

Hi, 
       We need to use a data base in our Smalltalk/V project on a PC.  Can anyone on the net
recommend any OODB that you may have heard of or have experience on ?  If a relational
database is easily adapted to be used in our Smalltalk environment, it can be considered too.

       Would appreciate it if the contact address and prices of the databases can be obtained.

       Thanks in advance.

Please reply to leeshyan@iti.gov.sg

Lee Shyan
From: mmcgovern@hayes.com
Newsgroups: comp.databases.oracle
Subject: Version Control of Oracle in Unix
Date: 11 Nov 92 14:26:07 EDT
Organization: Hayes Microcomputer Products, Norcross, GA

We are in the process of evaluating SCCS/RCS for version control
of Oracle 6.0 software in our Unix environment.  Any comments,
suggestions, experiences would be appreciated.  Thanks!
From: rz34@rz.uni-karlsruhe.de (Schillinger)
Newsgroups: comp.databases.oracle
Subject: "Show Keys" Problem in Motif (Summary)
Date: 5 Nov 92 07:38:38 GMT
Reply-To: rz34@hp850.rz.uni-karlsruhe.de
Followup-To: "Show Keys" Problem in Motif
Organization: University of Karlsruhe, Germany

Thanks to those of you who responded to my question.  For anyone who
missed the original post, the problem was that I changed the default
function key mapping (in moraterm.r using oraterm) and, although the 
new keys worked, when I pressed "Show Keys" the old keys were still listed.
(It should change automatically, as for other resource files, I assume.)

Well, one netter said he'd had the same problem and ORACLE said it was
a bug and he THOUGHT he'd gotten a patch for it (he couldn't recall exactly).

Another netter said he'd come across the problem too and had given up as
it was just too confusing for the users. (My sentiments exactly.)

So, I called our ORACLE Hotline and was sent a nifty little fax of juicy
tidbits called "Guidelines for Usage of Bitmapped SQL*Forms 3.0 and
SQL*Menu 5.0".  It's written by Henry Ong and Elaine Teoh (dated July 8, '92).
I'd LOVE to type the whole thing up and send it to anyone interested,
BUT with the speed of my typing, that'd take forever.  

Here's the "solution" to my problem though:
"Editing the moraterm.r and oloraterm.r file is not supported with the
current version of oraterm - which is a character mode product.  Until
a bitmapped version of oraterm is available, ORACLE does not support
editing the moraterm.r and oloraterm.r files.  This is clearly documented
in the README under $ORACLE_HOME/mprodins and $ORACLE_HOME/olprodins.
(Bug #93002,#110962,#110963)."

(Note: I couldn't find that README file.)

Karen :)
rz34@hp850.rz.uni-karlsruhe.de
Newsgroups: comp.databases.oracle
From: cathy@cc.uow.edu.au (Cathy Nicastri)
Subject: ORACLE SERVER for Netware 3.1
Organization: University Of Wollongong
Date: Wed, 11 Nov 92 00:11:09 GMT


Is there anyone using Oracle Server for Netware 3.1.  If so could you
send me details on your setup and problems you may have encountered.

I am trying to decide between Oracle on Unix or Oracle Server for Netware.

Currently have 40 pcs running in a Novell environment with access to Unix
from the WAN.

Please email details to:  cathy@wampyr.cc.uow.edu.au
From: fragante@unixg.ubc.ca (Gv Fragante)
Newsgroups: comp.databases.oracle
Subject: SQL*REP - how to reset &Page variable to 1
Date: 11 Nov 92 01:11:49 GMT
Organization: The University of British Columbia
NNTP-Posting-Host: unixg.ubc.ca

I remember seeing this question posted a few months back but missed reading it.
So if anyone can remember, how can I reset the page number to 1 after a group
break ? Also, how can I make SQL*REP pause after each group break ? I need
the pause to allow the user to insert a special stationary into the laser
printer.

Thanks.
Newsgroups: comp.databases.oracle
From: andy@homebase.vistachrome.com (Andy Finkenstadt)
Subject: Re: Need help with Forms 2.3
Reply-To: andy@homebase.vistachrome.com
Organization: Vista-Chrome Incorporated
Date: Fri, 6 Nov 1992 17:04:26 GMT

You will probably want to do something similar to the following:

 -- THIS ASSUMES the block is QUERY ONLY.  Inserting may be problematic.

Create a multi-record BLOCK1 whose base table is reflected onto TABLE1.
As a POST-QUERY trigger on BLOCK1 issue a SELECT col2,col3 FROM TABLE2,TABLE3
WHERE {join table2 table3 conditions} AND {join table 1 in :BLOCK1.COL1
to TABLE2 or TABLE3}, with the NOFAIL {return success on failure, don't
stop} trigger option set.  Now - as KEY-STARTUP at form level put
#exemacro entqry; (or exeqry)

This will populate each row of BLOCK1 on the screen, and the POST-QUERY
will select the corresponding data from TABLE2 and TABLE3.

-Andy


sstasuke@ncrsoph.Sophia.NCR.COM (Steve Stasukewicz) writes:
>I'm using Forms 2.3 with Oracle V6 and have the following problem:
>
>I'm trying to create a multi-row block that contains 3 columns of data.
>Each column on the form comes from a different table in the database.
>I have the block defined to have 10 rows.  If the query retrieves more than
>10 rows I would like to be able to scroll downwards when I reach the last
>row on the screen.  My first problem is how to populate the block.
>Currently I have something like this that doesn't work at all.
>
>select table1.field1, table2.field2, table3.field3
>into   block1.f1, block1.f2, block1.f3
>from   table1, table2, table3
>where  ( join condition to join 3 tables )
>
>This will retrieve a single row and put it into the correct fields on the
>form, but it will not populate rows 2 thru 9 in the block.   ( I know there
>is more than 1 record that meets the criteria.)  What am I doing wrong?
>If it's not already obvious, I'm new to Forms.  Please HELP!
>
>Thanks in advance.
>Steve 
>---------
>Steve.Stasukewicz@sophia.NCR.FR     
>NCR Europe Group ISS/ECS
>Espaces De Sophia
>25 Route de Lucioles                   Tel. (33) 92.94.45.12
>06560 Valbonne FRANCE                  Fax. (33) 92.94.45.45
>-- 
-- 
Andrew Finkenstadt, Vista-Chrome, Inc., Homes & Land Publishing Corporation
GEnie Unix RoundTable Manager, andy@vistachrome.com, andy@genie.geis.com.
  Send mail to ora-request@vistachrome.com to join Unix, CASE, and 
  Desktop Oracle RDBMS Database discussions.
Newsgroups: comp.databases.oracle
From: pkm1@Ra.MsState.Edu (Praveen Mereddy)
Subject: Invoking SQLReports from a C program
Organization: Mississippi State University
Date: Thu, 5 Nov 1992 23:16:57 GMT

I have to use. I don't know much about SQLMenus, so I want to use
'C' for this purpose.  Do U know the commands that invokes Reportwriter
from a C program.  I don't know how to send parameters to the reportwriter
from the Main program.

For example:

I want to print a report on the EXPENDITURE of a company from 
----- date, to ------------ date.

I have a table ITEM, which contains ITEMID, DATE, COST, etc.

OR

2.   If I give the vendorid = ---------, then it should print all the
equipment received from the vendor.  I have all the required tables.

for this example I have a table caled EQUIP_VENDOR which contains
EQUIPID, VENDID.

Thanks for sparing some time for me

Praveen
pkm1@ra.msstate.edu
From: danny.ingram@business.gatech.edu (Danny Ingram)
Newsgroups: comp.databases.oracle
Subject: Fund Accounting Users
Date: 6 Nov 92 21:12:52 GMT
Organization: Georgia Institute of Technology

The Government group of the Oracle Applications User's Group is looking for 
fund accounting sites who use Oracle's Financials Applications.  OAUG needs
input on the directions Oracle should take in developing Financials 
products (ie Government Financials) which will incorporate fund accounting.
We are also looking for input on the development of a Grant Management 
Module for the Government Financials products.  If you are interested in 
providing input on this topic contact Danny Ingram,OAUG Chair of Government 
Enhancements, at (404) 894-5518.
From: vgokhale@us.oracle.com (Vipin Gokhale)
Newsgroups: comp.databases.oracle
Subject: Re: Stripping Oracle Executables on UNIX
Date: 10 Nov 92 05:11:45 GMT
Reply-To: vgokhale@us.oracle.com
Organization: Oracle Coproration, USA
X-Disclaimer: This message was written by an unauthenticated user
              at Oracle Corporation.  The opinions expressed are those
              of the user and not necessarily those of Oracle.


--
In article <syscrc.720831313@gsusgi1.gsu.edu>, syscrc@pickle.gsu.edu
(Randy Carpenter) writes:
>Newsgroups: comp.databases.oracle
>From: syscrc@pickle.gsu.edu (Randy Carpenter)
>Subject: Stripping Oracle Executables on UNIX
>
>We just installed Oracle 6.0.32 on our Silicon Graphics 4d/280gtx
>running
>IRIX 4.0 (UNIX).  The installation is taking up a whopping 175 MB of
>disk.
>We noticed that many of the Oracle executables are not stripped which
>is
>(probably) a waste of disk space.
>
>Is it safe to strip them or will Oracle break?
>
>-- 
>=======================================================================
>=====
>Randy Carpenter                    rcarpent@gsu.edu          % Got a
>light?
>Georgia State University           (404) 651-2648            No match.
>Wells Computer Center                                        %
>

It is safe to strip executables. Often times should the program run into
un-recoverable error, we generate trace files, for which need symbol table
information. I'd suggest *not* stripping atleast "oracle" executable.
Newsgroups: comp.databases.oracle
From: joefw@eosdev1.gsfc.nasa.gov (Joe Fulson-Woytek)
Subject: Re: Getting out of Monitor
Reply-To: joefw@eosdev1.gsfc.nasa.gov (Joe Fulson-Woytek 
Organization: NASA/GSFC, Code 902
Date: Wed, 11 Nov 1992 20:34:32 GMT

Just to follow-up on my earlier posting on getting out of Monitor when
accessing an SGI from a SUN:  It turns out that using VT100 as the
terminal type did not work, but using SPARCXT works just fine.

THanks to all who offered suggestions.


Joe Fulson-Woytek
Code 902/Goddard DAAC
NASA/Goddard Space Flight Center
joefw@eosdev1.gsfc.nasa.gov