HDTenEightyP/NetNews huggingface dataset:
From: michaelh@g2syd.genasys.com.au (Michael Haldey)
Subject: Re: How Good is Ingres 6.4/01
Organization: Genasys II, Sydney, Australia
Date: Fri, 22 Jan 1993 05:59:43 GMT

In article <1993Jan20.162518.14172@b30.b30.ingr.com> dreddy@b30.b30.ingr.com (Devender Reddy) writes:
>Hi Everyone,
>
>
>I am interested in finding out if there are any serious bugs in this release.
>Any info is appreciated.
>
>
>-Devender Reddy

One annoying thing is that, at least on HP-UX, Ingres uses memory which was 
being freed before.  It is not a nice behavour (probably, a bug), and 
is difficult to attach memory leak detecting libraries (replacement of
malloc and free) to the INGRES C/esql application. 

My 0.02
Michael
-- 
Michael Haldey  |  Genasys II Pty Ltd, Sydney, Australia
                |  Phone:    +61-2-954-2878 (-9930 FAX)
                |  Internet: michaelh@g2syd.genasys.com.au
Newsgroups: comp.databases.ingres
From: drcoles@somnet.sandia.gov (Dwight R Coles)
Subject: Re: Stock Management Application???
Organization: National Radio Astronomy Observatory
Date: Mon, 25 Jan 1993 19:14:43 GMT

Mark Poole writes:
> 
> Before I develop my own, I was wondering if any of you netters
> are aware of any Ingres-based applications for managing Stock
> Portfolios? 

Ok, making the wild assumption you are looking for commercial software,
here's a list of several from the last Ingres solutions catalog:

	InterAccount II
	InterSec Research Corp
	66 Gate House Rd 
	Fairfield, CT 06902
	Arthur McCain (203) 348-7101

	Investment Banking System
	Mocom Corp
	127 Queensbridge Square
	South Melbourne Victoria 3205
	Australia
	H.A. Kort(03) 614-7000

	Forte
	International Commodities Clearing House
	Level 9, Grosvenor Place
	225 George St
	Sydney NSW 2000
	Australia
	Antigoni James (02) 258-8000
-
Now, if you're talking individual portfolio management software for free, that
is a different colored horse.

Hope this helps.
Dwight Coles
- 
Newsgroups: comp.databases.ingres
From: nariani@tiamat.cc.nd.edu (Sunil Nariani)
Subject: Windows4gl question on stackfield
Keywords: Windows4gl, stackfield
Reply-To: nariani@tiamat.cc.nd.edu (Sunil Nariani)
Organization: University of Notre Dame, Notre Dame
Date: Thu, 21 Jan 1993 04:20:18 GMT

I have 2 stackfields containing button fields.
The stackfields are called row1, row2.
If a user clicks on a button in one of the rows, I 
want to know which row (not button) was clicked.

The code should go as follows

on ChildClick row1, on ChildClick row2 = 
begin
		What code tells if it was row1 or row2 ?
end;


Note: I don't want separate event blocks as in the following code.
on ChildClick row1 =
begin
	...
end;

on ChildClick row2 =
begin
	...
end;


-------------------------------------------------------------
Use email, save a tree.

Sunil Nariani
Network Analyst
G008	OUC             My opinions are exactly that, MY opinions.
Univ of Notre Dame.
(219) 239-8575
(219) 271-1514
--------------------------------------------------------------
Newsgroups: comp.databases.ingres
From: mcj@moose.cccs.umn.edu (Mark C. Jones)
Subject: Checking for SQL errors after commit
News-Software: VAX/VMS VNEWS 1.41    
Reply-To: mcj@moose.cccs.umn.edu
Organization: Colon Cancer Control Study, University of Minnesota, Minneapolis
Date: Tue, 26 Jan 1993 15:45:00 GMT


In our 4gl code we are currently suppressing ingres errors from database
selects / inserts / updates. We then check for the error in the subsequent
statement using inquire_ingres.

i.e.    select a from tablex;
	inquire_ingres (error_no = errorno);
        if error_no !=0 then
	    rollback;
	    message 'Select error on tablex' with style = popup;
	    rollback;
            return;
        endif; 

Current coding does not check for an sql error after a commit statement.
I assume that an error can occur though during the commit and I am 
wondering how likely this occurrence is , or would any problem with the
transaction log file have manifested itself before the commit was actually
reached.


 ------------------------------------------------------------------ 
 Mark C. Jones (mcj@moose.cccs.umn.edu) 
 CSC Partners
 5500 Wayzata Blvd, Suite 1100
 Minneapolis  MN 55416  USA
 +1 612 593 1122                   
 ------------------------------------------------------------------
From: guthrie@etin.mct.rochester.edu (Barry Guthrie)
Newsgroups: comp.databases.ingres
Subject: Mapping to use numeric keypad
Date: 25 Jan 93 22:49:30 GMT
Distribution: ny
Organization: University of Rochester, Rochester NY
Originator: guthrie@etin.mct.rochester.edu

Is there a way to remap ingres function keys to use the 
numeric key pad for data entry of numbers?
From: anadeem@ampere.bit.listserv.tech-l (Ahmed Nadeem)
Newsgroups: comp.databases.ingres
Subject: MRI And CT-SCAN Images For Dogs?
Date: 27 Jan 93 07:50:29 GMT
Article-I.D.: ampere.ANADEEM.93Jan27005029
Distribution: comp.databases.ingres
Organization: /home/ampere1/anadeem/.organization

Netters,
      I am currently working on a research project that involves construction 
of realistic, solid or geometric models for dogs.
      Does anyone know where I can get serial section images( MRI, CT-SCAN, 
etc ) for dogs?
                                                       Thanks,
                                                              Ahmed Nadeem
Newsgroups: comp.databases.ingres
From: jabbate@Ingres.COM (Joe M. Abbate)
Subject: Re: Choice list for tablefield in 4GL
Summary: Can use Option, List, or Radio fields
News-Software: VAX/VMS VNEWS 1.4-b1  
Keywords: Windows4GL
Organization: ASK Computer Systems, Ingres Product Division
Date: 28 Jan 93 22:36:38 GMT

In article <1993Jan28.160140.8789@bmw.mayo.edu>, buntrock@mayo.edu writes...

>In article 23125@pony.Ingres.COM, jabbate@Ingres.COM (Joe M. Abbate) writes:
>>In article <1993Jan27.224636.6022@macc.wisc.edu>, heim@vms.macc.wisc.edu
>>(JOH writes...
>>
>>>I have a column in a tablefield in Windows4GL that is a varchar.  My 
>>>user needs to be able to choose from a list of values for the field.  
>>>There are a couple of 100 possible choices.  What is the best way to 
>>>implement this?
>>> 
>>>Right now I'm trying to set up an option field but the choices are in 
>>>a table in the DB and I don't see anyway to set up the option field 
>>>with the values in the table.
>>
>>An option list is a descendant (or subclass) of EnumField, so one
>>of its attributes is ValueList, an object of type ChoiceList,
>>which is an array of ChoiceItems.  You can add ChoiceItems values
>>(EnumText and EnumValue), inside a SELECT loop, either directly (by
>>assignment) or by using the AddTextItem method of ChoiceList.
>>Remember to call ChoiceItems.Clear() first and UpdChoiceList()
>>after the loop (to update the display).  The Language Reference
>>Manual has an example in the System Classes chapter, under EnumField,
>>and you can also look at the Purchase_order application in appendix D
>>of the Application Editor User's Guide.
>>
> 
>The above procedure will work fine, however, when the option list is displayed
>it forms a single vertical list.  If you are working with more than say 20 items the
>remaining items will be displayed off the screen.  The user will have no way
>of accessing the item they want.  I am not sure if there is a way 
>around a single vertical list for the option field.  If any one knows please
>post?  I have been using the tablefield as a fix.

In a separate posting/e-mail exchange John Heim asked and I
replied ...

>>BTW, I guess I should be using a list field (not a option field).  I 
>>think what you said above still works though, right?
>
>What I said works for all EnumFields: Radio fields, Option fields or
>List fields.  You can convert from one to the other from the Edit menu
>in AppEd.  What you choose depends on visual, space and ease-of-use
>characteristics of your tablefield and frame.  The option field only
>occupies one "line", but when choosing the user will suddenly be
>presented with a long list of choices.  The list field may use more
>lines, but provides a scrollbar to view the choices.

Joe
----------------------------------------------------------------------
Joe M. Abbate            | First the tooth fairy, then the Easter Bunny,
Ingres - Latin America   | then Santa, finally _ _ _ .
jabbate@ingres.com       | Why do so many people not take that last step?
Newsgroups: comp.databases.ingres
From: cor@cs.sun.ac.za (Cor Winckler)
Subject: Re: Multiple Developers in ABF/4GL (fwd)
Organization: National Radio Astronomy Observatory
Date: Thu, 21 Jan 1993 00:51:18 GMT

Forwarded message:
From cor Wed Jan 20 19:50:25 1993
Subject: Re: Multiple Developers in ABF/4GL
To: horn@schaefer.math.wisc.edu (Jeffrey Horn)
Date: Wed, 20 Jan 93 19:50:25 GMT+0200
X-Mailer: ELM [version 2.3 PL11]

Hi

About multiple users editing the same ABF application:

> 3.) Does anyone have any experiences (positive or negative) that they could
>     offer to help me make this situation work smoothly?  Any ideas on what
>     worked or what you might have done differently?

Beware of working under different usernames. We had to go through a whole
change-of-ownership operation once because users were working under
separate usernames. The problem is that front-end objects can exist for
seperate users, say the users pete and jess can edit a form called
'entry'. After they have both editied it, there would be (at least) two
copies, one owned by pete and one owned by jess, both with the same name.
Now when Pete runs his , he sees his form called 'entry' and when jess
runs the same application she sees her version of the form. 

You can see that you get confusion quite easily. 

Use one of Two solutions (i know of):
Either work under one username, which is the easiest to get going.

Give all development users dbadmin priviledges on the database you do
development on. In this way they can all use the -u flag to enable them 
to use one generic username that will be the owner of all the front-end
objects. If you use this way the users will have to be set up in
Operating system groups (Unix or VMS) so that the application source
code directory can be set up in order for the group to access it without
the world having access.

Allthough the first way is the easiest one, I prefer the second, because
it allows for better security control on an Operating system level.

Good luck with the setup!

-- 
  Cor
 
 Cor Winckler                    | Computer Science Departement             
 Internet: cor@cs.sun.ac.za      | University of Stellenbosch, South Africa 


-- 
  Cor
 
 Cor Winckler                    | Computer Science Departement             
 Internet: cor@cs.sun.ac.za      | University of Stellenbosch, South Africa 
Newsgroups: comp.databases.ingres
From: walkerl@med.ge.com (Larry Walker)
Subject: Re: Sun Sparc 10/ sun5 keyboard mappings
Followup-To: comp.databases.ingres
Organization: GE Medical Systems
Date: Wed, 27 Jan 93 02:22:35 GMT

In article <1993Jan25.172221.1119@speedy.aero.org>, amiranda@ariel.aero.org
(Ann Miranda) wrote:
> 
> 	I recently acquired a Sun Sparc 10 model 31 with a 
> Sun 5 keyboard.  The problem is the key maps don't work with
> Ingres 6.4/01 (su4.u42/01) (both under Motif or OpenWindows 3.0).
> 
> 	Only one person so far (few weeks ago) had reported a
> similar problem to Ingres technical support; unfortunatly it wasn't
> much help for me.
> 
> 	Has anyone run into the same problem, and created the 
> Ingres key maps?  (I'm sure if I had lots of time, I could do it,
> but, I don't have lots of time)
> 
> 	I'd appreciate any help I could get!
> 		Thanks, Ann

Ditto! All our new shipments of Sparcs are getting bit by this!!!

Help!

Larry Walker
System Architect
GE Medical Systems
Pewaukee, WI 53072
Newsgroups: comp.databases.ingres
From: sfc@tpghq.com (Steve Caswell)
Subject: Re: Checking for SQL errors after commit
Organization: Palmer & Associates, Inc., Norcross, GA
Date: Thu, 28 Jan 1993 14:22:30 GMT

In article <26JAN199309454635@moose.cccs.umn.edu> mcj@moose.cccs.umn.edu writes:
>
>In our 4gl code we are currently suppressing ingres errors from database
>selects / inserts / updates. We then check for the error in the subsequent
>statement using inquire_ingres.
>
>i.e.    select a from tablex;
>	inquire_ingres (error_no = errorno);
>        if error_no !=0 then
>	    rollback;
>	    message 'Select error on tablex' with style = popup;
>	    rollback;
>            return;
>        endif; 
>
>Current coding does not check for an sql error after a commit statement.
>I assume that an error can occur though during the commit and I am 
>wondering how likely this occurrence is , or would any problem with the
>transaction log file have manifested itself before the commit was actually
>reached.

I have only seen commit fail once, and that was in a beta version of 6.4 when
I was testing the set nologging feature.  If you want your code to be 100%,
absolutely, positively bullet-proof, you should add an error check after the
commit.  There is probably not much you can do to recover from the error, but
you should at least tell the user (or a log file) that the commit failed and
data may not have been stored.  A commit error could also possible cause an
inconsistent database, depending on whether the error was in the log file.
The only safe method of recovery is checkpoint/journal.  You can also mark
your database as being consistent with the verifydb utility, using the 
-FORCE_CONSISTENT flag.  However, this only flips the consistency bit and does
not ensure that your data is consistent.  You would have to do that by hand.

>
>
> ------------------------------------------------------------------ 
> Mark C. Jones (mcj@moose.cccs.umn.edu) 
> CSC Partners
> 5500 Wayzata Blvd, Suite 1100
> Minneapolis  MN 55416  USA
> +1 612 593 1122                   
> ------------------------------------------------------------------ 
>


-- 

Steve Caswell           |   (404) 448-7727    |  "The opinions expressed are my
Principal Consultant    |   sfc@tpghq.com     |   own.  They may not be perfect,
The Palmer Group        |   uunet!tpghq!sfc   |   but they're all I've got."
From: G.D.Lucas@lut.ac.uk
Newsgroups: comp.databases.ingres
Subject: Re: FTP site for commercial Ingres utilities, etc.
Date: 21 Jan 93 15:54:34 GMT
Reply-To: G.D.Lucas@lut.ac.uk (Giles Lucas)
Organization: Loughborough University, UK.

In article <1993Jan17.062151.17352@schaefer.math.wisc.edu> horn@schaefer.math.wisc.edu (Jeffrey Horn) writes:
>First off, let me say I KNOW that commercial ingres is not available for ftp.
>What I am wondering is if there is a site that has "neat stuff" for use with
>commercial ingres available for ftp?  Does the IUG maintain such an archive?
>
>Jeffrey Horn

I'd be v. interested in any 'neat stuff' that anybody knows about on an ftp site for example.
Newsgroups: comp.databases.ingres
From: mikes@Ingres.COM (Mike Schilling)
Subject: Re: Windows4gl question on stackfield
Date: 21 Jan 93 18:46:51 GMT

From article <1993Jan21.042018.3170@news.nd.edu>, by nariani@tiamat.cc.nd.edu (Sunil Nariani):
> I have 2 stackfields containing button fields.
> The stackfields are called row1, row2.
> If a user clicks on a button in one of the rows, I 
> want to know which row (not button) was clicked.
> 
> The code should go as follows
> 
> on ChildClick row1, on ChildClick row2 = 
> begin
> 		What code tells if it was row1 or row2 ?
> end;
> 
> 
> Note: I don't want separate event blocks as in the following code.
> on ChildClick row1 =
> begin
> 	...
> end;
> 
> on ChildClick row2 =
> begin
> 	...
> end;
> 
> 
> -------------------------------------------------------------
> Use email, save a tree.
> 
> Sunil Nariani
> Network Analyst
> G008	OUC             My opinions are exactly that, MY opinions.
> Univ of Notre Dame.
> (219) 239-8575
> (219) 271-1514
> --------------------------------------------------------------
Look at the language reference manual chapter on events; it will tell you
which curframe attributes related to event processing are valid in a ChildClick
block, and what their meanings are.  One of them (I think OriginatorField)
will tell you what you want to know.
----------------------------------------------------------------------------
mikes@ingres.com = Mike Schilling, INGRES, An ASK Group Company, Alameda, CA
Just machines that make big decisions,
Programmed by fellows with compassion and vision.	-- Donald Fagen, "IGY"
Newsgroups: comp.databases.ingres
From: Marco Olivieri <OLIVIERI@ICHCMNS.CMNS.MNEGRI.IT>
Subject: ABF application on IIDBDB
Organization: National Radio Astronomy Observatory
Date: Wed, 27 Jan 1993 08:41:00 GMT

Hi,

Is it possible to create an application with ABF or ESQLC on the IIDBDB?

Thanks in advance

   +-----------------------------------------------------------------------+
   | Marco Olivieri                                                        |
   |                                                                       |
   | Unit for Computer-Aided Biomedical Research                           |
   | Centre for Biomedical & Pharmacological Research - MARIO NEGRI SUD    |
   | Via Nazionale - S.Maria Imbaro (CH)   Italy                           |
   |                                              Tel.: +39 (872) 570.1    |
   | E-mail: OLIVIERI@ICHCMNS.CMNS.MNEGRI.IT                      570.324  |
   |                                              Fax : +39 (872) 578.240  |
   +-----------------------------------------------------------------------+
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Newsgroups: comp.databases.ingres
Subject: Re: Ingres and Solaris?
Date: 25 Jan 93 22:10:59 GMT

Cristyn Emmett (cristyn.emmett@newcastle.ac.uk) wrote:

We have Ingres 6.3/01 (soon to be upgraded to 6.4/01) on a Sun 4/470
running  SunOs 4.1.1. Our site is planning to migrate (is that the
correct term? :-) from SunOs to Solaris 2.1. The question is - does
Ingres run with Solaris? If not, when is it likely to do so?

In article <m0nGCwL-000QDqC@cs.sun.ac.za>, cor@cs.sun.ac.za (Cor Winckler)
writes:

>> My understanding is that SunOS and Solaris are equivalent. Solaris is a
>> SunOs implementation to run on (amongst other things) the Intel 80386 and
>> 80486 processors. The whole idea being that you can run ANY Sun software
>> on your 486 PC, including INGRES for SunOS. ......

In article <1979@niktow.canisius.edu>, pavlov@fstrf.org (Greg Pavlov) writes:

> Solaris is not SunOS.  It is different enough that applications running under
> SunOS must be recompiled to run under Solaris.  Solaris is a major sea-change
> for Sun, its software vendors, and its users.

Actually, Solaris _is_ SunOS (in part).  I've had a terrible time trying
to get the definitive answer to what this Solaris thing is.  As I
understand it, Solaris is the combination of (1) the SunOS UNIX
operating system; and (2) OpenWindows, which is the windowing system
that goes with it.  So the terms "Solaris" and "SunOS" are sort of
interchangeable, since the important component of Solaris, so far as
running INGRES goes, is SunOS.

INGRES _does_ work with Solaris.  I currently have INGRES version 6.4/03
running on a Sun SPARCstation 10 under Solaris 1.1.  The CDROM for the
OS is labelled Solaris 1.1, and it says that this is SunOS 4.1.3
together with OpenWindowns version 3.

However, I think that when people colloquially say "Solaris" with no
version, they really mean "Solaris 2.0" or SunOS version 5.something.
This is a major departure from SunOS 4.1.x.  According to my imperfect
understanding, 5.x is based on the A T & T flavor of UNIX, System V;
whereas 4.1.x is based on the BSD flavor.

I think I've heard that there _are_ folks out there who are running
INGRES under Solaris 2.x, but I won't swear to it.  Get the definitive
answer from your salesperson or INGRES/Advisor.

--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
Graduate School of Business		yellnet:  (312) 702-0328
University of Chicago			faxnet:   (312) 702-0233
Disclaimer: My opinions are my own and not those of my employer.
Je suis un virus.  Prends ton pied et copie moi a ta .signature.
Newsgroups: comp.databases.ingres
From: buntrock@mayo.edu (Jim Buntrock)
Subject: Re: Choice list for tablefield in 4GL
Reply-To: buntrock@mayo.edu
Organization: Mayo Foundation
Date: Thu, 28 Jan 93 16:01:40 GMT


---
In article 23125@pony.Ingres.COM, jabbate@Ingres.COM (Joe M. Abbate) writes:
>In article <1993Jan27.224636.6022@macc.wisc.edu>, heim@vms.macc.wisc.edu
>(JOH writes...
>
>>I have a column in a tablefield in Windows4GL that is a varchar.  My 
>>user needs to be able to choose from a list of values for the field.  
>>There are a couple of 100 possible choices.  What is the best way to 
>>implement this?
>> 
>>Right now I'm trying to set up an option field but the choices are in 
>>a table in the DB and I don't see anyway to set up the option field 
>>with the values in the table.
>
>An option list is a descendant (or subclass) of EnumField, so one
>of its attributes is ValueList, an object of type ChoiceList,
>which is an array of ChoiceItems.  You can add ChoiceItems values
>(EnumText and EnumValue), inside a SELECT loop, either directly (by
>assignment) or by using the AddTextItem method of ChoiceList.
>Remember to call ChoiceItems.Clear() first and UpdChoiceList()
>after the loop (to update the display).  The Language Reference
>Manual has an example in the System Classes chapter, under EnumField,
>and you can also look at the Purchase_order application in appendix D
>of the Application Editor User's Guide.
>

The above procedure will work fine, however, when the option list is displayed
it forms a single vertical list.  If you are working with more than say 20 items the
remaining items will be displayed off the screen.  The user will have no way
of accessing the item they want.  I am not sure if there is a way 
around a single vertical list for the option field.  If any one knows please
post?  I have been using the tablefield as a fix.


///////////////////////////////
James Buntrock
Analyst/Programmer
Medical Information Resources
Mayo Clinic
200 First Street SW
Rochester, MN 55905
email - buntrock@mayo.edu
///////////////////////////////


Newsgroups: comp.databases.ingres
From: mwp@ms9.mis.semi.harris.com (Mark W. Poole)
Subject: Rows to Table Fields
Date: Thu, 21 Jan 1993 19:28:16 GMT
X-Newsreader: TIN [version 1.1 PL6]
Reply-To: mwp@ms9.mis.semi.harris.com
Organization: Harris Semiconductor


I'm working on an ABF/4GL application where a user needs to be
able to update values in a table via a form, but only display the 
values to be updated.  A list of the available columns gets 
displayed, and the user enters a "Y" by the parameters that need
modification. 

Once this is done, I want to display a table field with three
columns "Parameter", "Current Value", and "New Value", loading the
chosen parameters into the "Parameter" field, with the corresponding
value in the "Current Value" field.  The first row from the table
would get loaded, edited, and saved, then the next row, and so on.
I made the "Current" and "New" fields varchar, because the data 
may be float, int, or varchar.  I'll convert the type as it
gets loaded in.

The problem is that I can't figure out how to load the row values
(only for the parameters chosen) into the appropriate row of the
table field.

So far what I've done is perform a query against the target table,
creating a temporary table with only the chosen columns and associated
data.  I then use iicolumns to determine what column names to load into
the "Parameter" field in the table field, along with the column_datatype
into a hidden field.  The hidden field will tell me how to convert the
data back into its original form prior to updating the base table.

So....how can I do this "transposition" one row at a time, not knowing
ahead of time what parameters will be chosen??

thanks in advance

Mark.
Newsgroups: comp.databases.ingres
From: greg@ms.cs.wm.edu (Gregory S. Miller)
Subject: ABF/4GL
Organization: College of William & Mary, founded 1693
Date: Thu, 28 Jan 1993 19:44:13 GMT

Is there any way to load a column of a table field in a called frame with the
values contained within a table field in the calling frame?
Newsgroups: comp.databases.ingres