HDTenEightyP/NetNews huggingface dataset:
From: jfile@bmers3.bnr.ca (Jonathan File)
Subject: dBase 4v1.1:can I change directories on the fly?
Reply-To: jfile@bnr.ca
Organization: Bell Northern Research, Ottawa, Canada
Date: Tue, 26 Jan 93 16:33:33 GMT

I have two dbase applications.  With the DOS 5.0 shell, I could start
two instances of dbase and task swap between my two applications.  This
was fine.  Now I am running windows.  I can't start two instances of
dbase anymore.  I get a resource error when I try to start the second one.
(This may be a result of have DOS share.exe running, but I don't want to
turn that off).

As a work around,
I was thinking about starting my first application up, and when I need
to use the second, I could: close all, switch directories, and start the
second application (and vice versa).  The problem is, I don't see any
way to switch directories once I am in dbase.  The PATH command doesn't
do me much good, since a number of my file names are common to both
applications (although they provide different functionality), so the
files in my current directory would be used, rather than the ones from
the alternate directory.  Opening and closing dbase each time would be
rather time consuming, since I do task swap between these two applications
often.

Does anyone have any suggestions on how to:
- get two version of dbase running in a windows environment with share.exe
  running? or,
- change directories once I am in a dbase session?, or
- something else that will get me out of this pickle?

The only other alternative that I see, is to rewrite parts of one of the
applications to give unique file names and resolve any conflicts between
the two applications, so that they can run together from the same directory.
This would involve a fair bit of work, so I'm looking for something quicker
and dirtier.

Thanks,
-- 
         /                       / /
        /                    ___/_/_
       /  ___  _____    ___    / /__    ___  _____
      /  /   )  /   )  /   )  / /   )  /   )  /   )
 /   /  /   /  /   /  /   /  / /   /  /   /  /   /  __
(___/  (___/  /   (__(___(__/ /   (__(___(_ /   (_  \/
-----------------------------------------------------------------
Jonathan File                            Bell-Northern Research 
                  <insert standard       P.O. Box 3511, Station C
                   disclaimer here>      Ottawa, Ontario
jfile@bnr.ca                             Canada K1Y 4H7
-----------------------------------------------------------------
Newsgroups: comp.databases,comp.unix.sys5.r3,comp.unix.questions,comp.databases.sybase
From: todd@kastle.com (Todd A. Scalzott)
Subject: Accessing MS SQL Server from Unix
Reply-To: todd@kastle.com
Organization: Kastle Development Associates, Arlington, VA, USA
Distribution: comp
Date: Tue, 26 Jan 1993 06:39:12 GMT


We are going to be developing a new application using a SQL database.  All
of our developers have Unix PC workstations (Interactive Unix 3.0.1) which
we've been using to develop the current project, and it would be most
advantageous to keep these as they are.

Already sharing the Ethernet with these boxes is a machine running
Microsoft SQL Server (made by Sybase), which is being used by an inventory
application.  The SQL Server runs on top of OS/2 1.3 and is accessed
through named pipes, currently from workstations running Novell Netware.

Is it possible to connect with the SQL Server from Unix?  What would we
need to do this?  

Thanks.

--
 
Todd Scalzott, Systems Programmer                     todd@kastle.com   
Kastle Development Associates                         ...!uunet!friend!todd

Newsgroups: comp.databases
From: jamesd@techbook.com (James Deibele)
Subject: WANTED: dBASE IV/FoxBase+/Recital
Organization: TECHbooks --- Public Access UNIX --- (503) 220-0636
Date: Tue, 26 Jan 1993 00:32:25 GMT

Have you gone on to a "real" database?  Do you have a copy of dBASE IV,
FoxBase+, or Recital sitting around your SPARC (preferred) or System V
Release 4 box?  Wouldn't you like to sell it so that you can spend the
money on Codd's book?

If so, please let me know and we can arrange terms.

Oh, yeah: FoxPro for UNIX has been "real soon now" for about 2 years.
Anybody want to get a pool going on when it's going to come out?  Or 
does everybody think the sun will have cooled before Microsoft releases
something that might interfere with  Windows NT?

Questions, questions ...

--
jamesd@techbook.COM                   "2091 newsgroups & nothing on ..."  
PDaXs gives free access to news & mail. (503) 220-0636 - 1200/2400, N81  
Full internet (ftp, telnet, irc) access available. Voice: (503) 223-4245
PC GrabDisc - 300 megs of programs every month on CD-ROM - email for info
Newsgroups: comp.databases
From: derwin@mach2.wlu.ca (Daryl Erwin)
Subject: FOXPRO2: Question about defining Function Keys
Organization: Wilfrid Laurier University
Distribution: na
Date: Thu, 21 Jan 1993 17:27:45 GMT

I am trying to assign the FUnction keys to execute things like the
<New> <Cancel> <OK> push buttons that are defined in the Control
subscreen.

Can anyone think of a way to do this without repeating all the
code in each of these things.

Syntax is wrong, but

ON KEY F2 ???GOT <New>; KEYBOARD "chr(13)" 

Or some such thing.. I question whether ON KEY can be used 'cuz
it justs jumps, executes, then jumps back.

Any thoughts on this?
Newsgroups: comp.windows.ms.programmer,comp.databases
From: link@ucunix.san.uc.edu (Virginia Link)
Subject: ESQL products for windows ???
Organization: University of Cincinnati
Date: Fri, 22 Jan 1993 03:21:22 GMT



    I am interested in developing a product on windows in C++ that uses
    a database.  I would like to have  use some type of embedded C
    from which to access the database.  Some obvious choices are Ingres
    and oracle.  They are also very expensive.  The database must offer
    all the usual locking required for a multiuser system.

    Unfortunately, products like FoxPro limit the developer to using
    FOXpro for the rest of the products life by making one develope in
    their language.  Not very Appealing to any serious development.
    I am sure they don't have any problems with this, as
    it makes it impossible to ever switch databases...

    But I do want the ability to switch databases at some point...if the
    need ever arises.

    What would be some suggestions for product that support embedded
    code and possibly SQL ?

    thanks,

    vl

Xref: sparky comp.databases:9406 comp.os.vms:21964
Newsgroups: comp.databases,comp.os.vms
Subject: MAGIC - your opinions please
From: wykes@decus.org.nz (Nick Wykes, Forestry Corporation of NZ Ltd, Rotorua NZ)
Date: 26 Jan 93 08:20:04 +1300
Organization: DECUS New Zealand

We are currently evaluating a 4GL called MAGIC which comes from Israel. It
looks very good on the face of it. I believe it is in wide use in it's home
country, especially in the military.

If you have any experience with Magic, pleasant or otherwise, I would
appreciate your comments. Our site is looking at using it with VAX Rdb/VMS,
but I'm still interested if you are running it on another platform.

I'll summarise to the net if necessary.

Thanks
Nick Wykes
Snr Sys Prog
Forestry Corporation of NZ
Nick@fcnz.co.nz
From: hess@elde1.epfl.ch
Newsgroups: comp.databases
Subject: Clipper and MODEM - HELP
Date: 28 Jan 93 16:18:04 GMT
Organization: Ecole Polytechnique Federale de Lausanne


Hello ... I'm looking for a lib (clipper 5>) to control the Modem.
There a re a lot of pgm in NIC.FUNET.Fi, but the files have no
description ... 

Could you help me ?

PS: .LZH files crash at transfert time with FTP (LHARC -t FileName says to
me "bad CRC ...")

Any idea ?

Please Email me at :

Hess@Elde.epfl.ch

Thanks.
From: chandra@xenon.nabu.sni.ca (Chandra Sekar)
Subject: Do the Bridge Products Provide C API calls? 
Reply-To: chandra@xenon.nabu.sni.ca (Chandra Sekar)
Organization: Siemens Nixdorf, Sietec Open Systems, Toronto, Canada
Date: Thu, 28 Jan 1993 17:15:00 GMT

Would someone help?

in order to develop a database independent application
(one that would run on all DBMS platforms), we could use
any one of the several bridge products that are in the market.

Example: uniface, omnis, jam, focus etc., etc.,

but it appears that all or some of them offer APIs that have GUIs
embedded in the database related calls.

meaning, when you use them in your programs, you will have to necessarily 
use their GUI also in your application.

our situation is that we have our own GUI builder product and we
want to use just the bridge APIs that would help us access DBMS,
without the GUI. (pure C APIs which do not have any GUIs).

Is there any such bridge product?

Please help and thanks in advance.

chandra@sni.ca.
From: torbecvs@ucbeh.san.uc.edu
Newsgroups: comp.databases
Subject: re:Dbase III question
Date: 21 Jan 93 18:18:03 EST
Distribution: world
Organization: Univ. of Cincinnati

In article <93020.210833U56779@uicvm.uic.edu>, <U56779@uicvm.uic.edu> writes:
> I working on a programm where I want to be as easy as possible.
> I created a name field in the .dbf file.  I call it by using
> x=space(20)
>  @12,12 "Enter name " get x picture "!XXXXXXXXXXXXXXXXXXXX"
> read
> 
> This way it will allow user to type name with first letter being
> capitalized.  My question is that is there a way so that last name
> typed after a space within the same field could also have the
> first letter capitalized?
> I would appreciate all the help.
> 
>                                                    -AP.
Well AP, unless you are willing to simply capitalize the whole picture
(EX: PICTURE "!!!!!!!!!!!!!!!!!!!!") I can't think of any way to capitalize the
first letter of the last name while still in the READ.
          You're OPTIONS as I see it:
		1) Use PICTURE "!!!!!!!!!!!!!!!!!!!!" and capitalize the whole
		   thing when getting input, 

		2) Add a last name field (or initialize/get a last name 
                   variable if operating outside .dbf file) and use another
		   picture statement to control the input case of the variable
					or
		3) Alter the variable "x" after the READ is executed.

	The first two options are self explanatory, the last is pretty easy too!
	(with the use of a couple dBASE string functions).

	For #3
   >	nMEMVAR=AT(x," ") ... (check syntax, it may be AT(" ",x), I'm not sure)
                - if there isn't a space, a value will be 0, otherwise
		  the location of the space is returned.

   >	x=LEFT(x,nMEMVAR)+UPPER(SUBSTR(X,nMEMVAR+1,1))+RIGHT(x,20-(nMEMVAR-1))
                    |                 |                      |
                    |                 |                      |
            First Name + space        |                      |
                             Capitalize first letter         |
                                  of Last Name               |
                                                  Remainder of Last Name

       		This will give you the name in the format "Zeke Jones"

	But seriously, it would probably be best to just capitalize everything,
	or use seperate First and Last Name variables.

	Good Luck,  Scott
From: sbk@ebt.com (Bobby Koritala)
Newsgroups: comp.databases
Subject: Representation of textual data in OODBMS
Keywords: text, OODBMS
Date: 22 Jan 93 22:25:09 GMT

Hi
I was wondering if anyone out there had an idea about how you would go about
representing textual data in an OODBMS. Let me be more precise...
When I talk about textual data, I'm talking about things like documents, books
etc.
How would you go about storing a document in an OODBMS? I have an idea of how its
done in relational and hierarchical databases, but I'm not sure how it could be
done in an OODBMS.
Please mail me any replies.
Thanks
Bobby Koritala


Newsgroups: comp.databases
From: davec@wsti.demon.co.uk (David Churcher)
Subject: Re: Foxpro: Reporting/Querying on most recent date in DBF 
Distribution: world
Organization: Welcom Software Technology International
Reply-To: davec@wsti.demon.co.uk
X-Mailer: Simple NEWS 1.90 (ka9q DIS 1.18)
Date: Thu, 21 Jan 1993 17:36:03 +0000

In article <C131HG.4C4@acsu.buffalo.edu> v125qmam@ubvmsb.cc.buffalo.edu writes:

>Hi all!
>        How can I get Foxpro to point to the record containing the most
>        recent date within a group?  For example: 
>
>        The File looks like this:
>
>                        Name    C       20
>                        Date    D        8
>
>        I want to query the most recent Date associated with a given name.
>        The MAX Function requires a list of possibilites...

 SELECT FROM yourdbf MAX(Date) WHERE Name="theNameYouWant" INTO ARRAY target

 with an index tag on Name, will do it, although it will scan each
record with the name you requested to find the maximum date.
Newsgroups: comp.databases
From: dave@ait.com
Subject: Distributed transaction processing with a relational database
Reply-To: dave@ait.com
Organization: Artificial Intelligence Technologies, Inc.
Date: Wed, 20 Jan 1993 22:08:26 GMT


We are in the problem analysis phase for a project to move an existing
mainframe transaction processing system using VSAM, to distributed
workstations and a relational database.  The application must handle
about 500,000 existing customers, periodically calling into the
customer service reps. who handle complaints, new products, cancel
products, etc.  These customers need to be billed for their products,
and the product must be transported to the customer.  The total size
of the VSAM files is now about 2-4 gig of data, with some of this
being historical records.  There will be about 100 users of hte
system, with 50-70 fulltime.  Batch processes will also be running
over the data at various times through the cycle.

I am looking for persons out there that have deployed, or are developing
similar applications, and I would like information on how this can be
accomplished most efficiently.  Specifically:

1) What methods/tools did you use if you used OOA or Design?

2) What platform/workstation/servers are prefered for both development
and deployment?

3) What language(s) did you use, C, C++, Cobol, 4GL?  Did you use any CASE
tools?  E.g. What is a _very_ large, deployed system for C++?

4) How about GUIs and their development tools?  Motif, Windows, Forms?
The ideal situation would take advantage of existing PC hardware
running Windows for the infrequent users, and perhaps an Xterm to a
workstation for continous users.

5) Which database tools were used, Sybase, Ingres, Oracle?

6) I am also looking for any literature I can find on _deployed_ systems
similar to this, books, papers, etc.

Thank you for your input,
dave

________________________________________________________________________
Dave Pracht					phone: (914)347-6860
Director of Applications Development		fax: (914)347-3182
Artificial Intelligence Technologies, Inc.	internet: dave@ait.com
Westchester Co. NY
________________________________________________________________________
Newsgroups: comp.databases
From: lowell@locus.com (Lowell Morrison)
Subject: Re: Format of R:BASE files
Organization: Locus Computing Corporation, Los Angeles, California
Date: Wed, 27 Jan 93 16:45:59 GMT

In article <8303@kielo.uta.fi> helin@vehka.uta.fi (Mikko Helin) writes:
>
>Does anyone out there know where I can get the format of the R:BASE
>files, or even better, the converter program that converts from
>the R:Base format to the DBASE format (or Paradox or plain text format)?
> 
Mike, r:Base come with the converter built in.  The Export feature of
r:base allows export to Dbase, Comma Delimited, Lotus and other formats.

--Uncle Wolf


Xref: sparky comp.databases:9480 comp.object:5088 comp.databases.informix:3076
From: pbenton@vnet.ibm.com
Date: Tue, 26 Jan 93 09:09:45 PST
Newsgroups: comp.databases,comp.object,comp.databases.informix
Subject: Informix 4.0 and 4.1 questions (std engine)

Can anyone help with the following questions ?

We are running SCO UNIX version 3.2 with the Informix standard engine
(ESQL/C version 4.01.UD2 and sqlexec version 4.01.UD2) on an
Intel 386.

We have a process that once started, lives forever, periodically
updating a database by INSERTs or UPDATEs.  For efficiency reasons,
this process PREPAREs all the SQL statements during its
initialization, and then later EXECUTEs the SQL statements to
update the database.

Occasionally, its sqlexec child process terminates.  The parent
process traps the SIGCLD (UNIX) signal and executes a siglongjmp()
(UNIX system call) to recovery code (set up with the sigsetjmp()
UNIX system call).  The recovery code includes calling sqlexit()
and sqlstart() to clean up and start up a new sqlexec process.
The database is then opened again.  However, when the process
again PREPAREs all the SQL statements, Informix returns the error
code -258 "System error--invalid statement ID received by the
sqlexec process".  The process tries periodically to PREPARE the
SQL statements until it's successful, but Informix continues to
return the same error code.  Only in a few cases did Informix
successfully PREPARE some (but not all) of the SQL statements
after several attempts by the process.

*** Question:  What can we do to solve this problem ?
               (Restarting the process is not an option.)


Okay, back to the same process.  When it periodically saves data
in the database, this process can be doing hundreds of INSERTs or
UPDATEs.  To determine whether to do an INSERT or an UPDATE, the
process first attempts to do an INSERT.  Following an INSERT, if
the process detects a negative number in sqlca.sqlcode and the
ISAM error code -100 (in sqlca.sqlerrd[1]), the process does the
following:

   - SELECTs the existing entry from the database,
   - combines the new data and the selected data, and
   - UPDATEs the existing entry in the database with the combined data.

*** Questions:  Is this a good strategy to use ?
                If not, any suggestions ?


The following problem exists with the above scenario ....
Occasionally, when the process detects the existing entry and then
tries to SELECT it, Informix returns SQLNOTFOUND.  When we manually
query the database (using isql) for the existing entry, the so-called
"existing" entry is not in the database !!

*** Question:  Why would this happen ?


Any help would be very much appreciated.  Thank you.


Pauline Benton (pbenton@vnet.ibm.com)
From: cxf12@po.CWRU.Edu (Christopher Fenton)
Newsgroups: comp.databases
Subject: What changed when I...
Date: 28 Jan 1993 11:11:17 GMT
Organization: Case Western Reserve University, Cleveland, Ohio (USA)
NNTP-Posting-Host: slc12.ins.cwru.edu


	Hi Gang:

	I wrote an application that deleted some dos files using the
!del *.* function and it worked fine when I was devloping it on my 
c: drive.  When I moved it out to the Novell disk, it only works if
you specify the complete file name.  If a wildcard is specified it 
returns a file not found message and doesn't delete the file.  I've
made sure I have the approriate write authority for the directory and
now I've run out of ideas...  Anybody got any ideas...

	Thanks...

	C. H. Fenton


-- 
Christopher H. Fenton       "I found that essence rare,
cxf12@po.cwru.edu               it's what I look for...
AIS  Computer Operations           I knew I'd get what I asked for..."
Case Western Reserve Univ.                         --- The Gang of 4           
Newsgroups: comp.databases
From: gaede@faw.uni-ulm.de (Volker Gaede)
Subject: Re: What is an OODBMS?
Organization: FAW (Research Institute For Applied Knowledge Processing, Ulm, Germany)
Date: Fri, 22 Jan 1993 13:23:09 GMT

In article <1993Jan21.120320.5992@fwi.uva.nl>, timmer@fwi.uva.nl (Ralf Timmer (I89)) writes:
|> Hi,
|> 
|> My question is in the subject!
|> 

Ok. I hate answers such as this one too, but the best intro to OODBMS-features
is given in

M Atkinson, F. Bancilhon, DeWitt, Dittrich, Maier, Zdonik
The object-oriented database manifesto
In Proc. 1st DOOD, 1989

In this paper all the features characterising an OODBS are discribed.

	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: smj@jbecpor.demon.co.uk (Martin Jarvis)
Subject: approach
Organization: John Brown E&C Ltd
X-Newsreader: Tin 1.1 PL4
Apparently-To: mail2news@news.demon.co.uk
Date: Fri, 22 Jan 1993 16:02:07 +0000

There is a windows database called approach. I can't remember who makes it.
It will talk to all the big databases (Oracle, dbase, etc). I was quite 
impressed for what it cost (around 200 pounds).

Newsgroups: comp.databases
From: twc@swamp.cacs.usl.edu (Tat W. Chan)
Subject: Test
Organization: The Center for Advanced Computer Studies
Date: Tue, 26 Jan 1993 01:15:26 GMT


HI, this is a test

Newsgroups: comp.databases
From: cargibbs@atlas.cs.upei.ca (Rick Gibbs)
Subject: dBASEIII (DOS) TO MSWORD (MAC)
Organization: University of Prince Edward Island
Date: Thu, 28 Jan 1993 18:33:40 GMT

Here's an interesting situation:

I need to export dBASE (DOS) dbf's to MS WORD (Mac). I am sure that using
ASCII will get the dbf's over to the Mac intact. However, the WORD
documentation mentions that inorder to import ASCII database files, they
should be delimited with TABS! I am not at all familiar with WORD, or Macs
for that matter, and need to know if this is a must rather than commas.

If so, how do I delimit a dbf with TABS? Any help would be GREATLY
appreciated.

Rick Gibbs
cargibbs@atlas.cs.upei.ca

Newsgroups: comp.databases
From: jcole@osiris.cso.uiuc.edu (Joan Cole)
Subject: Re: Another Foxpro Screen Builder Question
Organization: US US Army Corps of Engieneers - Construction Eng Research Lab
Date: Thu, 28 Jan 1993 15:29:32 GMT

I tend not to use the screen builder much, but this question seems to be
asking for something more general.  When I want to control where the cursor
goes next without terminating the read, I increment the _CUROBJ value to the
number of the screen object I want the cursor to go to in the VALID clause
for the object the cursor was on.

Newsgroups: comp.databases
From: mstacey@mcs.kent.edu (Michael Stacey)
Subject: REQ: public domain database mgr recommendation
Organization: Kent State University
Date: Mon, 25 Jan 1993 11:57:49 GMT

Can anyoune recommend a PD database manager?  I am working on a project here at
Kent using ndbm, but the project is outgrowing the database manager.  It would
be nice if I could use multiple indices for a single data file, but any suggestions
would be appreciated.  Thanks.

-- 
+--------------------------------------------------+--------------------------+
| Michael Stacey                                                              |
| mstacey@mcs.kent.edu				   			      |
| Department of Mathematical and Computer Sciences 			      |
| Kent State University				   			      |
| Kent, Ohio  44240				   			      |
+--------------------------------------------------+--------------------------+
From: ken.lundberg@tfd.coplex.com (Ken Lundberg) 
Newsgroups: comp.databases
Subject: microsoft approach db for
Date: 21 Jan 93 21:33: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: vspicer@ccu.umanitoba.ca

FR: ken.lundberg@coplex.com

 On Wed, 20 Jan 1993, vic spicer wrote:

>hello. has anyone out there used "microsoft approach for windows"? a
>friend wants a windows-able multi user (on microsoft's windows-LAN, i
>forget what they call it) database to run his company. toys needed
>include:

 I belive the product you mean is called "Access." This is Microsoft's
 recent entry in the multiuser, GUI, database programming world. I've seen
 a few good reviews, and it will do -all- you mentioned.

 * SLMR 2.1a * ------------------------------------------Ken-in-Kentucky
                                           
Xref: sparky comp.databases.informix:3046 comp.databases.oracle:2932 comp.databases.sybase:733 comp.databases.ingres:2350