HDTenEightyP/NetNews huggingface dataset:
From: thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040)
Subject: Re: Dateformat in 6.4
News-Software: VAX/VMS VNEWS 1.4-b1  
Organization: NASA/GSFC-Laboratory for Astronomy and Solar Physics
Distribution: usa
Date: Fri, 13 Nov 1992 00:57:00 GMT

In article <1992Nov12.133356.7615@tpghq.com>, sfc@tpghq.com (Steve Caswell) writes...
>In article <1992Nov5.175319.10856@hsr.no> liland@hsr.no (Trygve Liland) writes:
>>
>>
>>I have a problem with the date datatype in Ingres. I use Embedded SQL from
>>my C program. Input to the database is OK, so is the data in the database, 
>>but when it comes to output from the db and into my C variable I have a problem.
>>
>>I have tried to get the date as date_gmt, but it comes out 6 hours wrong, and
>>that is not only in my C program but also in ISQL. My platform is HP 730,
>>HP-UX 8.05. (That is 6 hours wrong GMT)
>>
>>Is there a way to get the date, just as it is in the db ?? I have tried most 
>>off the possibillities in the manual, but it still doesn't comes out rigth.
>>Is it a familiar problem ?, AND is there a solution to it ??

	(stuff deleted)

>The following information may help.  This is an Expert Note from the INGRES
>Advisor explaining a problem INGRES has in returning dates that were input
>during daylight savings time.

	(stuff deleted)

>     The bug appears when Ingres retrieves  a  date  during  DST  that  was
>entered  during  Standard  time  (or vice versa).  Using the above example,
>let's assume '11-apr-91 12:00:00' was entered during Standard time.  There-
>fore,  it  was  stored in the database as '11-apr-91 20:00:00'.  Now, let's
>say we try to retrieve that date during DST.  Once the backend fetches  the
>date,  the  frontend  will  convert  it  by first subtracting the number of
>minutes west of GMT, giving '11-apr-91 12:00:00'.  It then checks to see if
>DST is currently in effect and finds that it is.  Therefore, it adds 1 hour
>to the time, giving '11-apr-91 13:00:00'.  This is not the  time  that  was
> 
> 
> 
>                              April 11, 1991
> 
> 
> 
> 
> 
>                                   - 2 -
> 
> 
>originally entered and this, therefore, is the bug.
> 
> 
>2.  Workaround
> 
>     The workaround is platform specific, but it involves  instructing  the
>operating  system  to  not  automatically  update the system clock when DST
>begins or ends.  This will guarantee  that  Ingres  always  does  the  same
>conversion  for  any date that it has stored.  The disadvantage is that the
>system administrator will have to manually update the system clock twice  a
>year instead of having this done automatically by Unix.  This seems a small
>price to pay compared to the advantages of having a consistent database.

Or, one could ask Ingres to get it right in the first place.

Does this bug also appear in other major database, e.g. Informix, Oracle,
Sybase, etc.

Bill Thompson
Newsgroups: comp.databases
From: isc40004@nusunix1.nus.sg (TAN CHEE YONG)
Subject: Request: Patch for ingres 8.9
Organization: National University of Singapore
X-Newsreader: TIN [version 1.1 PL6]
Date: Fri, 6 Nov 1992 16:15:14 GMT

Hi,

Can anyone mail me the ftp site that contains the patch for ingres 8.9?
I am going to install on in a sun sparc.

Thanks,

Tan Chee Yong
National University of Singapore
email:isc40004@nusunix.nus.sg


Newsgroups: comp.databases
From: AMOUTR01@ysub.ysu.edu
Subject: PD OODBMS (C++)
Organization: Youngstown State University
Date: Thu, 12 Nov 1992 03:38:21 GMT

If anyone is aware of a PD OODBMS that can be utilized by C++ on a PC, please
email me.
 
Thanks,
 
Mark Adams
amoutr01@ysub.ysu.edu
Newsgroups: comp.databases
From: ae2@cunixa.cc.columbia.edu (Amiran Eliashvili)
Subject: Interbase
Keywords: SQL
Reply-To: ae2@cunixa.cc.columbia.edu (Amiran Eliashvili)
Organization: Columbia University
Distribution: USA
Date: Tue, 10 Nov 1992 05:25:08 GMT


Hi all:


	I was wondering if anyone on the net has used Borland's
Interbase. If so , would you mind sharing your experience with me as I
am about to choose either Interbase Or Raima. I am mostly interested
in PROs and CONs of the package. Thanks.


Please send e-mail to ae2@cunixa.cc.columbia.edu
/amiran

Newsgroups: comp.databases
From: fmn@nevada.edu (FRANK NEEDHAM)
Subject: <<<<<INGRES FAQ?????>>>>>>
Organization: University of Nevada System Computing Services
Date: Sun, 8 Nov 1992 23:00:47 GMT

Hi, Could someone please send me info on where I could find the faq for Ingres
or other database programs for the pc?

thanks,
-frank
From: doug@psy.uwa.oz.au (Doug Robb)
Newsgroups: comp.databases
Subject: Re: Clarion language ver3
Date: 11 Nov 1992 01:51:45 GMT
Organization: The University of Western Australia
NNTP-Posting-Host: wapsy.psy.uwa.oz.au
Keywords: Clarion

switzer@alpha.uleth.ca (Dean Switzer) writes:

>Upon reading that Clarion ver3 was going to have mouse support and pull
>down windows etc... I began wondering if a ms-windows version is about to
>surface? Or possibly an interfacing LEM? I am rather happy to be able to
>easily mix graphics and text finally.

But when will this f**** product come out? Clarion originally said
they would have it out by December 1992, It's almost Dec 1993 and
according to their Australian distributor they don't expect it until
March 94. Talk about vaporware! In any case the market has moved so
quickly that what was supposed to be pretty flash in 1992 looks
pretty ordinary in 1994. In the past 18 months I bet they haven't
sold too many version 2.1's. My frustration is that I think it is
(2.1) a good product. If they had only improved it incementally
and DELIVERED they and the rest of us who use the product would
have been better off.

doug@psy.uwa.edu.au

--
email  - doug@psy.uwa.edu.au  ,-_|\    Doug Robb
phone  - +61 9 380 2507      /     \   Psychology Department
fax    - +61 9 380 1006      *_,-._/   University of Western Australia
                                   v
Newsgroups: comp.databases
From: dave@us.oracle.com (Dave Dargo)
Subject: Re: Involuntary rollbacks....does your dbms do this?
Organization: Oracle Corp., Redwood Shores CA
Date: Fri, 6 Nov 1992 23:24:31 GMT
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.

mickan@rossinc.com (Michael J. Andrew) writes:

>Diagnosis:

>    Ingres performs a ROLLBACK whenever an attempt is made to perform
>    an INSERT which fails.


>--------------------------------------------------------------
>Michael J. Andrew	Ross Systems Inc.	(415) 593 2500
>..!fernwood!rossix!mick
>mick@rossinc.com

It's my understanding that the ANSI requires that a failed statement
has no side effects on the transaction itslef:

ANSI requires that if a SQL statement fails, then the results should
be as if the statement never executed.

The behaviour you describe seems odd, are you sure that something else
isn't invalidating the cursor?

Dave Dargo   (ddargo@oracle.com)
Newsgroups: comp.databases
From: dhubb@sierras.com (David B. Hubbell)
Subject: ER diagrammer
Organization: Sierra Software, Friant, CA
Date: Mon, 9 Nov 92 23:04:08 GMT

Can anybody recommend a good package for creating Entity Relationship
diagrams.  I need something that runs on a SparcStation or a PC.
-- 
  /\/\ David B. Hubbell                          VOICE/FAX: 209.822.2768
 /~/\~\ Advovcate Systems/Sierra Software         INTERNET: dhubb@sierras.com
/____\_\ PO Box 347 3950 East Marcus St., Friant, CA 93626-0347
From: DVaz@cup.portal.com (David D Vazquez)
Newsgroups: comp.databases
Subject: Re: Paradox Help again!
Date: Thu,  5 Nov 92 21:23:39 PDT
Organization: The Portal System (TM)

>Hi netter,
>I was wondering if Paradox can perform "calculation" on the data-entry field?
>That is if the user fills in the fields ( ie. qty and price per unit), can the
>field- amount (ie. qty * price per unit) be auto-generated ?

The form designer lets you create (place) calculated fields.

>***********
>Lip Meng, SOH 
>Email: s897336@rubicon.bf.rmit.oz.au
>***********

  -Dave.  "dvaz@cup.portal.com"
From: v125qmam@ubvmsb.cc.buffalo.edu (Ami R Pflugrad)
Newsgroups: comp.databases
Subject: What would make a decent FP2.0 Workstation
Date: 9 Nov 92 04:15:00 GMT
Organization: University at Buffalo
News-Software: VAX/VMS VNEWS 1.41

Hi all,
	Any thoughts on what sort of hardware req's would be
	necessary to run some fox app's via a Novell Lan
	at a reasonably good speed.  The Current setup uses
	Ethernet and twisted pair wiring.  Im looking more for
	CPU, RAM, and Harddisk req's. 

	Thanks a bunch!
	-Ami
From: jbc@cunyvms1.gc.cuny.edu (CASSEL J BRIAN)
Newsgroups: comp.databases
Subject: Anybody use FLEXFILE from GANAHL SOFTWARE?
Keywords: flexfile, ganahl, memo fields
Date: 7 Nov 92 06:31:00 GMT
Organization: Graduate School and University Center, CUNY, New York
News-Software: VAX/VMS VNEWS 1.41


Several years ago, the not-for-profit organization I work at
bought a custom database package from ECHO Software from Conway New 
Hampshire.  One of the four related databases contains a memo field. 
We used to use dBase or FoxPro to access that database to count
how many records had memos, and how long the memos were.  However,
in a recent upgrade of the package, ECHO apparently utilized 
a third-party thing called Flexfile supplied by Ganahl software of 
Deerfield Beach, Florida.  Now we can no longer use dBase or FoxPro
to access the database that has the memofield in it.  ECHO will not
supply a fix, and says we must go directly to Ganahl and they will
give us back our access to our data. 

My question is, has anyone ever heard of Flexfile or used it?  We've
had trouble contacting the company and ECHO won't provide details on
what Flexfile does exactly.  So if anyone has had any experience 
with this, I would appreciate hearing about it.  Thanks in advance.

Brian Cassel
jbc@cunyvms1.gc.cuny.edu

Disclaimed: Not the views of the CUNY Graduate School.
Newsgroups: comp.databases
From: orion@polaris.unm.edu (Tim Guerrette)
Subject: Barcodes and dBASE IV 1.5???
Date: Wed, 11 Nov 92 00:33:37 GMT
Organization: University of New Mexico, Albuquerque

Does anyone know a way to print 9 digit postnet barcodes in dBASE IV? Are there any 3rd party software around that will do that?

Thanks,

-- Tim
Newsgroups: comp.databases
From: les@chinet.chi.il.us (Leslie Mikesell)
Subject: Re: FoxPro Mail Merge Files - Help
Organization: Chinet - Public Access UNIX
Distribution: usa
Date: Thu, 12 Nov 1992 03:55:48 GMT

In article <1992Nov10.170253.29641@mksol.dseg.ti.com> kylscott@mksol.dseg.ti.com (kyl w scott) writes:
>I need help generating a Microsoft Word for Windows mail merge file
>from Foxpro.  Any other word processors would be greatly appreciated
>also.

Wordperfect will take a list where each field ends with <control-R>
<carriage return><linefeed>, and the record ends with <control-E>
<carriage return><linefeed>.  Multiple line fields are acceptable.
Version 5.1 generates a list in a different form than this but it
will still accept this type.

Les Mikesell
  les@chinet.chi.il.us
From: rkinder@iat.holonet.net (Robert J. Kinder)
Newsgroups: comp.databases
Subject: Re: Interfacing Paradox with C++
Date: 7 Nov 92 18:20:31 GMT
Organization: HoloNet (BBS: 510-704-1058)

troj@cwis.unomaha.edu (Kevin Trojanowski) writes:
: nkolluru@cs.umr.edu (THE DEADLY DEVIL) writes:
: 
: >Hello,
: 
: >	I am trying to interface C++ with Paradox to develop a kind of
: >Extended Object-Oriented database system. The database would be maintained
: >in the Paradox RDBMS. The DML (selection, projection, updation) and the
: >DDL (creation, deletion) would be developed as methods in C++. Is it pos-
: >sible to build such a system? I would be grateful if you could give me any
: >information about the paradox engine (how to access?) that provides this
: >interface.
: 
: Borland just release v3.0 of the Paradox Engine, for which you can get
: another add-on called Database Framework, which is supposed to be a set of
: objects which makes the Engine easier to work with.
: 
: I've only worked w/ v2.0 of the Engine, through C.  It's fairly straight-
: forward, once you figure out how to set up a few initial variables.  Basically,
: for every Paradox operation you want to perform (open table, find record,
: retrieve record, modify record, close table, etc) there's a separate C
: function for it.  The manual, I thought, was a little bit intimidating, but
: once you get past it and play for a short time, it's fairly easy to work
: with.
: 
: -------------------------------------------------------------------------------
: -                                   "She had what it took: great hair, a      -
: - Kevin Trojanowski                  profound understanding of strategic lip  -
: - Internet: troj@cwis.unomaha.edu    gloss, the intelligence to
understand    -
: -      CI$: 70521,312                the world and a tiny secret interior     -
: - US Snail: 1905 Thurston Ave, #8    deadness which meant she didn't care."   -
: -           Bellevue, NE 68005                            -Douglas Adams      -
: -                                                          _Mostly Harmless_  -
: ------------------------------------------------------------------------------- 
: 
: 

The Paradox Engine 3.0 is definitely the basis for you C/C++ application
interface.  You can use Borlands Database Frameworks (which is has a
non-intuitive API) or embedded PAL language in C++ using another product
called HorC++Power (horsepower).  HorC++Power has been available since the
Paradox Engine 2.0.  You can get it from Austin Code Works or ISSI at
(407) 997-1612.
-- 
// ------------------------------------------------------------------------
// rkinder@holonet.net            International Software Solutions, Inc.  -
// Robert J. Kinder, Jr.                             Boca Raton, Florida  -
//                                                        1-800-788-4774  -
Newsgroups: comp.databases
From: tim@tim.src.utah.edu (Tim Ma)
Subject: Paradox 4.0 speed (?)
Organization: University of Utah
Date: Thu, 5 Nov 1992 20:51:56 GMT


Two questions regarding Paradox:

1)  Paradox 4.0

An inquiry to all users of Paradox 4.0 out there.  We recently upgraded to 
4.0 after reading articles and ads that highly touted the improved speed of
Paradox 4.0 (claims that it was much faster that FoxPro 2.0).   I am 
impressed with some of 4.0's new features, but SPEED is does not seem to be
one of them.  I have a simple script written in 3.5 that randomizes the order
of records in a file.  All it does it import that file as a single TEXT 
field, tacks on a random number in anothe field, sorts on the random number, 
and then outputs the randomized file.  To my surprise, it runs almost 50% 
slower in 4.0 thanit did in 3.5 (14 minutes vs. 10 minutes).  I'm running a
386SX with 4M of RAM.  Any ideas or comments?

2)  Paradox 3.5 "paradox.net" file

Most of our users are still using 3.5 during our transition.  Does anyone 
know what exactly Paradox does to the paradox.net file?  When we get up to
around 10 users or so, it can take almost 4-5 excruciating minutes just to 
pull up Paradox.  A file server console check shows that stations are placing
an "exclusive lock" on the paradox.net file.  Granted some of our machines 
are 8088's but this wait seems almost ridiculous.  Is there anything I can
do to help speed up the process?

Thanks,

Tim Ma
Associate Programmer
University of Utah
email:  tim@src.cppa.utah.edu
Newsgroups: comp.databases
From: gregb@murphy.com (Greg Banschbach (Unigroup of New York))
Subject: Re: ESQL for PC
Keywords: esql
Organization: Murphy & Durieu, NYC NY, USA
Date: Wed, 11 Nov 1992 15:01:42 GMT

In article <1992Nov9.231329.27955@gtech.com> trp@gtech.com (Tom R. Peterson (consultant)) writes:
>Some friends and I are considering developing a basic
>yet robust esql precompiler to be sold in the $200-500
>range, for the PC and/or Windows/NT market.  Our hope is
>to get reliable SQL into the hands of PC programmers.
>
>I would greatly appreciate input:
>	do such products already exist in that price range?


--> I have heard of one product:  FirstSQL C from FFE Software, Inc.
-->    Price:  About $375 to $395 range.  
--> They claim to have a product which will allow you to either write 
--> 'C' programs which manipulate either a dBase file or their own,

--> OR both,  and 2nd, the ability to enter SQL statements into the source
--> code which will manipulate these files.   

--> The description I have is not THEIR Literature so you should 
--> contact them to get a clearer picture of the product. 

-->   It APPEARS as though they have a Windows/DLL thing also. 

-->   What might be a nice thing to make your product more competitive
-->   is to be able to manipulate Paradox files AS well as dBase, FoxBase
-->   Btrieve, Oracle, Informix .......you get the idea. 
-->
-->
>	does this sound like a usefull thing?
-->     Yes.

>	any suggestions for reference material?
-->     Get the Paradox Engine, or start calling around to some of the
-->     competition to see if you can get royalty free sources for the
-->     needed file formats.   
-->
-->	Good Luck.

		Greg ( gregb@murphy.com )  

OF course the ideas and opinions here are my own and NOT related to 
	Murphy & Durieu
From: paulzhu@ils.unc.edu (Paul Zhu)
Newsgroups: comp.databases
Subject: listserv for comp.databases group?
Date: 13 Nov 92 17:53:18 GMT
Article-I.D.: samba.1992Nov13.175318.21892
Organization: UNC Office of Information Technology

Is there a listserv distribution for this group. I am asking this
for a friend who is on bitnet. Thanks.

--
Paul
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
*  Internet: paulzhu@ruby.ils.unc.edu;  Bitnet: paulzhu@uncvx1.bitnet  *
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Newsgroups: comp.databases
From: sieh@csn.org (David Sieh)
Subject: Case Studies of Distributed Database Systems
Organization: University of Colorado, Boulder
Date: Thu, 12 Nov 1992 03:36:00 GMT


We are starting a project in which we must make a set of databases
available to users over a wide area network...
We are looking for help/advice in designs/implementations of
similar database systems...We are especially interested in case studies.

We are curious about designs/implementations of different architectures
such as:
1. Centralized database servers that users log into to run their
   applications...
2. Truly distributed databases...i.e. data distributed amoung several
   database severs with no redundant data....has the appearance of
   a single database....
3. Distributed databases with redundant data stored at some sites...
   ...strategies for keeping databases consistent and strategies
   for updating each db...
4. Other????

To give a few more specific characteristics of the system we are
working with:

* We will be using a third party RDBMS such as Ingres or Oracle
* A wide area network is already installed 
* All machines over the network "talk" TCP/IP
* There is a near real-time data collection/distribution component
   (i.e. data collected about once an hour needs to be made 
    available to users over the network)
* Most of the data queries need to be through interactive
  data communications...i.e. not batch transfer of files or
  media transfer...

Responses sent directly to me would be greatly appreciated...
(unless you feel this would be of interest to other readers in
this news group)

Thanks -

David Sieh
sieh@cadswes.colorado.edu

Newsgroups: comp.databases
From: mkc1@SARC.MsState.Edu (Michael Cloud)
Subject: ASCII multi-record database editor
Keywords: Prelude ACSII multi-record
Reply-To: mkc1@SARC.MsState.Edu
Organization: Mississippi State Universtiy, School of Architecture
Date: Tue, 10 Nov 1992 17:49:57 GMT

I have a database in ASCII form (Prelude if anyone's familar with that).  Records
are separated by newlines and fields within records are separated by tabs.  What
I need is an editor that can be used to edit multiple records in the database at
once.  A text editor would of course be the easiest thing, but I need something 
that can do validation checks and such.  If anyone can help, I'd be very appreciative
so that I won't have to write the beast myself.  :-)

Thanks

Michael Cloud
mkc1@SARC.MsState.Edu
mkc1@MSSTATE.bitnet



Xref: sparky comp.databases:7780 comp.os.msdos.programmer:10537
From: valnet!herrj@news.cs.indiana.edu (Jonathan Herr)
Newsgroups: comp.databases,comp.os.msdos.programmer
Subject: Re: FoxBase to `C' Contract: How much should I ask for? Help
Date: 11 Nov 92 12:32:26 GMT
Article-I.D.: valnet.RcR3TB2w165w
Reply-To: valnet!herrj@news.cs.indiana.edu
Organization: WVCF, Vincennes, IN, USA
Disclaimer: Author responsible for contents

tpradeep@cs.tamu.edu (Pradeep K Tapadiya) writes:

# Howdy friends,
# 
# I have been approached by a company to write a generic FoxBase to
# `C' converter. The user-interface needs to be converted to "printf"

Sounds like fun!

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

You might try posting to misc.jobs.contract or looking for its FAQ.
Try the latter first.
Newsgroups: comp.databases
From: tleylan@pegasus.com (Tom Leylan)
Subject: Re: Anybody use FLEXFILE from GANAHL SOFTWARE?
Keywords: flexfile, ganahl, memo fields
Organization: Pegasus,  Honolulu
Date: Sun, 8 Nov 92 22:05:43 GMT

jbc@cunyvms1.gc.cuny.edu (CASSEL J BRIAN) writes:

>My question is, has anyone ever heard of Flexfile or used it?  We've
>had trouble contacting the company and ECHO won't provide details on
>what Flexfile does exactly.  So if anyone has had any experience 
>with this, I would appreciate hearing about it.  Thanks in advance.

Brian:  I know Brice De Ganahl and Flexfile.  If you tried to reach him
in the last week or so the difficulty might have been the CA-Technicon
in New York.  I'm quite certain that he would be attending.

Flexfile is a variable-length record library of routines vastly superior
to the memofield concept introduced by Ashton-Tate.

tom
From: davood@CoE.Drexel.EDU (Davood Tashayyod)
Newsgroups: comp.databases
Subject: FOXAPP.APP's Usage
Date: 10 Nov 92 16:37:04 GMT
Organization: Drexel University

Is there a manual or writeup for FOXAPP.APP utility.  I am new to FOXPRO 
so I started my latest project using FOXAPP.APP's Full Project Option. I 
like to use the dbflist array and showpop procedure in my code. I appriciate 
your comments regarding starting new projects using FOXAPP.APP.

Also does any one know of libraries similar to the Compuserve ones on 
Internet.
From: sjk@kepler.unh.edu (Stephen J Kenny)
Newsgroups: comp.databases
Subject: Headers
Date: 9 Nov 1992 19:55:53 GMT
Organization: University of New Hampshire  -  Durham, NH
NNTP-Posting-Host: kepler.unh.edu

Ok ok, I give up.....
We are TRYING to write a program that will interface seamlessly
with the following file formats

xBase
Paradox
Sql
Btrieve

xBase we pretty much got, but the others are real boogers.
Does anyone know where we can get file header info for
these data files? Any help would be greatly appreciated!!!!
-------------------------------------------------------------
"We could all use the hindsight a couple of years from now will
bring."
	-slk

sjk@kepler.unh.edu	s_kenny@unhh.unh.edu     Stephen J Kenny
-------------------------------------------------------------