HDTenEightyP/NetNews huggingface dataset:
From: rhaven@cruzio.santa-cruz.ca.us
Newsgroups: comp.databases
Subject: Re: Paradox 4: Problem with PushButton and ShowDialog
Summary: Cancelled a ShowDialog resets variable values
Date: Wed, 16 Dec 92 19:52:16 PST
Reply-To: rhaven@cruzio.santa-cruz.ca.us



Cancelling a ShowDialog rolls the PAL variables back to the value they
had before the ShowDialog started, including unassigned.  Use 'retval'
to determin if a dialog was accepted or cancelled.

Cheers
From: mireley@arnou.cem.msu.edu.brewery (John D. Mireley)
Newsgroups: comp.databases
Subject: Unify mailing list
Date: 16 Dec 92 18:56:20 GMT
Reply-To: mireley@arnou.cem.msu.edu.brewery
Organization: Michigan State University Department of Chemistry

What is the address for the Unify Mailing list.


---
From: steve.silverwood@filebank.cts.com (Steve Silverwood)
Newsgroups: comp.databases
Subject: Clipper: corrupted indexe
Date: 17 Dec 92 12:43:00 GMT
Reply-To: steve.silverwood@filebank.cts.com (Steve Silverwood)
Organization: The File Bank BBS - Fallbrook, CA  619-728-4318


 >From: klooster@mswe.dnet.ms.philips.nl
 >Newsgroups: comp.databases
 >Subject: Clipper: corrupted indexes
 >Message-ID: <1992Dec2.093439.131100@mswe.dnet.ms.philips.nl>
 >Date: 2 Dec 92 09:34:39 +0100
 >
 >I have a problem with a Clipper program that runs under OS/2.
 >Frequently it occurs that the index files get corrupted. The
 >people who use the program have assured me that they close the
 >program the right way, i.e. by first closing down the application and
 >then shutting down OS/2. The application keeps constantly about
 >10 databases with a total of about 20 indexes open. Anyone got
 >any ideas what happens? Are there people with the same problems?
 >
 >Thanx,
 >
 >Richard

Richard -- What version of Clipper, and what version of OS/2?

//Steve//

/----------------------------+---------------------------------------\
|Steve Silverwood            |  Internet: 76703.3035@compuserve.com  |
|Computer Associates         |CompuServe: 76703,3035                 |
|300 Corporate Point, 2nd Fl.|     Voice: (310)348-4448              |
|Culver City, CA  90230      |       FAX: (310)348-7701              |
+----------------------------+---------------------------------------+
|The opinions expressed here are solely my own, mainly because nobody|
|else would want them....                                            |
\--------------------------------------------------------------------/
Newsgroups: comp.databases
From: calistri@oracorp.com (Randy Calistri-Yeh)
Subject: Info wanted: real-time dbms
Keywords: real-time dbms signal processing C
Organization: ORA Corporation
X-Newsreader: Tin 1.1 PL4
Date: Thu, 17 Dec 1992 20:35:51 GMT


Does anyone have any experience with using a commercial database package
to support a real-time signal processing application?  The DBMS must run
on an IBM RS-6000, and must be fully embedded in the application (i.e.,
all access must be via C function calls).  Incoming data will be at the
rate of tens of megabytes per minute, and the data must be manipulated
and abstracted several times per second.

______________________________________________________________________

			==> Randy <==

Randy Calistri-Yeh            calistri@oracorp.com
ORA Corporation               (607) 277-2020
301 Dates Dr.       	      Fax: (607) 277-3206
Ithaca, NY 14850-1313         
______________________________________________________________________
Newsgroups: comp.databases
From: thomasd@tps.COM (Thomas W. Day)
Subject: Re: Foxpro 2.0 on a network
Organization: Telectronics Pacing Systems
Date: Wed, 16 Dec 1992 15:41:45 GMT

In article <viking.724200344@vincent2.iastate.edu> viking@iastate.edu (Dan Sorenson) writes:
>        I have no idea what 2.5 is going to be like.  Somebody mentioned a
>"six pack" network version.  If I have to pay extra for more than six users,
>I'm sticking to version 2.0 -- I refuse to limit my software licenses.

I agree, but from what I've heard, that is going to be the case.  Microsoft 
doesn't understand the Foxpro developer userbase.  They must think that 
speed is the only reason developers picked Foxpro.  If that is their game, 
they are in trouble, because Microsoft has never been very good at fast 
programs.
Newsgroups: comp.databases
From: remilld@ccu.umanitoba.ca (Jason Remillard)
Subject: HELP::  Dbase IV to Q&A
Organization: University of Manitoba, Winnipeg, Canada
Date: Sat, 19 Dec 1992 21:27:29 GMT

Hello everyone!

	I think I already know the answer to this one, but can you
transfer the menu and .prg files to Q&A from Dbase?  I have a contract
with a person in the city and she would like to use Q&A instead of Dbase for herqueries and searches..  I would like to save any programming time if possible.  Her budget is small, so ANY suggestions would be appreciated.

BTW, she is totally computer illiterate and simply importing from Dbase to Q&A for her searches is not feasible...



Any Suggestions?  I tried the Dbase group twice but got no responses..


Thanks.

-- 
-----------------------------------------------------------------------------
Jason L.M. Remillard		REMILLARD@ceddwntwn.lan1.umanitoba.ca
MicroLab Assistant		Jason_Remillard@UManitoba.CA
University of Manitoba		REMILLD@ccm.umanitoba.ca
From: rhaven@cruzio.santa-cruz.ca.us
Newsgroups: comp.databases
Subject: Re: Paradox 4.0 Workspace Question
Summary: Stacked windows in Paradox 4.0
Date: Wed, 16 Dec 92 20:04:14 PST
Reply-To: rhaven@cruzio.santa-cruz.ca.us



I'm not sure what you want to do, but a full-screen, frameless canvas
makes a dandy canvas.  You can move it to 500,500 when you want it
to dissapear and move it back instantly.  As for your form, think about
having another full-screen, frameless canvas _under_ your form
(which would also be frameless and positioned in the center of your
screen).  You could paint your heart out on the canvas in the
background while the form was visible and active.

You can also paint forms fairly easily.

I hope this helps

Cheers
From: steve.silverwood@filebank.cts.com (Steve Silverwood)
Newsgroups: comp.databases
Subject: HOW ABOUT comp.data.Clipp
Date: 17 Dec 92 12:43:00 GMT
Reply-To: steve.silverwood@filebank.cts.com (Steve Silverwood)
Organization: The File Bank BBS - Fallbrook, CA  619-728-4318


 >Newsgroups: comp.databases
 >From: thompson@titan.trl.OZ.AU (David Thompson)
 >Subject: HOW ABOUT comp.data.Clipper
 >Message-ID: <1992Nov26.045601.21102@trl.oz.au>
 >Date: Thu, 26 Nov 1992 04:56:01 GMT
 >
 >In response to 'How about ... Paradox'
 >Why not 'comp.database.clipper'
 >Users of Clipper have specific queries and problems and generally do not
 >relate to any other Database Software,
 >It would be easier to find, and answer queries!
 >
 >
 >
 >Just a Thought
 >
 >
 >Dave T.
 >d.thompson@trl.oz.au
 >Telecom Research labs
 >Melbourne. Australia


It gets my vote!

//Steve//

/----------------------------+---------------------------------------\
|Steve Silverwood            |  Internet: 76703.3035@compuserve.com  |
|Computer Associates         |CompuServe: 76703,3035                 |
|300 Corporate Point, 2nd Fl.|     Voice: (310)348-4448              |
|Culver City, CA  90230      |       FAX: (310)348-7701              |
+----------------------------+---------------------------------------+
|The opinions expressed here are solely my own, mainly because nobody|
|else would want them....                                            |
\--------------------------------------------------------------------/

                                                
Newsgroups: comp.databases
From: nigelc@cognos.com (Nigel Campbell)
Subject: Re: Guide to SQL2
Keywords: SQL,SQL2,guides
Organization: Cognos Incorporated, Ottawa CANADA
Date: Mon, 14 Dec 1992 03:21:44 GMT

In article <kitchel.723996613@manta> kitchel@manta.dpsi.com (Sidney W. Kitchel) writes:
>	C.J. Date wrote _A Guide to the SQL Standard_ to help folks
>understand the ANSI standard for SQL. Does anyone know of a comparable
>book for the ANSI SQL2 standard?? Or is Date planning another edition
>of his book for SQL91??
>

Buy
Understanding the new SQL: A complete guide
Jim Melton and Alan R Simon
ISBN 1-55860-245-3
Published by Morgan Kaufmann
2929 Campus Drive, Suite 260
San Mateo, CA 94403



-- 
Nigel Campbell          Voice: (613) 738-1338 ext 3016    P.O. Box 9707
Cognos Incorporated       FAX: (613) 738-0002             3755 Riverside Dr.
Database and Connectivity MCI: nigel campbell || 307-4729 Ottawa, Ontario
UUnet: nigelc@cognos.COM                                  CANADA  K1G 3Z4
Newsgroups: comp.databases
Subject: Re: Is Foxpro 2.5 shipping ?
From: alewalle@anl433.uucp (ames lewallen)
Date: 17 Dec 92 17:02:07 EST
Distribution: comp
X-Newsreader: Tin 1.1 PL5

Monty Andro (monty@blackhole.lerc.nasa.gov) wrote:
: 
: Is Foxpro 2.5 shipping yet ?  Has anyone ordered it yet ?
: 
: Monty

Not yet.  I wouldn't look for a ship date until early 93
according to discussions I've seen on compuserve.  It is
in a large beta right now from what I've been able to find out.

jim
From: dougv@vnet.ibm.com (Doug Valkenaar)
Date: Tue, 15 Dec 92 14:28:57 PST
Newsgroups: comp.databases
Subject: Is there a front-end or interface program for postgres?
Reply-To: dougv@vnet.ibm.com
Organization: ROLM
Disclaimer: This posting represents the poster's views, not those of IBM
News-Software: UReply 3.0

I would like to know if there is some sort of interface program for the
postgres database?  XView/OL is preferred but anything would be
helpful.

----------------------------------------------------------------------
D. Douglas Valkenaar       ROLM PhoneMail         (dougv@vnet.ibm.com)
----------------------------------------------------------------------
From: steve.silverwood@filebank.cts.com (Steve Silverwood)
Newsgroups: comp.databases
Subject: CA and Nantucket
Date: 17 Dec 92 12:43:00 GMT
Reply-To: steve.silverwood@filebank.cts.com (Steve Silverwood)
Organization: The File Bank BBS - Fallbrook, CA  619-728-4318


 >From: an662@cleveland.Freenet.Edu (Michael Leach)
 >Newsgroups: comp.databases
 >Subject: CA and Nantucket
 >Message-ID: <1f142pINN30g@usenet.INS.CWRU.Edu>
 >Date: 26 Nov 92 00:00:25 GMT
 >
 >
 >For those of you who haven't heard, Computer Associates bought
 >Nantucket (and subsidiary Island Publishing) in June for about
 >$80M.  They say they are committed to continuing the Clipper
 >and Aspen projects as well as dbFast.  They also plan on
 >porting Aspen and maybe Clipper to a variety of paltforms.  The
 >only smaller platform they state they will NOT support is
 >the MAC.  They will (eventually) support UNIX, VMS, OS/2 and
 >maybe VM or MVS with connectivity tools.
 >
 >Mike Leach
 >an662@cleveland.freenet.edu
 >

Mike:

Actually, even the Mac issue isn't set in stone.  According to Marc
Sokol in a discusson on that subject on our CompuServe forums, he
mentioned that if the demand is there, we'll look real hard at going
with Mac support.  (Naturally if the demand isn't sufficient to
justify the development effort, it won't happen, but that's just plain
common business sense.)

Also, anyone who wants to read about CA's plans for the future with
regard to CA-Clipper, CA-dBFast, CA-Visual Objects for Clipper (known
formerly under the code name "Aspen"), drop me a note with your
USPS mailing address to 76703.3035@compuserve.com and I'll send a copy
of the Statement of Direction.

//Steve//


/----------------------------+---------------------------------------\
|Steve Silverwood            |  Internet: 76703.3035@compuserve.com  |
|Computer Associates         |CompuServe: 76703,3035                 |
|300 Corporate Point, 2nd Fl.|     Voice: (310)348-4448              |
|Culver City, CA  90230      |       FAX: (310)348-7701              |
+----------------------------+---------------------------------------+
|The opinions expressed here are solely my own, mainly because nobody|
|else would want them....                                            |
\--------------------------------------------------------------------/
From: jcberger@grasp1.univ-lyon1.fr (Jean-Claude Berger)
Newsgroups: comp.databases
Subject: Re: Paradox 4: Problem with PushButton and ShowDialog
Date: 14 Dec 92 23:28:58 GMT
Organization: INSA Informatique, Lyon, France
NNTP-Posting-Host: grasp1.univ-lyon1.fr

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

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

 ----------------------------------------------------------------------------
 Jean-Claude Berger, JCBerger Developpement Formation (Free Lance Consultant)
 (+33) 78.24.75.78     E-Mail : jcberger@grasp1.univ-lyon1.fr - BIX, jcberger
Newsgroups: comp.databases,comp.protocols.nfs,comp.unix.internals,comp.unix.xenix.sco
From: t90nikhi@mp.cs.niu.edu (Nikhil Kumar)
Subject: Usenet sites for nfs/ acer/extended acer file system standards
Organization: Northern Illinois University
Date: Mon, 21 Dec 1992 02:27:14 GMT


i) I am looking for a usenet/ftp source for the nfs standard.
ii) I am also looking for an ftpable source for the SCO extended
acer and Acer filesystem standards. 

As I am looking into file systems internals which are applicable in 
SCO and other Open System Unix environments, are there any sugestions 
for reference literature? 

Thanks,

Nikhil Kumar
From: fgreene@hayes.com
Newsgroups: comp.databases.oracle
Subject: Re: How to emulate Yes/No Cancel Dialog?
Date: 16 Dec 92 08:18:21 EDT
Organization: Hayes Microcomputer Products, Norcross, GA

In article <1gl34nINNlb3@rave.larc.nasa.gov>, p228@uni05.larc.nasa.gov (Bailey Bob) writes:
> In article <1992Dec10.205650.19707@netcom.com> sjs@netcom.com (Stephen Schow) writes:
>>Anyone have any solutions for emulating a Dialog Box that prompts for 
>>yes/No/Cancel?
> 
> Have you seen the white paper from Oracle titled:
> 
> 	"Developing Bit-mapped Applications with SQL*Forms and SQL*Menu"
> 
> This paper describes a method of simulating check boxes that can be selected
> with the mouse.  I have tried it and it seems to work satisfactorily.  Granted,
> the appearance is not exactly according to Mac standards, but, it does make
> for a user friendly point & click selection.

> Bob Bailey
> 
So where do we get a copy of this paper?  I have done similar type things
in the past, but could really use a standard source so the wheel doesn't get
reinvented each time.
Newsgroups: comp.databases.oracle
From: casivils@lescsse.jsc.nasa.gov (craig sivils)
Subject: Re: Forms 3.0 - How do YOU do this?
Organization: Lockheed Engineering and Sciences
Date: 18 Dec 92 21:02:40 GMT

Be careful with the nxtfld trick, if the user can go backwards, the trigger
will not fire.  

An alternate solution would be to use a pre-record and a post-field trigger
on the field that determines access which would set the update allowed
characteristic of the controlled field.

				Craig
Newsgroups: comp.databases.oracle
From: kcameron@erc.cat.syr.edu (Ken Cameron)
Subject: Re: Oracle's 'Working...' Message - Can it be simulated?
Organization: Electronic Resource Center, Syracuse
Date: Fri, 11 Dec 92 09:35:59 EST

In article <77875@hydra.gatech.EDU> iadt3mk@prism.gatech.EDU (Michael Kustermann) writes:
>Has anyone ever tried to simulate the Oracle message 'Working...' which
>is automatically displayed when committing a transaction (on a form)?
>(Deleted...)
>Thank you for suggestions.
>-- 
>Michael Kustermann        |  Der Vogel kaempft sich aus dem Ei.
>Georgia Institute of Tech.|  Das Ei ist die Welt.
>Atlanta, GA 30332         |  Wer geboren werden will muss eine Welt zerstoeren.
>iadt3mk@prism.gatech.edu  |  Der Vogel fliegt zu Gott.  Gott ist Abraxas.

In almost all the forms I build I create a block called special. It is not
a database table and it hold special fields. Like a one liner at the
bottom of each page. I use it for messages. The user will not have to
ack them and I can use it to test what my last message was. So to display
something I do:
:special.pg1message := 'test text';
It works ok but you may have to do things like go_block and go_page
to flush it to display.

-- 
-ken cameron. SkyDiver: Zoo-602, A-8596, D-11839. Skier.
Employer: Computer Task Group.  /cny UNIX Users Group Director.
Disclamer: "I said it, when I said it, so what! Now is different!"
Internet: kcameron@erc.cat.syr.edu
Newsgroups: comp.databases.oracle
From: GO.MSB@isumvs.iastate.edu 
Subject: Re: NumLock in OPEN-LOOK
Organization: Iowa State University, Ames IA
Distribution: usa
Date: Wed, 16 Dec 1992 15:29:32 GMT

In article <1992Dec15.175206.11656@eua.ericsson.se>,
euajhs@eua.ericsson.se (Jonas Hansson) writes:
>We are running on a SUN/UNIX platform OS 4.1.3 whith ORACLE RDBMS 6.0.36 and
>FORMS 3.0.16. In one of our departments we try to develop SQL*Forms applications
>in a bit-mapped environment. This have caused some problems for us. At the moment
>there is a problem with the keypad. When pressing NumLock key we get the message
>
>"You pressed an undefined function key".
>
>If you know something about this problem or how we solve it, please mail
>
>Jonas Hansson
>Ellemtel Telecommunication Systems Labaratories      Mail: euajhs@eua.ericsson.se
-------------------------------------------------------------->
In the DEC ULTRIX world, this was happening with all of the function keys.
Support told me this was a bug (#126426, for ULTRIX at least) and that it
was fixed in the 6.0.36 upgrade.  Since you have 6.0.36, you may need a
patch (#85126, ULTRIX?) to take you to 6.0.36.4.? .  I suspect (hope?) that
there is also an upgrade to the forms as that is where this problem is.
Any comment, Oracle???

Marvin Beck   Iowa State University
From: schueman@anaconda.cis.ohio-state.edu (gregory schueman)
Newsgroups: comp.databases.oracle
Subject: Re: SQL*Loader REALLY unique sequences
Date: 11 Dec 92 18:57:55 GMT
Article-I.D.: cis.1992Dec11.185755.15143
Organization: The Ohio State University Dept. of Computer and Info. Science


 
>> I am developing a system which needs to append ASCII data into a table
>> and generate a unique identifier for each new row. SQL*Loader has a
>> SEQUENCE function which will generate unique sequence number, but the
>> numbers will only be unique for a given SQL*Loader session, not for
>> the destination table.
>> 
>> Can anybody offer a way to get SQL*Loader to give me a sequence number
>> which is unique for the entire table?

What you want to do is use a SEQUENCE NUMBER generator.  Such a beast
is not session specific.
syntax:
   create sequence number my_table_seq_num
      start at 1 , increment by 1;
Then on the insert specification for SQL*LOADER you can
specify the appropriate info.  Something like

my_table_seq_num.nextval  <---- for the field value that you need.

-Greg
From: strobel@newton.mcs.gvsu.edu (Stephen Strobel)
Newsgroups: comp.databases.oracle
Subject: Oracle Archiver
Date: 16 Dec 92 18:36:51 GMT
Organization: Grand Valley State University, Allendale MI

I'm planning on using the Oracle Archiver and I'm interested in
hearing about how other DBAs are using the Oracle Archiver.

I am investigating three possibilities:

1.    Archiving to a disk device that contains Oracle data files.

2.    Archiving to a disk device that contains no Oracle data files.

3.    Archiving directly to a tape device.

4.    Archiving to another system on the network (via NFS)

I will summarize all responses for the net.

BTW, I'm running 6.0.36.4.1 on DEC RISC ULTRIX.

Thanks in advance.

-- 
|--------------------------------------|--------------------------------------|
|  Stephen Strobel                     | Phone: (h) (616) 235-1263            |
|  Grand Valley State University       |        (w) (616) 940-4241            | |                                      |  Mail: strobel@newton.mcs.gvsu.edu   |
|--------------------------------------|--------------------------------------|
From: lev@ipxed5.nswses.navy.mil (Lloyd E Vancil)
Newsgroups: comp.databases.oracle
Subject: Re: Question about OPS$LOGIN and Oracle Passwords
Date: 16 Dec 92 22:37:46 GMT
Organization: NSWSES, Port Hueneme, CA

In article <1992Dec14.200952.22697@netcom.com> sjs@netcom.com (Stephen Schow) writes:
>We routinely use the OPS$LOGIN feature of Oracle for all of our users.  This
>way they don't have to worry about anything once they are logged onto the
>UNIX machine.  They just type program / to run it with their UNIX login info.
>
>Question:  
>
>When we create a new user as follows:
>
>	grant connect to ops$user identified by bogus;
>
>and we actually use the word 'bogus' as the oracle password.
>
>Does this mean that user ops$user could login to Oracle with either
>the /, which would use his UNIX login info, or with 'bogus' as the
>password?

IN UNIX (sunos4.12) the conventions
sqlplus /
sqlplus OPS$user/bogus


will both work


>Could a user go into sql*plus with any convienient name and type
>
>	connect ops$user/bogus
>
>to get into that user's oracle accoun


Emphatically YES


This is a known security hole in the OPS$ user under oracle 6.. 
I am not aware of the fix if any in trusted oracle or in
oracle7.  

Not only is it a bad Idea to use the OPS$user/bogus scheme
but it is also bad to use the OPS$user/(Unixpassword) scheme
as that will actually make a unix password violation more
likely as now the user and the dba know the password of the
OPS$ oracle user.

Since the OPS$ password need only be used once, in the
grant command, the dba should be free to use any valid
password, as long as it follows 2 conventions
1. the dba should be THE ONLY PERSON TO KNOW IT.
2. each one is unique (within reason here folks)

I use the following method.

	a. locate webster's latest.
	b. drop on desk to open book
	c. close eyes and point to page
	d. pick closest word
	e. break word somwhere with _DD_
	   where DD is number of day.
	f. issue grant command to create new user
	g. close webster and forget word.

Funk and Wagnels will work as well.

If I need access to a users account as that user I can always
do another grant to change his pw or since I have su status
become him long enought to do the job.



--
|suned1!lev@elroy.JPL.Nasa.Gov|lev@suned1.nswses.navy.mil|sun!suntzu!suned1!lev|
|S.T.A.R.S. The revolution has begun!|  My Opinions are Mine mine mine hahahah!|
From: jessea@u013.me.vp.com (Jesse W. Asher)
Newsgroups: comp.databases.oracle
Subject: Barcoding and oracle.
Date: 15 Dec 92 19:07:26 GMT
Organization: Varco-Pruden Buildings

Does anyone have barcode printing integrated with Oracle?  We're a
manufacturing company that needs to use barcoding and we have no idea
about how to go about it.  We're running Oracle on unix and printing to
HP LaserJets (II and III).  Can anyone give me some pointers on where to
look for some code to do this sort of thing?

-- 
      Jesse W. Asher                                          (901)762-6000
                             Varco-Pruden Buildings
                 6000 Poplar Ave., Suite 400, Memphis, TN  38119
    Internet: jessea@vpbuild.vp.com                   UUCP: vpbuild!jessea
Newsgroups: comp.databases.oracle,comp.os.os2.apps