HDTenEightyP/NetNews huggingface dataset:
From: fgreene@hayes.com
Newsgroups: comp.databases.oracle
Subject: Re: SQL Forms Question
Date: 8 Jan 93 07:56:41 EDT
Organization: Hayes Microcomputer Products, Norcross, GA

In article <C0Hz12.GG@nocusuhs.nnmc.navy.mil>, maria@mgr.hjf.org (Maria Capule) writes:
> I am a novice Oracle person, so please forgive my ignorance. I was
> wondering if there is a way to split a character field in a SQL Form.
> I am currently using Oracle 6.0A for DOS and am creating forms using
> the SQL Forms Designer. I am used to using Informix and can easily
> write within the .per file.
> 
>        d1 = table.field[1,20];
>        d2 = table.field[21,40];
> 
> to accomplish this. Can somone also tell me if the SQL Forms designer
> is the only method by which to create forms? Thanks. 
> 
> 
> Please e-mail all replies. Thanks again...
> 
> 
> Maria Capule

As I understand your question, you want to display less than the entire
length of a character field in the form.  Two options:

     	a. In the field definition, define the field length and query 
	   length to be the same size as the size as the data base
	   definition and the DISPLAY length to whatever shorter field
	   length you desire.  Forms will retrieve the entire field but
	   only display the subset you specified.  Within the field, you
	   use the right arrow key to scroll to the hidden portion of
	   the field.

	b. Use a SUBSTR function to select only that portion of the data
	   field in which you are interested.  For example

		SELECT SUBSTR(data_base_field, 1, 10)
		INTO   :local_form_field
		FROM   the_table
		WHERE  etc

 ----------------------------------------------------------------------------
 |      Frank Greene                  |          //////  //////             |
 |      DELPHI SYSTEMS, Inc.          |           ////    ////              |
 |      Telephone [615] 458-6032      |          ////    ////  //////       |
 |      Compuserve 74200,427          |         ////    ////    ////        |
 |      324 Ootsima Way               |        ////    ////    ////         |
 |      Loudon, TN 37774              |       //////  //////  //////        |
 ----------------------------------------------------------------------------
 |         Of course, any opinions or suggestions are strictly my own       |
 ----------------------------------------------------------------------------

Xref: sparky comp.databases.oracle:2729 comp.os.ms-windows.apps:6775
From: jpe1@PL122f.eecs.lehigh.edu (John.)
Newsgroups: comp.databases.oracle,comp.os.ms-windows.apps
Subject: Re: Windows and Oracle access.
Date: 8 Jan 93 16:04:06 GMT
	<5858@npg-sd.SanDiegoCA.NCR.COM>
Organization: Lehigh University Rebel Computer Users

In article <5858@npg-sd.SanDiegoCA.NCR.COM> claborne@npg-sd.SanDiegoCA.NCR.COM (Chris Claborne) writes:

   In <dtb.726316321@otto> dtb@otto (David Bath) writes:

   >jessea@u013.me.vp.com (Jesse W. Asher) writes:

   >>I remember a recent thread on accessing Oracle from MS Windows, but I
   >>didn't pay any attention to it at the time.  Can someone bring me up to
   >>date on the thread?  Is there a way to access Oracle from MS Windows?
   >>Is there some sort of orasrv (SQL*NET) available for Windows??  Thanks.

   In order to do any client server with oracle you need SQL*NET running on 
   both machines.  In your case you would get SQL*NET for your PC and then
   purchase one of the following:
      Oracle's Oracle Card, Gupta, Power Builder , or one of the many others.

I just started using Oracle's Oracle Card, and it works well, though there
are limitations.
With the DDE manager I have been able to import directly into Quattro,
Word, and WordPerfect (for Windows).  Anyone have any thoughts on the other 
products listed above?

John.

----------------------------------------
John Early                             |
  software support administrator       |
JPE1@PL122.eecs.lehigh.edu             |  I was just a child then;
JPE1@ns1.cc.lehigh.edu                 |  now I'm only a man.  [pf]
jearly@lehi3b15.eecs.lehigh.edu        |
jpe1@admin1.cc.lehigh.edu              |
From: fgreene@hayes.com
Newsgroups: comp.databases.oracle
Subject: Re: Help needed: Simple Forms V3 Qns.
Date: 12 Jan 93 08:05:35 EDT
Organization: Hayes Microcomputer Products, Norcross, GA

In article <1993Jan11.230248.8262@brt.deakin.edu.au>, ajmex@brt.deakin.edu.au writes:
> I have been away from Oracle for a couple of years, and have a few questions
> relating to SQL*Forms V3 .
> 
> 1. How do you disable key triggers? In V2 you just defined them with
>    text of "#EXEMACRO NULL", but I cant find an equivalent in V3 .

	just use the value NULL; 
> 
> 2. I want a screen to set off a background process that runs a SQL*Plus
>    routine. How do I run this under the same User/Passwd?
> 
	From within a trigger, include the line

		HOST('sqlplus -a / @program_name') 

	to start immediate operation of a program.  To make it run as a
	batch routine you need to augment it with operating specific
	commands.  For example, in UNIX, you would add an '&' character
	to the end of the string.  In VAX, you need to route the commands
	through a .COM file, etc.

> 3. In PL/SQL, if a SQL statement returns no rows, this is interpreted as an
>    error, and the exception handler is invoked. Is there no way to continue
>    processing at this point? Not all cases of "No rows found" are errors, in
>    my book. Not fatal errors, in any case.

	Easiest way to do it is to first retrieve a count of all candidate
	records into a local variable.  If the count is greater than zero
	then execute the query.  A more efficient method is to utilize a
	CURSOR command combined with a loop.  If there are no records
	retrieved, there will just be zero passes through the loop.  There
	is a good example under the heading 'Cursor Management' in chapter
	2 of the PL/SQL User Guide and Reference.

 ----------------------------------------------------------------------------
 |      Frank Greene                  |          //////  //////             |
 |      DELPHI SYSTEMS, Inc.          |           ////    ////              |
 |      Telephone [615] 458-6032      |          ////    ////  //////       |
 |      Compuserve 74200,427          |         ////    ////    ////        |
 |      324 Ootsima Way               |        ////    ////    ////         |
 |      Loudon, TN 37774              |       //////  //////  //////        |
 ----------------------------------------------------------------------------
 |         Of course, any opinions or suggestions are strictly my own       |
 ----------------------------------------------------------------------------
Xref: sparky comp.databases.oracle:2704 comp.os.ms-windows.apps:6724
From: claborne@npg-sd.SanDiegoCA.NCR.COM (Chris Claborne)
Newsgroups: comp.databases.oracle,comp.os.ms-windows.apps
Subject: Re: Windows and Oracle access.
Date: 7 Jan 93 03:44:42 GMT
Organization: NCR Corp., Network Products - San Diego

In <dtb.726316321@otto> dtb@otto (David Bath) writes:

>jessea@u013.me.vp.com (Jesse W. Asher) writes:

>>I remember a recent thread on accessing Oracle from MS Windows, but I
>>didn't pay any attention to it at the time.  Can someone bring me up to
>>date on the thread?  Is there a way to access Oracle from MS Windows?
>>Is there some sort of orasrv (SQL*NET) available for Windows??  Thanks.

In order to do any client server with oracle you need SQL*NET running on 
both machines.  In your case you would get SQL*NET for your PC and then
purchase one of the following:
   Oracle's Oracle Card, Gupta, Power Builder , or one of the many others.


                                    ...  __o
                                   ..   -\<,
chris.claborne@sandiegoca.ncr.com  ...(_)/(_).                 CI$: 76340.2422
Newsgroups: comp.databases.oracle
From: Neil Greene <neil@kynug.org>
Subject: Oracle Medical Applications
Reply-To: Neil Greene <neil@kynug.org>
Organization: University Of Kentucky, Dept. of Math Sciences
Date: Mon, 11 Jan 1993 02:57:37 GMT

If anyone would like to forward me some example table definitions to  
maintain patient medical records under Oracle, I sure would appreciate it.

Thanks in advance.  Just looking for ideas.

--
Neil Greene 
benchMark Developments, Inc. [NeXT VAR]
Kentucky NeXT User Group, Inc.
neil@kynug.org
From: leilas@ems.cdc.com (Leila Schneberger)
Newsgroups: comp.databases.oracle
Subject: ORACLE7 backup schemes wanted
Date: 9 Jan 93 14:18:08 GMT
X-Newsreader: Tin 1.1 PL5

I would like to hear from sites running ORACLE7 as to what kinds of
backup schemes they are using. ALSO, any sites doing backups for
very large (2-5 GB) databases.

Please e-mail replies to me.
Thanks!

--

 Leila Schneberger                 leilas@ems.cdc.com
From: champs@hhcs.gov.au
Newsgroups: comp.databases.oracle
Subject: RE: MULTIPLE LIST OF VALUES
Date: 12 Jan 93 18:57:49 +1100
Organization: Aust. Dept. Health, Housing and Community Services

Hi there

In answer to you question about multiple list of values

Your best bet is to use a multi-record block that LOOKS like a list of values.
You can even have it come up when they press <FIND> (or whatever they press to
get a list of values, just use a KEY-LISTVAL trigger on the start field to 
direct them to the multi-record block.  You might want to include a flag field
in the multi-record block to mark which records they have chosen, then whenever
they enter the block you can ensure flagged records are highlighted.

To use these multiple values in a subsequent query, create a field in an
invisible utility block to store ALL of their picks simultaneously.  Then in a
PRE-QUERY trigger on the appropriate block, scan through your multi-record
block looking for flagged values and appending them to the field in the
utility block.  You'll have to put a , and some "" around each value as you
append them (you'll have to play around to find the right number of "" to put
around each value so that some make it through the next step).  Now, still in
the PRE-QUERY trigger, you assign the contents of your utility field to the
field you wish to test something like this

   :BLOCK_A.FIELD_I_WANT_TO_TEST 
        := '# IN (' || :UTILITY_BLOCK.SELECTION_LIST || ')';

Now you can see where you'll have to play with the "" to get the number right.
Rest assured, THIS WILL WORK.  I've done it myself.  I just can't remember
which form I did it in, so I can't look it up.  Perservere and you shall be 
rewarded (I sure felt good when I got it to work).

Hope this helps.
Bye for now
-----------------------------------------------------------------------------
    /\       Steven Champness (champs@hhcs.gov.au)
   /  \      Dept Health Housing and Community Services
  /    \     Brisbane Queensland
 /      \     via
/   /    \   Canberra Australia
\  / /   /
 \/ / / /    MACINTOSH SOFTWARE AXIOM : If you need a manual to operate it
  \/ / /                                it wasn't designed properly in the
   \/ /                                 first place !
    \/

Newsgroups: comp.databases
From: durai@ortta.umn.edu (Durai Venkatasubramanian)
Subject: Memo of the month <hail ibm>
Organization: U of Mn
Date: Tue, 5 Jan 1993 20:58:51 GMT

The following text is supposed to have been appeared in the "washington 
monthly", jan-feb 91 issue, page #24.  

This is an actual alert to IBM field engineers that went out to all IBM 
field offices.  The person who wrote this seems to have been very serious.  
Most of us think it is funny.

Abstract: Mouse balls available as FRU  (field replacement unit)

Mouse balls are now available as FRU.  Therefore, if a mouse fails to 
operate or should it perform erratically, it may need a ball replacement.  
Because of the delicate nature of this procedure, replacement of mouse balls 
should only be attempted by properly trained personnel.

Before proceeding, determine the type of mouse balls by examining the 
underside of the mouse.  Domestic balls will be larger and harder than 
foreign balls.  Ball removal procedures differ depending upon the 
manufacturer of the mouse.  Foreign balls can be replaced using the pop-off 
method.  Domestic balls are replaced using the twist-off method.  Mouse 
balls are not usually static sensitive.  However, excessive handling can 
result in sudden discharge.  Upon completion of ball replacement, the mouse 
may be used immediately.

It is recommended that each replacer have a pair of spare balls for 
maintaining optimum customer satisfaction, and that any customer missing his 
balls should suspect local personnel of removing these necessary items.

To reorder, specify one of the following:
P/N 33F8462 - domestic mouse balls
P/N 33F8461 - foreign mouse balls


Newsgroups: comp.databases
From: mroth@afit.af.mil (Mark A. Roth)
Subject: real-time database info needed
Originator: mroth@cougar
Organization: Air Force Institute of Technology
Date: Mon, 11 Jan 1993 21:19:32 GMT


Please send me any references to papers that discuss real-time issues
with respect to database management.  I'm interested in anything from
a description of the problems to potential solutions.

Thanks,

Mark Roth
AFIT/ENG
2950 P ST
Wright-Patterson AFB, OH 45433-7765

mroth@afit.af.mil


Newsgroups: comp.databases
From: jjfink@skcla.monsanto.com
Subject: Re: Paradox bug/feature in query form? (3.5)
Organization: Searle, Skokie, IL
Date: Fri, 8 Jan 1993 08:44:16 GMT

In article <1993Jan7.183802.12921@blaze.cs.jhu.edu>, mancini@circle.cs.jhu.edu (Todd A. Mancini) writes:
> 
> Here's something I noticed in PDOX35, but have not yet tested in PDOX40...
> 
>   When I use a variable name in a query form from PAL (by using the
> ~variablename) notation, if the variable contains any wildcards they are
> ignored.  Is this documented?
>... 
>  LNAME = "M.."
> 
>  query
> 
>    cust | last_name    | first_name |
>         | check ~LNAME | check      |
>         |              |            |
> 
>  endquery
> 
>  DO_IT!
> 
> does NOT find these customers.  I have been able to get around this by using
> the TYPEIN command, but this is not elegant.  Any hints?
> (mancini@cs.jhu.edu)

That's not a bug, that's a feature.  It's documented, though poorly.
The 'tilde variables' in the query forms can only be used for single-valued,
non-patterned text.  I'd tried to put "123 OR 456 OR 789" in such a variable,
and again, no dice. TYPEINs are the only way.

Now, what I'd really like is some capability to use string and math functions
in a query!!!  For instance, I should be able to calculate age as the 
integer of (current date - birth date)/365.25, but NOOOOOOO!

So far as I can tell, Paradox has not changed this for 4.0.  We can only hope
PDX/Win will improve the query form.

Joel

-- 
jjfink@skcla.monsanto.com
------------------------------------------------------------------------------
"I want peace on earth, and goodwill towards man."
"We don't do that kind of thing, we're the United States Government!"
  -- from _Sneakers_
Newsgroups: comp.databases
From: alsimmon@uncc.edu (Amber Leigh Simmons)
Subject: FoxPro: Help needed with scrollable windows
Reply-To: alsimmon@uncc.edu
Organization: University of NC at Charlotte
Date: Thu, 7 Jan 1993 21:57:15 GMT


I am currently working on a program in FoxPro for a large hospital
in my area.  I want to be able to implement my forms so that they 
can be larger than the screen.  Therefore I need to have window 
which act like the FoxPro system windows with scroll bars across
the top and bottom, to scroll around the form.  I know this can be
done because I have seen an application using this concept.

FoxPro technical support, however, says that this is not possible.
If anyone has any ideas or know of some library routines that may 
help please let me know.  Please use e-mail if possible.

Any help wuld be appreciated.
Thanks

Amber
Newsgroups: comp.databases
Subject: Arev 3.01
From: news@massey.ac.nz (USENET News System)
Date: Sun, 10 Jan 93 23:34:51 GMT
Organization: DSIR, Palmerston North, New Zealand
Summary: Couple of questions

Hello Scott (Whom I assume will answer this!)

I been reading the News about Push.session and Pop.session. I can't seem to
use them. Is something needed to declare them? I've written my own versions 
of them but don't know how to obtain the current video information (i.e. 
what is the current background and foreground colour?)

Also, if I have an application menu as the startup menu, and add a menu 
option to call the main development menu, what do I run? Using "M  Main" or 
typing (TCL) 'runmenu main' doesn't work cos it is not in the MENUS file. 
How can one call it?

I may be in a minority of one here, but is there any support to having a FAQ 
for Arev 3.xx?

Thanks for any answers...hope I'm not taking too much of your time. It's 
just soooo much quicker to get a good response through the News.

David Apimerika
Newsgroups: comp.databases
From: Richard_Mardon@mindlink.bc.ca (Richard Mardon)
Subject: Re: request for info on OODBs
Organization: MIND LINK! - British Columbia, Canada
Date: Sun, 10 Jan 1993 04:03:01 GMT

I am also interested in OODBs. We are currently restructuring our training
and documentation methodologies to match our OOD approaches in our software
development.  We seem to have a gap between the theory and the tools that
allow us to develop our databased approache to documentation.

Any comments/thoughts on this appreciated.


Newsgroups: comp.databases
From: wayne@netcom.com (wayne t. watson)
Subject: DB FAQ
Keywords: faq
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Distribution: usa
Date: Tue, 5 Jan 1993 03:04:02 GMT


I haven't seem any FAQs in this newsgroup, but would appreciate seeing
one.  I have on occasion had to use some db products and have an interest
in some sort of overview in what is available, etc.  Some of my appetite
for this subject has been quenched recently by a couple of books that I
include below for general interest and for those of us in the infant
stage of our inquries:

1.  Mattison, Rob, Understanding DB Mgmt Systems, Mc Graw-Hill, 1993,
    ISBN 0-07-040973-0, about $50.
    My need to by this wasn't great enough to overcome the price, but
    a definite plus was an appendix of describing the basics of some
    50 or so odd packages.  About a page or two was devoted to each.
    Informix, Ingress, etc. covered.
2.  Date, C. J., Database, A Primer, Addison-Wesley, 1983, about $20.
    Date has some loftier books, but this is a pretty decent little 
    one.  
3.  Litton, Gerry M., Introduction to DB Mgmt, PCB Publishers, 1987.
    Estimated prices is about $40-50.  I stumbled onto this one during
    a break from a recent ski trip in the Sierras in a library in
    Sonora (50 miles from Yosemite).  A pretty nice intro to many
    aspects of the subject.

Anyway, these have satisfied my curosity about what is happening in
the land of database products, so I am posting this note here for
the benefit of others.  

It would be nice to see a FAQ for this group.  I really liked the idea
of the appendix sited above in Mattison's book.  Something like it
might be useful here.  There seem to be a very large number of db
products, and it would be useful for some of us occasional users to
be able to get some info on the subject.  My interest came from just
wanting to know what Nomad was and anything else about it that might
be helpful. 
 
-- 
Wayne T. Watson   wayne@netcom.com (415) 969-4233
Mountain View, CA
Newsgroups: comp.databases
From: Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg)
Subject: SYBASE: Returning results over a network from a 'C' executab
Organization: MIND LINK! - British Columbia, Canada
Date: Sat, 9 Jan 1993 07:26:13 GMT

> lundell@gumby.mgi.com writes:
>
>  We are using Sybase as our database server running on an RS6000. The
> clients are
>  PCs running Microsoft Windows. We are able to call stored procedures from
> the
> clients and receive the result sets just fine.
> However, I would like to be able to call a 'C' program directly (via an
> RPC?)
> from the client and have it return the result set identical to the stored
> procedure. Is this feasible?
Sure, you can do this, given a TCP/IP interface library and a fair bit
of code. You'll learn all about the intricacies of registering RPC's,
TLI for sockets (AIX is SVR4) and a bunch of other things. Your energy
and enterprise are impressive.
>
> So my guess is that the 'C' program would use say use 'DBLib' to build a
> result set from Sybase.
Yup. And that leads to the question: could you express exactly why
you want to do this? So far, it sounds like you want to do considerable
work to accomplish no more than the existing interface ("identical",
you say) with increased load on the network -- since your RS6000
program will be talking TCP/IP internally to the dataserver, anyway.

The only thing I can figure (and correct me if I'm wrong) is:
- you want to add some control code in this gateway server, to
        limit user load, or something.
- you want to work through a single thread (dblogin), perhaps so
        that multiple clients can share tempdb tables (serially)
- you want to do something more complicated than what Transact is
        good for (no surprise), perhaps like symbolic processing
        of table/field names.
 - you figure you can do something more efficiently than a transact
        procedure.

 If one of the latter is your goal, I would strongly suggest that you
 knock the network side out of it, using the model gateway source
 provided with the Open Server stuff; then let the dataserver in
 effect handle your "exec myCustomerServer...myNiftyProcedure" calls.
 If you really want to send back choking amounts of data to the clients,
 read about the tabular data stream (TDS).
>
> Has anyone ever attempted something similar to this??
Yes, the latter, but no, not the former. And it was to (more or less)
answer the repeated question, "how can I pass a table name as a parameter
to a procedure?".

--
Mischa Sandberg ... Mischa_Sandberg@mindlink.bc.ca
                 or uunet!van-bc!rsoft!mindlink!Mischa_Sandberg
*-*-*-*-*-*-*-*-*-*-*
Engineers think equations are an approximation of reality.
Physicists think reality is an approximation of the equations.
Mathematicians never make the connection.
Newsgroups: comp.databases
From: pwyan@neumann.uwaterloo.ca (Weipeng Paul Yan)
Subject: SQL-92
Keywords: SQL-92 
Organization: University of Waterloo
Date: Thu, 7 Jan 1993 15:48:58 GMT

Could somebody recommend me a good guide book on SQL-92?

Thanks in advance!

Weipeng
Newsgroups: comp.databases
Subject: popup that maintains cursor position on redisplay in Revelation
From: D.M.Todd@massey.ac.nz (D.M. Todd)
Date: Mon, 11 Jan 93 03:54:08 GMT
Organization: Massey University, Palmerston North, New Zealand
Keywords: Revelation popup
X-Reader: NETNEWS/PC Version 2c

How can I set up a popup in Advanced Revelation (3.x) that will return
to the same row after it is executed.  Ordinarily a redisplayed popup
will place the cursor on row 1, but I'd like it to put the cursor on
the row that was previously selected.

Any help will be much appreciated.