HDTenEightyP/NetNews huggingface dataset:
From: rfitzgerald@cpva.saic.com
Newsgroups: comp.databases
Subject: Re: dBASE prompt menu question
Date: 23 Nov 92 20:42:21 PST
Distribution: na
Organization: Science Applications Int'l Corp./San Diego

I have had the same problem.  That would be a nice functionality to have.  But
I can see that dBASE would have problems trying to define a popup from a
complete database, and there could be memory problems when the database size is
large.  To work around the problem in my shop, we use the BROWSE command with
some ON KEY LABELs then put it in window to look like a popup.  And we then
disable the F10 key so people don't think it is a BROWSE.

I hope I helped.
Richard F.
From: exuptr@exu.ericsson.se (Patrick Taylor)
Newsgroups: comp.databases
Subject: *** MORE COMPLAINTS ABOUT GUPTA ***
Date: 23 Nov 92 23:44:06 GMT
Organization: Ericsson Network Systems, Inc.
X-Disclaimer: This article was posted by a user at Ericsson.
              Any opinions expressed are strictly those of the
              user and not necessarily those of Ericsson.


Hi there.  Just wanted to relate some more technical support nightmares for
those of you contemplating a Gupta purchase.

Please note these opinions are my own, and are based on my experience with 
Gupta Technologies, not on a wide survey or anything of the kind.

Disclaimer aside, I called these guys about a problem with the text search 
in their environment, and about a GP fault caused by SQLWIN.EXE when you 
attempt to use a non-existant file.  The search function will not locate ANY 
KEYWORD in the text of the file, we are told, unless it is in a comment.  So 
if you are looking for an If or Return statement, forget it, it won't work.  
Basically they told us to live with it.  Same with the GP fault, we should 
check to see if the file exists...  

Well I've written programs that have crashed when a file is not there, but a 
GP fault from the development environment?  I call that a bug.

Several weeks ago a Gupta person (obviously scanning the net, ARE YOU OUT 
THERE?) contacted me by email to address our "issues".  He said he'd have a 
Customer Service representative call me.  Never happened, nor have I heard 
from him again.  Probably just because I stopped posting.

Bottom line is we paid thousands of dollars for Hot Line support, and all we 
got was the "Chill Mill", as we like to call it.  We have opened and closed 
11 "Logs" and have received 2 maintenance releases and 9 "live with it" 
responses.  Only one of the 2  maintenance releases actually fixed OUR bug.

Another bug involves a function that is clearly supposed to tell you whether 
a window handle is NULL or not, but always returns FALSE.  This one is still 
open, but the support guy said that the response would probably be "This is 
the way the function is designed."  I said "You mean it is designed to give 
a wrong answer?"  He said he would "submit the report".

What say you now Gupta?
-----------------------
 ----------------------------------------------------------------------------
 PEROT IN '96!

  - Patrick Taylor, Ericsson Network Systems
    exuptr@exu.ericsson.se                    "Don't let the .se fool you"
    exuptr@ZGNews.Lonestar.Org  <SLOW!>
Newsgroups: comp.databases
From: ummalik@ccu.umanitoba.ca (Ijaz Rashid Malik)
Subject: A couple Paradox Application WorkShop Queries
Organization: University of Manitoba, Winnipeg, Canada
Date: Mon, 16 Nov 1992 23:36:50 GMT


First of all I thank a lot to all who helped me with my earlier question...
"designing input screens...".

I had a few questions about Paradox's application workshop and I would
very much appreciate any help I can get.

1. How can I attach Action Objects to the menu items if I design both
   seprately?
2. How can I display the results of a Query when I run it from within
   application workshop or "my" application as part of a user request?
   Is there any way to display the actual answer table? I have tried
   many ways but all it gives me is the number of records in answer--if
   this option is checked while designing query in app. work shop.
3. Is there any way to compile my app. or scripts so that they run faster?

Thank you very much in advance!!!

Malik
ummalik@ccu.umanitoba.ca
Newsgroups: comp.databases
From: kudrass@dvs1.informatik.th-darmstadt.de (Thomas Kudrass)
Subject: Looking for O2 Users
Date: Tue, 17 Nov 1992 13:38:50 GMT
Organization: TH Darmstadt

We are working with the object oriented database system O2 developed and
distributed by the French company Altair. We feel, it's necessary to 
exchange experiences with this system with other users, furthermore we want
to use the API of the O2 Engine. Maybe there are experiences anywhere.
Please contact me under:
kudrass@dvs1.informatik.th-darmstadt.de
--
Thomas Kudrass                Tel.: +49-6151-16-6904
TH Darmstadt, FB Informatik   Fax:  +49-6151-16-5554
FG Datenverwaltungssysteme    Email:kudrass@dvs1.informatik.th-darmstadt.de
Frankfurter Str. 69 A, W-6100 Darmstadt (Germany)
Newsgroups: comp.databases
From: tleylan@pegasus.com (Tom Leylan)
Subject: Re: Clipper S'87 and DOS 5.0
Organization: Pegasus,  Honolulu
Date: Fri, 20 Nov 92 06:05:43 GMT

cargibbs@atlas.cs.upei.ca (Rick Gibbs) writes:

>	However, when I up-graded to a 386 and DOS 5.0, those same 
>applications crash and I get an "OUT OF MEMORY" message. What gives?

Rick:  It might be something else but I'll guess that you have too much
memory (you mentioned the move to DOS 5.0)... read whatever you can about
LOADFIX and use it.

BTW, you ought to be using Clipper 5.01 anyway, S'87 is sick by comparison.

tom
Newsgroups: comp.databases,comp.databases.ingres
From: bholt@olympia.mcis.washington.edu (Brent Holterman)
Subject: Re: Ingres questions
Reply-To: user@machine.domain
Organization: University of Washington
Distribution: usa
Date: Fri, 20 Nov 1992 20:35:52 GMT

In article <25987@sybase.sybase.com>, wong@sybase.com (J. Wong) writes:
|> In article <1992Nov11.180040.7771@dcatlas.dot.gov> sethg@dcatlas.dot.gov writes:
|> >I don't know of any workaround other than vertically partitioning your tables.
|> >On the other hand, Ingres 6.5 to be released in the spring will support BLOBs
|> >and presumably remove the 2000-byte limit (based on Ingres's current page
|> >size of 2048 bytes) on general fields.
|> 
|> Wrong!  INGRES 6.5 will support BLOBs as columns, but will not remove the 2000
|> byte limit on tuple size.

I was recently informed by an Ingres Technical Rep that this limit _will_ go away in 
release 6.5.  The new limit will be 2 gigabytes per tuple (No, I'm not kidding).  

Of course, all this came with the caveat that '..this is all unofficial...'  Marketing
hype?  Who knows...  

BTW, vertically partitioning tables works just fine until you try a  select that joins 
these partitions back together--you'll still have to strip out enough columns to get the 
result tuple within the 2000 byte limit.

-------------------------------------------------------------------------
Brent V. Holterman                | 
University Of Washington          | Voice:  206.685.3740
Medical Centers Info Systems      | Fax:    206.543.4833
Mail Stop: XD-04                  | E-mail: holterman@u.washington.edu
Seattle, WA 98195                 | 
Xref: sparky comp.databases:7877 comp.databases.sybase:324
From: mparsons@fleming.csc.bcm.tmc.edu (Mark Parsons)
Newsgroups: comp.databases,comp.databases.sybase
Subject: Re: help needed on sybase stored procedure
Date: 16 Nov 1992 15:35:25 GMT
Organization: Baylor College of Medicine, Houston, Tx
Distribution: world
Reply-To: mparsons@fleming.csc.bcm.tmc.edu (Mark Parsons)
NNTP-Posting-Host: fleming.csc.bcm.tmc.edu
Originator: mparsons@fleming.csc.bcm.tmc.edu


In article <1992Nov14.000317.58320@ssf-corp.dhl.com>, julies@ssf-corp.dhl.com (Julie Stephens) writes:
|> I'm attempting to create a generic Sybase stored procedure which will
|> accept up to 254 input parameters.  Within the stored procedure
|> I would like to determine how many parameters were passed to the
|> stored procedure & process them.  To accomplish this, I'd like to
|> have a loop which creates input parm names on the fly & retrieve 
|> the values stored in those input parameters. Can this be done?
|> 
|> Here is an example of what I'm trying to do.  The problem here is
|> clear (see WHILE clause).  The program will evaluate the temporary
|> variable @argName--not the input parameter @arg1. 
|> 
|> 	CREATE PROC processArguments
|> 		@arg1	varchar(255),
|> 		@arg2	varchar(255),
|> 		@arg3	varchar(255),
|> 		...
|> 		@arg254 varchar(255)
|> 	AS
|> 	DECLARE @argName varchar(30)
|> 	DECLARE @argInt  int
|> 
|> 	ProcessArguments:
|> 	SELECT @argInt = 1
|> 	SELECT @argName = '@arg1'
|> 
|> 	WHILE @argName IS NOT NULL
|> 	  BEGIN
|> 	    (blah, blah, blah)
|> 	    SELECT @argInt = @argInt + 1
|> 	    SELECT @argName = '@arg' + (SELECT CONVERT(char(3), @argInt))
|> 	  END
|> 

From what I've seen(and played with) you cannot do indirect addressing
or dynamic creation of code within a stored procedure . . at least not
in Sybase(can you in other DB servers?).

Each time through the loop @argName will be set to a string that looks
like 'arg??'.  In addition to that, the system will run indefinitely
since @argName will never be set to NULL, i.e., this is an endless
loop . . . unless you put in a test that says "If @argInt > 254 select
@argNmae = NULL". 

If you use a different language, or move this to the front-end, 
say . . . APT . . . you could do something like this . . but not in
the server . . . 

Anyone reported this to Sybase as a feature enhancement request?

Mark

Xref: sparky comp.databases:7930 comp.databases.sybase:347
From: mparsons@fleming.csc.bcm.tmc.edu (Mark Parsons)
Newsgroups: comp.databases,comp.databases.sybase
Subject: Re: help needed on sybase stored procedure
Date: 18 Nov 1992 15:54:59 GMT
Organization: Baylor College of Medicine, Houston, Tx
Distribution: world
Reply-To: mparsons@fleming.csc.bcm.tmc.edu (Mark Parsons)
NNTP-Posting-Host: fleming.csc.bcm.tmc.edu
Originator: mparsons@fleming.csc.bcm.tmc.edu


In article <steven.722080875@rupee>, steven@dev.state.COM.AU (Steven Sweeting) writes:
|> julies@ssf-corp.dhl.com (Julie Stephens) writes:
|> 
|> >I'm attempting to create a generic Sybase stored procedure which will
|> >accept up to 254 input parameters.  Within the stored procedure
|> >I would like to determine how many parameters were passed to the
|> >stored procedure & process them.  To accomplish this, I'd like to
|> >have a loop which creates input parm names on the fly & retrieve 
|> >the values stored in those input parameters. Can this be done?
|> 
|> >Here is an example of what I'm trying to do.  The problem here is
|> >clear (see WHILE clause).  The program will evaluate the temporary
|> >variable @argName--not the input parameter @arg1. 
|> 
|> >	CREATE PROC processArguments
|> >		@arg1	varchar(255),
|> >		@arg2	varchar(255),
|> >		@arg3	varchar(255),
|> >		...
|> >		@arg254 varchar(255)
|> >	AS
|> >	DECLARE @argName varchar(30)
|> >	DECLARE @argInt  int
|> 
|> >	ProcessArguments:
|> >	SELECT @argInt = 1
|> >	SELECT @argName = '@arg1'
|> 
|> >	WHILE @argName IS NOT NULL
|> >	  BEGIN
|> >	    (blah, blah, blah)
|> >	    SELECT @argInt = @argInt + 1
|> >	    SELECT @argName = '@arg' + (SELECT CONVERT(char(3), @argInt))
|> >	  END


The suggestion on the recursive call got me thinking . . . . 
Are you going to do similar processing, i.e., is the "(blah,
blah, blah)" the same?, or can you determine which processing to
do based on the actual *value* of the arg's?  Will the processing
of the args be independent of each other?

If so . . and I know this isn't as slick as we'd all like . . but
hopefully a little easier to write and debug than the recursive
call(no offense!! ;-) . . . 

Redefine your first proc like such:

CREATE PROC processArguments
	@arg1	varchar(255) = NULL,	/* default to NULL if not supplied */
	...
	@arg244	varchar(255) = NULL
AS
	exec processArguments2 @arg1
	...
	exec processArguments2 @arg254
RETURN

Now define the second process:

CREATE PROC processArguments2
	@arg1	varchar(255)
AS
	if @arg1 is not NULL	/* or whatever series of tests you need? */
	begin
		blah, blah, blah
	end
RETURN

Of course, you could go straight to processArguments2 from your front
end . . but you'd have to do 254 calls whereas using the two level
method above would require only one front-end-to-server call.  The
calls between the processes within the server will take up much less
overhead than doing separate calls to the server(from the front-end)
for each possible variable.

Sybase isn't going to allow indirect variable processing . . . so this
is the . . .um . . 'cleanest' idea I can come up with . . . 

Other suggestions?

Mark
Newsgroups: comp.databases
From: Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg)
Subject: Re: Ingres questions followup
Organization: MIND LINK! - British Columbia, Canada
Date: Sun, 22 Nov 1992 06:16:24 GMT

> Joe Keane writes:
> In article <BxLBKH.2w0@usenet.ucs.indiana.edu>
> mdchaney@fractal.ucs.indiana.edu (M Darrin Chaney) writes:
> >Traditionally, files under VMS are limited to 65534 byte records.  That's
> >because for normal variable length record files, the record length is
> stored
> >in the two bytes before the record.
>
> That is so dumb.  What kind of operating system is it?  It looks like a
> C-64.
> I mean, sometimes you can get away with using less bytes if you're clever.
> But having variable-length fields break when you get to 64KB is
> unacceptable.
> Joe Keane, professional programmer

Did my mailer edit the smiley out of this one?

By the way, there are a fair number of apps (not to mention the PICK O/S)
that have plenty of good reasons to store whomping big things in single
records. E-Mail systems and object databases, to mention but two.
So, if this was sarcasm, it missed the ball twice. Try one more time at bat?

--
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: ummalik@ccu.umanitoba.ca (Ijaz Rashid Malik)
Subject: MANY-TO-MANY mess in Paradox!!!
Organization: University of Manitoba, Winnipeg, Canada
Date: Fri, 20 Nov 1992 00:44:56 GMT


Is it just me or does every one is unhappy withg Paradox's way of handling
many-to-many links. I always end up with extra tables and lots of redundant
information. In a typical scenerio (sp?), a product can be supllied by
many vendors and a vendor can suplly many products. When it comes to 
displaying either side of this info, paradox suggests extra tables and their
use in the "form" display/generation. It, however, doesnot suggest an
answer to following problem....

say, from an input screen I am entering info about new products or new
suppliers. If its products, it can have a variable number of vendors and
if it is a vendor, there could be a variable # of products for it. How can
I design an input screen/form that has linked tables on it and handeles
multiple entries for a given field. I mean I can use Products as master
form and use vendors as linked embeded form. Now when ever I enter a new
product, I am not sure how many vendors for this product there will be.
Could be 0,1, or 10000!!! How can I design an input screen and then table
which would handle this situation????

Thanks very much for help.

Malik
ummalik@ccu.umanitoba.ca
Newsgroups: comp.databases
Subject: Re: How About COMP.DATABASES.PARADOX ?
From: f67700241@violet.ccit.arizona.edu (Greg Franklin)
Date: 18 Nov 92 01:25:01 MST
Distribution: world,local
Organization: University of Arizona
Nntp-Posting-User: f67700241

In article <mr.722063992@ogre>, mr@ogre.cica.indiana.edu (Michael Regoli) writes:
>>How about a comp.databases.dos?  
> I'll vote yes; I'm a new Paradox person who is finding an absolute
> dearth of Paradox-related stuff on the Internet.  (Archie reports one
> solitary "paradox" subdirectory at iskut.ucs.ubc.ca, that contains
> only three little (obscure) utilities.)  I'd definitely like to see a
> group for Paradox.

Same here....as a Paradox user I find most of the Unix questions and
CFPs here are a bit irrelevant to my interests.

> However, in the Grand Scheme of Things, it should probably look
> something like "comp.databases.ibmpc" from which, if traffic allows:
> 
>   comp.databases.ibmpc.dbase    comp.databases.ibmpc.pdox
>   comp.databases.ibmpc.foxpro   comp.databases.ibmpc.pcfile

May I suggest a simpler alternative GSofT:

comp.os.msdos.databases        For discussion of MS-DOS databases.

or

comp.sys.ibm.pc.databases      For discussion of databases on IBM PCs.

Of course, this presupposes we have a net-reader with the time and
inclination to run a vote for the proposal.  I can't do it; but the
necessary info for startup is at the beginning of news.groups, last
I checked.  I have a feeling that such a vote would pass easily.
-- 
Greg "Mockingbird" Franklin      Interviewer: "Sir, how do you spell relief?"
f67700241@ccit.arizona.edu               Dan: "R-O-L-A-I-D-S-E."

"[George Bush is] the most ruthless white man in the history of the planet."
	-- Richard Ben Cramer, author of _What It Takes_
"The President scores much better than Bill Clinton."
	-- Dan, comparing Bush's record of marital infidelity to Clinton's
Newsgroups: comp.databases,comp.databases.oracle,comp.databases.ingres
From: nigelc@cognos.com (Nigel Campbell)
Subject: Re: DB Comparison - DISAPPOINTING RESULTS
Keywords: db
Organization: Cognos Incorporated, Ottawa CANADA
Date: Sun, 15 Nov 1992 00:35:32 GMT

In article <1992Nov12.000714.11609@cc.uow.edu.au> gnaimo@cc.uow.edu.au (Greg Naimo) writes:
>I recently posted a request for information on comparisons of the
>popular RDBMS products.
>So far I've only received numerous requests for the information from
>other interested parties - but NO comparative info.
>Surely SOMEONE out there has done this work and would be prepared to 
>share it with others ??

Well, if you contact the Patricia Seybold Group and *PURCHASE* the
UNIX RDBMS Features Comparison Matrix dated Sept 30,1992 (J R Davis)
you should get a quick comparison chart for

Informix Online 5.0
Ingres 6.4
InterBase 3.2 (soon to be 3.3)
Oracle 7
Progress 6
Sybase 4.9

It is about 33 pages long in tabular format. Most vendors keep such a
list for their own use (we do), given how hard/long it takes to keep it 
up to date, I doubt that too many will give it away. This is probably the
next best thing unless you wanted databases not in the list.

P S G
148 State St, 7th floor
Boston Mass 02109
Ph (617) 742-5200
   (800) 826-2424
Fax (617) 742-1028
MCI PSOCG
Internet psocg@mcimail.com



-- 
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
From: someday@hardy.u.washington.edu (Scott Johnson)
Newsgroups: comp.databases
Subject: Re: Transferring traded-up Arev application to new system
Date: 21 Nov 92 18:39:39 GMT
Article-I.D.: u.1992Nov21.183939.9218
Organization: University of Washington, Seattle

In article <By2Htq.E64@nic.umass.edu> dtodd@titan.ucc.umass.edu (David M. Todd) writes:
>I'm traded up a ARev 1.16 application to 3.0 and now I am going to
>install the application at a new site where they have just bought 3.0.
>
>I once saw a suggestion to move a complex application in the following
>way:
>
>2)  Replace the old arev.exe file with the arev.exe file from the new
>system to put the new serial number (and network counter) in effect.
>
>Does this work?  Can this be accomplished just by replacing this one
>file?
>
>|~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ David M. Todd ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
>|Department of Psychology, University of Massachusetts, Amherst, MA 01003 USA|
>|Phone: 413/545-0158 ___ <DTodd@Titan.ucc.UMass.EDU> _____  Fax: 413/545-0996|

This will work if you ensure three things:

(1) The source and target systems are at *exactly* the same revision
level, that is, don't mix a 3.0 system and 3.01 EXE, for instance.

(2) You make absolutely sure that your customer's AREV.EXE file gets
installed in the right place, and that it is a totally legal and
registered copy that they have bought.  Keep everything legit please!

(3) GOTO (2).

Scott Johnson
Revelation Technologies, Inc.
(disclaimer: points (2) and (3) above directly impact
the continued health of my employer and my job!)
From: Bruce.Feist@f615.n109.z1.fidonet.org (Bruce Feist)
Sender: Uucp@blkcat.UUCP
Newsgroups: comp.databases
Subject: How About COMP.DATABASES.PARADOX ?
Date: Sun, 22 Nov 1992 19:48:34 -0500

 BD> How about a comp.databases.dos?

 BD> I could care less about questions on Paradox, Foxbase, Dbase, Clarion,
 BD> etc, but clearly there needs to be a forum to addresse specific questions
 BD> on these and other DOS products.  At least with a comp.databases.dos, we
 BD> don't get cluttered with too many sub groups, comp.databases goes back to
 BD> addressing generalized DBMS questions and people don't have read
 BD> through things they don't care about, just to get to those items they do.

But that eliminates logical connections between those platforms that sport a
common DBMS.  For instance, XBASE exists on both Mac and MS-DOS platforms.  And
where does that leave MS-DOS Oracle questions? (I suppose that isn't a problem,
given the existence of an Oracle-specific newsgroup -- but the principle
remains).

Bruce
From: cy@borland.com (Cy Shuster)
Newsgroups: comp.databases
Subject: Re: How About COMP.DATABASES.PARADOX ?
Date: 18 Nov 92 19:48:17 GMT
Article-I.D.: borland.1992Nov18.194817.14081
Distribution: world,local
Organization: Borland International
Originator: cy@genghis.borland.com

Rather than going to the detailed level of

      comp.os.msdos.databases.paradox
      comp.os.msdos.databases.dbase

... I would suggest just going one step down from the current
hierarchy, namely

      comp.databases.micros

It seems to me that the association of the new subgroups to the
comp.databases hierarchy is stronger than to the various operating
systems, particularly given that dBASE and Fox are available on
quite a few platforms.

If Paradox people don't want to read traffic about dBASE, then
we should follow the existing

       comp.databases.sysbase
with
       comp.databases.dbase (or xbase)
       comp.databases.paradox

--Cy--
cy@borland.com
Newsgroups: comp.databases.ingres
From: mmr@asgserver.canberra.edu.au (Micheal Rainford-Watson)
Subject: Passing a WHERE clause to Report Writer
Keywords: Report Writer
Organization: University of Canberra
Date: Fri, 20 Nov 92 02:14:56 GMT

I'm trying to pass a where clause to report writer to establish a
sort of flexible labels program. The problem is when report tries to
use the where clause it gets confused. ie:
4GL:

za_conditions = 'employee_code='+''''+'600307'+''''+' and status='+''''+'e'+'''';
CALL REPORT( sourcefile = '/home/user/asg/mmr/projects/labels/labels.rw',
             flags      = '-h -s',
             param      = 'conditions ="' +:za_conditions 
				+'" address_type="C" confidential="Y"');


Report Writer:

.QUERY
	select	name,
		pr_location  = j.pr_cjob_name,
		address_line1,
		address_line2,
		address_line3,
		post_code
	from	ahvemplabels e, prtcostj j
	where	$conditions

The parameter conditions is passed as employee_code='600307' and status='e' but
the Report program thinks that 'e' is a column. This is the error

E_US0836 line 1, Column 'e' not found in any specified table.

Maybe I'm expecting too much?

Platform is Ingres SunOS Version 6.3/01 (su4.u42/01)

Any suggestions?

-- 
Micheal Rainford-Watson        _--_|\   E-Mail: mmr@asgserver.canberra.edu.au
Administrative Systems Group  /      \  Phone : +61 6 201 2397
University of Canberra        \_.--.*/  Mail  : PO Box 1 BELCONNEN ACT 2616
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^v^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^