HDTenEightyP/NetNews huggingface dataset:
From: umnoor@ccu.umanitoba.ca (Nasir Ahmed Noor)
Subject: Currency fields and Rounding...Paradox 4.0
Organization: University of Manitoba, Winnipeg, Canada
Date: Thu, 31 Dec 1992 22:04:50 GMT



HAPPY NEW YEAR!!!

I am having a problem with Paradox and PAL (v 4.0). I have to perform
some calculation on some CURRENCY fields but Paradox is behaving in weird
way. I give some examples below. Would appreciate any help on it.

There is an amount whose 5% comes to be $146.505. I use Round(146.505 ,2) on
it and get $146.50. But I want it to round UP to $146.51 as all the people
sending in the payments round UP and my app. and there payment forms are always
off by 1 cent. How to fix it.

Also Paradox shows currency figures to two decimals only but it maintains
actual number in memory. That causes problems for me. For example take the
above number, i.e. $146.505. Paradox will show it as $146.51 in tables and
you can even use Alt-F10 (PAL menu) ~V~alue function and it will tell you 
that it is $146.51...*BUT* if you actually use the value of this field in
calculations in PAL, this value used in calcs would be 146.505!!! This is
again causing problems for me as my books and customers books dont match. We
are always off by some cents. How to fix it?

I would appreciate your help.

regards
--nasir

-- 
Xref: sparky comp.databases:8646 alt.sources.d:1596 sci.materials:1031
From: jde@Unify.com (Jeff Evarts)
Newsgroups: comp.databases
Subject: Re: 500'000 records - who does best?
Date: 30 Dec 92 03:08:53 GMT
Organization: Unify Corporation (Sacramento)

In article <18971@mindlink.bc.ca>, Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg) writes:
> > Michael Perry writes:
> > >500,000 records, averaging 30K *each*. Forget Sybase and Oracle on Suns;
> > >go for a Teradata.
> > Hmmm... given the price/performance of a Teradata I can only say:  HUH?
> >
> > Makes _no_ sense [to me, anyways] to spend millions of dollars for Teradata
> > stuff when a smaller SMP box would be a LOT more practical.
> :-) Yes, it WOULD be a lot more practical, if it did the job. IF.
> >
> > >and what you are suggesting is probably outside the envelope already.
> >
> > Hmmm... outside the envelope.  Kinda hard to imagine a 30-40 user system
> > being outside the envelope, at least without a LOT more data to gnaw on.
> 
> It isn't the number of users, it's the basic size of the tables.
> One of our clients has pushed a table to 900k rows, 250Mb on an RS/6000
> with 50Mb memory dedicated to the Sybase server. Working with it
> feels like retiling the bathroom while an elephant uses the john.
> 
> On a practical level: can you segment your app to use several servers
> (I mean multiple boxes, not processes)?
> 
> --
> Mischa Sandberg ... Mischa_Sandberg@mindlink.bc.ca


I believe that this thread started out as a "can anyone do this REASONABLY"

UNIFY 2000 can handle this (500K rows @ 30K per row). If you have the disk space,
we have the database. :-)

Mischa is right... its not the users, it's the size of the database. The
UNIFY 2000 database package can have individual table segments in the 16+Mb
category, allowing over 500 rows per segment, so the table would only require
10000 segments.

You would still have plenty of room for indices and the rest.

Performance is impossible to judge without getting your hands a little dirty.
It depends on hardware, access patterns, indexing strategies, and a whole lot
more, but in general UNIFY 2000 is very hard to beat in the performance area.

You might check us out: 1-800-24UNIFY

-Jeff Evarts
--jde@unify.com

Disclaimer:
	I work for UNIFY corporation, in technical support. These are my words,
	not those of UNIFY.
Newsgroups: comp.databases
From: durai@ortta.umn.edu (Durai Venkatasubramanian)
Subject: Re: two foxpro questions
Organization: U of Mn
Date: Wed, 30 Dec 1992 19:39:44 GMT

In article <9212301852.AA11765@chimi.engr.ucdavis.edu> mahadeva@chimi.engr.ucdavis.edu (Vimalan Mahadevan) writes:
>From: mahadeva@chimi.engr.ucdavis.edu (Vimalan Mahadevan)
>Subject: two foxpro questions
>Date: 30 Dec 1992 12:59:07 -0600
>I am writing a data entry program program uising FoxPro and plan on writing
>aWindows based retrieval program in C.  I have been told that when doing
>this I must make sure that all my fields are of type character; using the date
>or numeric field types will just add to job when writing the C retrieval 
>program. 
>
>But I want to be able to filter the data entries being entered using numeric
>fields and the >,< operations.  This leads me to my questions.
>
>1)  If I have a character field five chars long and the user enters 235.  I want
>the program to automatically make that 00235 so I can sort.  But I don't want
>to display the leading zeroes unless I have to.
>
 Use a function that displays (or adjusts the value in the database) 
with leading zeros.  The function can be part of the valid clause 
for the object (field).  Eg: @ 2,3 get charfield valid addzeros(charfield)  

function addzeros
parameters fldval
 replace charfield with "00"+fldval   && if you are not using memvars
 m.charfield = "00"+fldval  && if you are using memvar

If you are using the screen generator, just insert the function code in the 
valid snippet.

>2)  Supposing you  have a field which contains the middle initial of a person.
>I don't want the user to have to enter the period after the initial.  How
>can the program be instructed to automatically enter a period after the user
>enters the letter?
>
Either you can use formatted input (@R) to show the "." on screen, or you 
can use a validation function, as mentioned above.  Formatted input, 
however, will not add the "." to data.

Hope it helps.
From: map@sequent.com (Michael Perry)
Newsgroups: comp.databases
Subject: Re: 500'000 records - who does best?
Date: 28 Dec 92 19:57:45 GMT
Article-I.D.: sequent.1992Dec28.195745.4985
Organization: Sequent Computer Systems, Inc.

In article <18774@mindlink.bc.ca> Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg) writes:
>500,000 records, averaging 30K *each*. Forget Sybase and Oracle on Suns;
>go for a Teradata.

Hmmm... given the price/performance of a Teradata I can only say:  HUH?

Makes _no_ sense [to me, anyways] to spend millions of dollars for Teradata 
stuff when a smaller SMP box would be a LOT more practical.

>risks. Working with multiple databases (we tie in to Teradata, DB2 and PC
>databases), I offer the humble advice that you never want to run
>a system within an order of magnitude of its performance limits,
>and what you are suggesting is probably outside the envelope already.

Hmmm... outside the envelope.  Kinda hard to imagine a 30-40 user system
being outside the envelope, at least without a LOT more data to gnaw on.

Mike
-- 
    "Life's a bench, then you die!"
Newsgroups: comp.databases
From: jvs@lester.appstate.edu (John V. Scalco)
Newsgroups: comp.databases
Subject: Progress DBMS?? Info..
Date: 21 Dec 1992 03:16:09 -0500
Organization: Appalachian State University
NNTP-Posting-Host: lester.appstate.edu
X-Newsreader: TIN [version 1.1 PL7]


	greetings,

	Does anyone know what Progress DBMS is...what platform it
	runs under, what it is like  etc.

	appreciate any info you could provide.

	please mail directly to me.......ahhhh you can post it if you
	want to  ifyou want, I read this newsgroup all the time..

	sincerely --- jvs
	
Newsgroups: comp.databases
From: ynwang@cuse1.se.cuhk.hk (Wang Ying Ngai (GA))
Subject: Help on CLIPPER DBEDIT()
Keywords: CLIPPER
Organization: Faculty of Engineering, The Chinese U. of Hong Kong
Date: Sat, 2 Jan 1993 07:37:09 GMT

Dear Clipper Programming experts,

I am an new user to the CLIPPER 5.01 and recently I try to write my own
version of DBEDIT() with TBrowse. However, a stone stop my road for that

-- How can I implement the PICTURE option into the TBrowse?
   (I try different ways with concept:
      field:="QUANTITY"
      column:=TBColumnNew(" ",{ || transform(fieldblock(field,"999,999")} )
    but this concept cannot work)

I would appreciate a lot if you can give any advice on this.

Also, do you know whether there is any ftp site that has CLIPPER sources in
internet?

Regards

Andrew Wang

Newsgroups: comp.databases
From: nh@cbnewsg.cb.att.com (nicholas.hounsome)
Subject: Informix Performance Tips Query
Organization: AT&T
Date: Wed, 23 Dec 1992 08:44:42 GMT

Has anybody got any tips on how to get the best performance out
of informix (online) ESQL?

The database is about 10M with the largest table being about 
20K rows.

Increasing the cache size seems like a good idea. I have tried a lot
of other stuff that they recommend and it doesn't seem to make much
difference (eg. extent sizes).

How nuch difference does preparing statements make compared to
statements fully parsed by esql?

Nick Hounsome
Newsgroups: comp.databases
Subject: Re: FoxPro problem with outer join
From: david@datamark.co.nz (David Rowland)
Date: Mon, 21 Dec 1992 20:52:08 GMT
Organization: Datamark International Ltd.

In article <1992Dec21.012636.28374@gopher.dosli.govt.nz> srlncnc@gopher.dosli.govt.nz (Chris Crook) writes:
>
>Can anyone offer any advice on how to solve the following problem in FoxPro
>(other than by using Paradox!).
>
>I have a one table (table1) with the following fields
>
>    unique_key
>    field1
>    field2
>
>and a second table (table2) with the fields
>
>    unique_key
>    field2
>
>The key is common to the two tables, but table2 has only a subset of the
>key values that are present in table1.  I would like to do is replace the
>field2 values in table1 for which there is a corresponding key in table2,
>leaving the rest of table1 untouched.
>

SELECT 0
USE table2 ORDER unique_key

SELECT 0
USE table1 ORDER unique_key
SET RELATION TO unique_key INTO table2
GO TOP

SCAN FOR table1.unique_key = table2.unique_key
     REPLACE table1.field1 WITH table2.field1
ENDSCAN

Dave
--
+---------------------+--------------------------------------------------+
| David Rowland       | The British are using New Zealanders.  They must |
| Datamark Intl Ltd   | really mean business !                           |
| Wellington          |      -  General Rommel During Northern African   |
| NEW ZEALAND         |         Campaign WWII.                           |
+---------------------+--------------------------------------------------+
From: jcberger@grasp1.univ-lyon1.fr (Jean-Claude Berger)
Newsgroups: comp.databases
Subject: Re: refreshing Paradox workspace
Date: 23 Dec 1992 00:22:04 +0100
Organization: INSA Informatique, Lyon, France
NNTP-Posting-Host: grasp1.univ-lyon1.fr
Keywords: paradox wait workspace refresh

REFRESH is used in a lan configuration.

Just put a : ECHO NORMAL ECHO OFF after your DO_IT!. There will
copy the workspace image to the canvas.


 ----------------------------------------------------------------------------
 Jean-Claude Berger, JCBerger Developpement Formation (Free Lance Consultant)
 (+33) 78.24.75.78     E-Mail : jcberger@grasp1.univ-lyon1.fr - BIX, jcberger
From: mccrosky@mwvm.mitre.org
Newsgroups: comp.databases
Subject: Re: Simulation of a Database System
Date: 22 Dec 92 14:34:54 GMT
Organization: The MITRE Corporation, McLean VA 22102


 
I am considering developing a simulation of a database system that will be
accessible to users across the United States.  As a first step, I did a
literature search to see if anyone else has developed such a simulation.
To my surprise, I found no relevant literature.  If you have any useful
references or insights as to why no one else has used simulation as a
tool to analyse the cost and design issues of fielding a large database
system, please contact me.
 
Bill McCrosky
mccrosky@mitre.org
(703) 883-5827
Newsgroups: comp.databases
From: durai@ortta.umn.edu (Durai Venkatasubramanian)
Subject: Pls help: algorithm wanted (xbase, pref foxpro)
Organization: U of Mn
Date: Wed, 30 Dec 1992 19:11:42 GMT

I need an algorithm to accomplish a date comparison task.  Any help will be 
appreciated and gratefully remembered for life.

I have an application that keeps track of subcontracts issued to outsiders.  
For every subcontract, we have to receive various rate agreements.  The 
subcontracts we issue usually span across multi years, but the rate 
agreement we receive is always for one year, and renewed every year for the 
duration of the contract.  The rate agreements can be provisional or 
final.  We should at least have a provisional agreement on file, in order 
to issue subcontract.  The rate agreement can be according the vendor's 
fiscal year.

When the user enters the subcontract start and end dates, the system has to 
check the available rate agreements for the period, and summarize how the 
various rate agreements cover the subcontract.

For example, I have a subcontract for the period 01/01/92 - 12/31/94 (3 
years).  I have the following rate agreements:

Final  07/01/91 - 06/30/92
Final  07/01/92 - 06/30/93
Provl  07/01/93 - 12/31/93
Final  01/01/94 - 06/30/94	
	
The coverage report should look as follows:

Subcontract Period: 01/01/92 - 12/31/94

How Covered ?  

01/01/92 - 06/30/92 Final 
07/01/92 - 06/30/93 Final
07/01/93 - 12/31/93 Provl
01/01/94 - 06/30/94 Final
07/01/94 - 12/31/94 Uncovered


My problem:

I have all the individual agreements on a database.  When the user enters a 
new subcontract, the system compares the contract period with the agreement 
period to establish coverage or otherwise.  I am using foxpro, and a command 
line like "for between(contractdate, agreement_start_date, 
agreement_end_date)" or "for between(agreement_end_date, 
contract_start_date, contract_end_date)".  I am not getting the desired 
result.  How do I properly tabulate the results of the comparison ?  What am 
I doing wrong ?  

I apologize if I am asking too much.  If someone has a solution for similar 
problem, and is willing to share, I will be very thankful.

Newsgroups: comp.dcom.isdn
From: joe@jshark.inet-uk.co.uk (Joe Sharkey)
Subject: Re: ISDN international tariffs
Organization: Independent Network (UK)
Date: Tue, 22 Dec 1992 00:03:45 GMT

In article <1992Dec21.143921.20121@cbfsb.cb.att.com> deej@cbnewsf.cb.att.com (david.g.lewis) writes:
>In article <BzKv7n.G82@jshark.inet-uk.co.uk> joe@jshark.inet-uk.co.uk (Joe Sharkey) writes:
>>In article <1992Dec19.214534.3982@cbnewsd.cb.att.com> varney@cbnewsd.cb.att.com (Al Varney) writes:
>>>   Where is 7500 cps from???  You should get 64000 bps / 8-bits/c
>>From the USA'a 56kb "digital" services - look at the rest of what you write.
>1.  The quotation marks on the word "digital" are somewhat inflammatory -
>56k switched digital services are just as digital as 64k switched digital
>services.  They're not ISDN, but then, they don't claim to be.

Then why mention them?  (Sigh) *You* brought them in...

>2.  The original poster was referring to a 64kb/s B-channel.  I am guessing
>Al assumed 64kb/s end-to-end, since the original poster made no reference to
>rate adaption to 56kb/s, and current standards state that a call with bearer
>capability/user service information of 64kb/s UDI, no rate adaption, can be
>cleared by the network if no 64kb/s clear channel facilities are available.

Want to translate that to American?  ``If I can get an end-end 64k circuit,
then I've got an end-end 64k circuit''??

>>>>Are there other costs to the telephone company involved that
>>>>already has ISDN capable equipment that can in any way justify
>>>>the extra cost of ISDN?
>>No. In the UK, ISDN comes in after the codecs, so there is *no* difference.
>>Q: Why should I pay more to use *less* of your equipment?  ;)
>
>Because you're not using less of my equipment.  Even looking solely at the
>line interface - where your "codecs" are - there's more "equipment"
>(hardware and software) for an ISDN interface than an analog loop.  An
>analog loop doesn't require a three-layer protocol stack to terminate the
>loop...

You're being silly!  Well, maybe AT&T don't know how to design switches!

>Disclaimer: It's not really my equipment, since my part of AT&T has nothing
>to do with ISDN BRI...

Claimer: I worked on these 15 years ago...

-- 
Joe Sharkey     joe@jshark.inet-uk.co.uk     ...!uunet!ibmpcug!jshark!joe
150 Hatfield Rd, St Albans, Herts AL1 4JA, UK      Got a real domain name
(+44) 727 838662         Mail/News Feeds (v32/v32bis): info@inet-uk.co.uk
Newsgroups: comp.dcom.isdn
From: curts@microware.com (Curt Schwaderer)
Subject: Re: ISDN and DECSTATION/5000
Organization: Microware Systems Corp., Des Moines, Iowa
Date: Mon, 21 Dec 1992 16:05:47 GMT




>	Well, software lacks. Device driver, layered sofware for isdn.
>	And wait for the standard for IP over ISDN to settle.
>
>	The chip used in many Personal Decstation and many others
>	is amd79c30a. Which is a complete ISDN telephone. The chip is
>	used in Sparcstation 1 and others but just the MAP (audio processor).
>	The chip price is about $30.
>	
>	Maybe it's time for a project...
>
>
>					Robert Olsson

We have ISDN drivers for the AM79c30A and layered software for call control
over the D channel as well as LAP-B, X.25, and soon internet support. It all runs
under OS9 or OS9000. It might be interesting to see about using our OS and 
ISDN I/O system on the DEC5000 (if anyone's interested). Feel free to call, write,
or post.
-- 
+--------------------------------------------------------------------------+
|Curt Schwaderer, WAN engineer, Microware Systems Corp, (515)224-1929 x388 |
|Des Moines, Iowa 50325-7077 | curts@microware.com | uunet!mcrware!curts   |
+--------------------------------------------------------------------------+
Newsgroups: comp.dcom.isdn
From: Bruce.Kravitz@launchpad.unc.edu (Bruce Kravitz)
Subject: Does MCI Offer Basic Rate ISDN?
Organization: University of North Carolina Extended Bulletin Board Service
Date: Wed, 23 Dec 1992 21:20:49 GMT

There is a chart on page 71 of the December 1992 issue of Data
Communications magazine which says that MCI "offers basic- and
primary-rate ISDN".  Is this true?  I didn't think that any U.S.
interexchange carrier offered basic rate ISDN.

-Bruce Kravitz

--
   The opinions expressed are not necessarily those of the University of
     North Carolina at Chapel Hill, the Campus Office for Information
        Technology, or the Experimental Bulletin Board Service.
           internet:  laUNChpad.unc.edu or 152.2.22.80
Newsgroups: comp.dcom.isdn
From: bob1@cos.com (Bob Blackshaw)
Subject: Re: 5ESS vs GTD5 in relation to ISDN capability
Organization: Corporation for Open Systems
Distribution: world 
Date: Mon, 21 Dec 1992 14:30:18 GMT

In <BzLnJL.E1H@well.sf.ca.us> nlane@well.sf.ca.us (Nathan D. Lane) writes:

>Here at my local phone company, perhaps the worst in the U.S. (GTE), they
>have indicated to me that they have 5ESS in two areas of their phone switch
>network.  They indicated to me that 5ESS would NOT do ISDN, which I know
>to be utter c--p after reading this group.  Unfortunately, I do not connect
>with a 5ESS switch - I connect with a GTD5, which I think is Northern
>Telecom.  Does anyone know (GTE doesn't) if the GTD5 is capable of ISDN

The GTD5 is GTE's own design switch machine. I am not certain, but I
believe they gave up on converting it to ISDN. The GTD5 can 'talk' to
most any other digital switch, but if they did indeed abandon the ISDN
conversion, it follows that it won't talk ISDN to anything.

>and can it talk with a 5ESS?  I would like connectivity to the bay area,
>which is Pacific Bell, and I know they have a good ISDN offering.  Whereas
>Santa Barbara just got DOV (19.2Kbps multiplexed via subcarrier on phone
>line) six months ago.  I cannot afford ADN (56Kbps) or the $2000 price
>tag on the switched 56K offering (which is supposed to go into MY phone
>switch because GTE claims it is not isdn capable).  I really need to do
>NFS and X across my line, but at 19.2K, these are pretty unreasonable.
>I telecommute 90% of the time to work (even though only 12 miles away,
>due to interruptions from users).  I have received responses from those in
>my local area (Thanks to Rockwell CMC!) that ISDN is a LONG, LONG ways
>off for us.  However, I just wanted to know if the GTD5 is capable of the
>ISDN, as well as a stock, base 5ESS (does it need upgrades to do ISDN or
>is it a standard capability?)

>Thank you for any responses.

You're welcome.

>-Nathan Lane
>Triicon Systems, Santa Barbara, CA
>nlane@well.sf.ca.us

Bob.
From: tspencer@pilot.njin.net (Thomas Spencer IV)
Newsgroups: comp.dcom.isdn
Subject: Re: The ISDN network
Date: 27 Dec 92 04:48:49 GMT
Organization: Rutgers Univ., New Brunswick, N.J.


From: bcapps@atlastele.com (Brent Capps) writes:

>Resolution isn't what's driving the adoption of G4, speed is. 

     Which is the whole point of ISDN.  What I find so interesting about
the people who are saying that ISDN won't catch on is that they are
completely ignoring the history of performance in computing.

     New, fast equipment is bought because it is faster.

     I've been involved in retail, and if your gismo doesn't have the
latest and greatest it won't sell, and if it does, it doesn't matter how
much you charge, people will buy it.  When people have ISDN available,
it will be installed mearly because it is faster.  No other reason.  Just
look at computers.  Companies replace 8088, 8086, and 80286 machines just
for their secretaries even though they will continue to use the non-windows
version of Word Perfect.  Why?  Not because the older equipment won't do
the job, because it can, but because it isn't the latest and greatest.
The .003% of calls that refered to as the installed base of ISDN will
grow.  The backward compatability problem has been handled by multiple 
products (examples were given in other posts), and people who use computers
will be in the vanguard of users who install ISDN.  Anyone who connects to
BBSs will want one to cut down on connect time.  BBS operators will want
to install it for a pair of reasons: a) Their users will want it, and b),
it will cut down on connect time of each user so a single line can handle
more people.

     ISDN will become very popular once it is widely available.  We should
stop saying it won't be because history doesn't support it.  The only real
danger that ISDN (ie, the two 64kbps channels and one 16kbps channel) faces
is that Broadband ISDN will be only a year or two behind in deployment.
A town in New Jersey will have Broadband ISDN installed by '95, not as a
test, but as a working, stable installation.  By '96, that will be the
standard for any new installation of phone service.  This is not a possibility,
but reality.  ISDN might not become widely used on the east coast because the
next generation will already be to market.

Tom Spencer
From: randy@psg.com (Randy Bush)
Newsgroups: comp.dcom.isdn
Subject: Re: The ISDN network
Date: 26 Dec 92 20:06:48 GMT
Article-I.D.: psg.1992Dec26.200648.13492
Organization: Pacific Systems Group, Portland Oregon, US

jpsb@NeoSoft.com (Jim Shirreffs) writes:
> I have been trying to find out what equipment I need so that I can 
> have an Xwindows session between my home system and my office system.
> ISDN seems to be the best answer. But I cann't get anywhere with my
> local carrier (GTE Houston)

Well, Houston has many drawbacks <g>, but connectivity is not one of them.
You have a chap down there name of Stan Hanks.  Works for Metropolitan
Fibre or something like that.  Supposedly has Houston wired to the walls.
I forget the details (sorry), but give it a try in the phone book.
-- 
randy@psg.com   ...!uunet!m2xenix!randy