HDTenEightyP/NetNews huggingface dataset:
From: ummalik@ccu.umanitoba.ca (Ijaz Rashid Malik)
Subject: A question re: Forms in Paradox
Organization: University of Manitoba, Winnipeg, Canada
Date: Wed, 27 Jan 1993 13:00:26 GMT


Hello,
In Paradox, the detailed form cannot contain any embeded forms. Fine! 
I am working with an acccounting+database system. I have a master business
table that houses list of all client businesses. Then there is a detailed
form from Ledger table that shows payment history of each business. There
is a third table called Accounts Receivable which comes under Ledger table.
(Ledger table is its master as A/R table has a field from Ledger table that
identifies which Ledger entry this A/R amount is for). Right now I am using
Business's form as Master and showing Ledger on the same form as detailed
link table. But I also need to show (user's demand) the A/R amount (if any)
for every Ledger entry (for users quick visual reference). But I cant do that
under current set up as Ledger acts as master of A/R and Ledger is already
a detailed form. I thought of making ledger the master but that does not
work since Business and Ledger have 1:M relationship, and I dont want to
add the A/R stuff into ledger table as my Ledger table is already containing
about 8 fields. Any ideas as to how I can display A/R entries on the same b
business form although they are linked to Ledger table?

thanks very much for your help,

Malik
From: someday@hardy.u.washington.edu (Scott Johnson)
Newsgroups: comp.databases
Subject: Re: Revelation paint -- Define Page
Keywords: Revelation Paint
Date: 26 Jan 93 20:24:06 GMT
Article-I.D.: shelley.1k46l6INNt7l
Organization: University of Washington, Seattle
NNTP-Posting-Host: hardy.u.washington.edu

In article <> cpetersn@iastate.edu (Clifton R Peterson) writes:
>In <> DTodd@massey.ac.nz (D.M. Todd) writes:
>
>>How do you define pages in paint in 3.xx?  The manual says to select
>>the prompts to fit on a "page" and press F2 and select Define Page.
>>I don't get a Define Page option.

>I don't know what the problem is with your installation.  On my 3.01, If I
>select 1 prompt, press F2, I get a popup with about 15 items, numbers 10 and
>11 are Define Page and Undefine Page.  Pressing F1 from the popup gives a
>help message for PROMPTOPTS2.  If I select multiple prompts and press F2, I
>get a popup with only 13 items (I think, didn't jot the number down), again
>with 10 and 11 as above and the popup help is for PROMPTOPTS4.
>
>Are you selecting labels along with prompts before pressing F2?  I don't know
>if this is different (not multitasking so I can't switch back to AREV) than
>selecting only prompts as regards the Options.
>
>Clif

Bingo, Clif.  If you get a label mixed in with the selected prompts,
then several options do vanish from the Options list.

Strangely, the guy who wrote that section in the manual came to me
today with exactly the same problem.  He's now rewriting that
paragraph to be less unclear.

(I designed and coded that whole Options popup feature myself, so
blame me for any part of it that doesn't make sense!)

Scott Johnson
Revelation Technologies
Newsgroups: comp.databases
Subject: Re: Looking for List of Clipper Consultants
From: cocks_d@kosmos.wcc.govt.nz
Date: 23 Jan 1993 21:01:11 GMT
Reply-To: cocks_d@kosmos.wcc.govt.nz
Organization: Wellington City Council (Public Access), Wgtn, Nz
NNTP-Posting-Host: kosmos.wcc.govt.nz

In article <1jqdemINN547@usenet.INS.CWRU.Edu>, ch140@cleveland.Freenet.Edu (Jeffrey G. Brown) writes:
>
>My company has a Clipper (S87) application that needs some work
>to finish it up. The programmer [me... :-( ] has been pulled off
>the project to assume other duties. I am looking for any lists
>or directories of Clipper programmers or consultants that may
>be out there. Thanks in advance....
>
>Jeffrey G. Brown
>ch140@cleveland.freenet.edu
>
I do Clipper Summer 87 consulting. The consulting would need to be via
electronic means since I live in New Zealand.

Regards, Derryl.

________________________________________________________________________________
Mail: 	Derryl Cocks, Analyst/Programmer
	New Zealand Fire Service, PO Box 2133
	Wellington, New Zealand
Phone:	(4)4724969  Fax: (4)4781603  International: +64 4 47.... 
Email:	"cocks_d@kosmos.wcc.govt.nz"
________________________________________________________________________________
From: field@.cs.pitt.edu.cs.pitt.edu (Brian Field)
Newsgroups: comp.databases
Subject: Paradox questions
Date: 21 Jan 93 17:24:09 GMT
Organization: Univ. of Pittsburgh Computer Science
X-Newsreader: Tin 1.1 PL3


Two questions regarding Paradox 4.0.

1) I'm writing a script that changes the field types of several fields in a
	table.  Since I couldn't figure out how to do this directly from the
	manual, I recorded a script where I manually changed the file types,
	and checked out the script.  The script looks something like this:

	{Modify} {Restructure} {table_name} Down Down Down .....
	Right Right Backspace Backspace "A8"

	Now, this works ok, but doesn't allow me to change this field's
	relative position in the table, without going back and changing the
	script.

	Is there a way to do something instead, like:

	{Modify} {Restructure} {table_name} {field_name} {student name}
	{field_type} "A40"

	??

2) 	How does one access the contents of a field name that have been passed
	as an arguement to a procedure?  Do I need to use EXECUTE to do this,
	or is there an alternative?

Thanks

Brian
-----
field@cs.pitt.ed
From: higgins@tanne.uni-paderborn.de (Frank Westheider)
Newsgroups: comp.databases
Subject: Looking for national-character-tables
Date: 24 Jan 1993 15:59:14 +0100
Organization: Universitaet Paderborn, Germany
NNTP-Posting-Host: tanne.uni-paderborn.de
Keywords: tables

HI Folks !

I am sitting here in Paderborn in Germany and we (same friends and i)
will create a national-independant-database on PD-Base.
Now we want to include as much information as possible about language
tables for the different countries and languages.

We need to now :
   How to handle special characters of that language.
   The relation of these characters in the order of all characters
     (a<b<c<d< .... <z<A ..... and so on)

Thanks for the help

  Frank  (higgins@uni-paderborn.de)
   
Newsgroups: comp.databases
From: "tom frazer" <tom.frazer@canrem.com>
Subject: dbase iv hierarchical poi
Reply-To: "tom frazer" <tom.frazer@canrem.com>
Organization: Canada Remote Systems
Distribution: comp
Date: 22 Jan 93 01:37:41 EST

DD> will need to start with a person and create a list of supervisors betwe
DD> specified person and the "big boss."

DD> Can I do this by simply storing a key or pointer to the supervisor reco
DD> each person's record, then use that key or pointer to recursively retri
DD> supervisor, then his/her supervisor, and so on?  If this is possible, i

    Judging by your information the database will contain information
on all employees, so why not just

    OPEN DATABASE
    FIND employee
    STORE fields to memvars (including supervisor1 and RECNO())
    FIND supervisor1
    STORE this employees supervisor to a memvar(supervisor2)
    FIND supervisor2
    STORE this employees supervisor to a memvar(supervisor3)
    continue till no further supervisors exist (big boss)
    EDIT, print report program or whatever...
 
     Tom Frazer    tom.frazer@canrem.com    canrem!tom.frazer 
                       RIME = ->CRS   FIDO = 1:229/15              
---
 * Qwkit 1.0 * SYSOP = Sent Your Spouse Obsene Pictures
--
Canada Remote Systems  - Toronto, Ontario
World's Largest PCBOARD System - 416-629-7000/629-7044
From: anadeem@ampere.bit.listserv.tech-l (Ahmed Nadeem)
Newsgroups: comp.databases
Subject: MRI and CT-SCAN Images For Dogs
Date: 27 Jan 93 07:44:21 GMT
Article-I.D.: ampere.ANADEEM.93Jan27004421
Distribution: comp.databases
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
From: troj@cwis.unomaha.edu (Kevin Trojanowski)
Subject: Re: picking between FoxPro and Paradox
Keywords: help
Organization: University of Nebraska at Omaha
Date: Tue, 26 Jan 1993 02:48:14 GMT

hh2x@crux3.cit.cornell.edu (Danish) writes:

>I'm working with a group on a large (10k+ lines) C program that manipulates
>large amounts of data in various ways. We want to buy a database so that we
>can perform some more standard manipulations on our output data. The main
>thing is sorting the data quickly on any field. Which program -- Foxpro or
>Paradox, or is there something faster I haven't heard of yet-- is faster
>when sorting huge data files up to 150 meg? can they both handle files of
>this size? if not, which handles larger files, and what are their limitations?

>If Foxpro and Paradox are equal in this respect, then it would be helpful
>to know which one is easier to manipulate. Half of us are c programmers who
>could get by either way, but the other half might be aided by an easier
>interface... which program makes this easier to provide?

FoxPro is a dBase derivative, and I've never been a big fan of dBase.
Actually, a more accurate assessment would be to say I loathe it.  But
anyway...

If you go with Paradox, you gain an easy advantage, in that you can purchase
the Paradox Engine, and have your C code directly access the Paradox tables.
What this allows you to do is write part of your application in PAL
(Paradox Application Language), and have it run external C programs when
necessary, but still allow the C code full access to the data without
having to go through the overhead of exporting/importing the data.

If it's imperative that your C code be in primary control of things, then
you can still use the Paradox Engine.  However, rather than have PAL code
run your C programs, your C programs can fire up Paradox with the desired
PAL scripts.

I'll freely admit that, like anything similar, there's a bit of a learning
curver for the Pdox Engine.  However, I've not found it to be an overly
difficult one -- just a matter of learning how to setup for the various
calls, and understanding how Paradox field types map to C types.  It'll
take you a couple of days of playing around, but it's none too painful.

-------------------------------------------------------------------------------
-                                   "She had what it took: great hair, a      -
- Kevin Trojanowski                  profound understanding of strategic lip  -
- Internet: troj@cwis.unomaha.edu    gloss, the intelligence to understand    -
-      CI$: 70521,312                the world and a tiny secret interior     -
- US Snail: 1905 Thurston Ave, #8    deadness which meant she didn't care."   -
-           Bellevue, NE 68005                            -Douglas Adams      -
-                                                          _Mostly Harmless_  -
------------------------------------------------------------------------------- 
Newsgroups: comp.databases
From: tleylan@pegasus.com (Tom Leylan)
Subject: Re: dBASE III+/Foxbase Question
Organization: Pegasus,  Honolulu
Date: Wed, 27 Jan 93 08:12:13 GMT

cocks_d@kosmos.wcc.govt.nz writes:

I don't know if anybody is interested in discussions on coding style
since people seem to take so many things so very person but I'll try
a few suggestions since the opportunity presented itself

>STORE "" TO METHOD
>@10,10 say "Output method (S)creen, (P)rinter or (F)ile"

The empty string won't work.  Consider "unpacking" code by adding
spaces for readability.  If you use an interpreter it might help to
squeeze them out but use a software tool when the app is done.

>DO WHILE .T. && Endless loop which will be broken by the EXIT command
> @10,2 get METHOD
> READ

Avoid uncontrolled loops.  Yes you can EXIT, no you should not.  Set a
variable or controlling expression and exit from the end of the loop.
Consider not commenting "DO WHILE .T." it is like "Var = 5" if one
can't figure it out no amount of commenting will help.

> IF METHOD $ "SPFspf" && Does the letter S,P or F appear in variable METHOD?
>  EXIT
> END IF
>ENDDO

You wouldn't have needed to (and shouldn't) test both upper and lowercase
command characters if you had used the appropriate picture statement in
the GET.

>DO CASE
> CASE METHOD $ "Ss"
>  && Don't do a thing cause will default to screen
> CASE METHOD $ "Pp"
>  SET CONSOLE OFF && Turn off screen
>  SET PRINTER ON
> CASE METHOD $ "Ff"
>  STORE "" to FILENAME
>  @12,10 say "Name of file" GET FileName
>  READ
>  SET CONSOLE OFF
>  SET ALTERNATIVE TO FileName
>END CASE

Consider not adding a CASE statement that doesn't do anything.  If you
need an empty "default" the OTHERWISE "case" is provided but even that
isn't needed here.

>... and tidy up housekeeping
>SET PRINTER OFF
>SET CONSOLE ON
>CLOSE ALTERNATIVE
>SET ALTERNATIVE TO

As a general rule one should avoid "untidying" what wasn't tidied to
begin with.  It would take a little reorganization of the code but
if the ALTERNATIVE hasn't be OPENED then one shouldn't CLOSE it and
yes I realize that it doesn't break anything by doing so... in this
example using this language.  It is however a poor habit to get into.

Hope this has been of some benefit to the parties involved, if you want
to discuss it I'd be happy to but if you're going to tell me to go take
a flying leap it wasn't my intention to degrade anybody just to offer
assistance.

Take it or leave it.

tom "you can tell I've grown a bit leery of Usenet" leylan

Newsgroups: comp.databases,comp.databases.informix,comp.databases.oracle
From: geof@cbnewsm.cb.att.com (geoffrey.a.myers)
Subject: database file formats info requested
Organization: AT&T
Distribution: na
Date: Thu, 21 Jan 1993 19:10:58 GMT
Followup-To: poster
Keywords: oracle, informix, progress


I am posting this for  a co-worker that does not have net access.  You
may respond to me or him.

	Hi,
	I am interested in finding information on the 
	file formats in Informix, Progress, and Oracle.
	Are there utilities out there that will read
	the database files for these databases.
	We are trying to tie the data together from several
	different sources and would like to create a central
	utility.
	We have had trouble using anyone of these sources.
	The Progress utilities require that you precompile
	and hard code the name of the files that you wish	
	to modify. It is ignorant of Informix data files
	as well. Informix and Oracle have their problems
	as well.
	I would like share ware or lists of vendor software
	either or both are fine.
	If the file formats are documented in good texts 
	that information would be most welcome.

	Thank You for any assistance.

	don fair.

	dhf@green.att.com
-- 
Until later, Geoffrey Myers	404.750.5247	cbnewsm!geof

gamyers@attmail.att.com	...!att!attmail!gamyers
geof@green.att.com	...!att!green!geof
From: DTodd@massey.ac.nz (D.M. Todd)
Newsgroups: comp.databases
Subject: Revelation paint -- Define Page
Keywords: Revelation Paint
Date: 26 Jan 93 03:21:16 GMT
Organization: Massey University, Palmerston North, New Zealand
X-Reader: NETNEWS/PC Version 2c

Sorry if this repeats, an earlier posting doesn't seem to have made it.

How do you define pages in paint in 3.xx?  The manual says to select
the prompts to fit on a "page" and press F2 and select Define Page.
I don't get a Define Page option.

TIA
Newsgroups: comp.databases
From: moursand@lonestar.utsa.edu (Bowen M. Moursund)
Subject: Re: dBase IV hierarchical pointers - how?
Keywords: dBase
Organization: University of Texas at San Antonio
Date: Thu, 21 Jan 1993 22:45:15 GMT

>I am scoping out a dBase IV business application which is mostly a
>flat-file name and address database.  However, I also need to store some
>hierarchical information concerning supervisor-supervisee relationships.
>Occasionally I will need to start with a person and create a list of
>supervisors between the specified person and the "big boss."
>
>Can I do this by simply storing a key or pointer to the supervisor record
>in each person's record, then use that key or pointer to recursively
>retrieve the supervisor, then his/her supervisor, and so on?  If this is
>possible, it is difficult to do?

The method you suggest is probably the simplest, although it will require
some programming. Add an ID and SUPERVISOR field to the name&address DBF.
Populate the ID field with unique IDs, SUPERVISOR with the correct IDs,
and create an index on the ID field.

To display the chain of supervisors, bottom up, on screen:

accept "Enter ID: " to cID
use the_dbf order ID
seek cID
* loop while the current record has a supervisor
do while "" <> the_dbf->supervisor
    cSubordinate = trim(the_dbf->name)
    seek the_dbf->supervisor
    ? cSubordinate + "'s immediate supervisor is " + the_dbf->name
enddo

If you want to get fancier, store the names/IDs as retrieved to a temporary
DBF and design a dBASE report based upon the temp file.

Bowen Moursund
From: "tom frazer" <tom.frazer@canrem.com>
Subject: dbase 4v1.1:can i change
Reply-To: "tom frazer" <tom.frazer@canrem.com>
Organization: Canada Remote Systems
Distribution: comp
Date: 28 Jan 93 09:12:45 EST

JF> second application (and vice versa).  The problem is, I don't see any
JF> way to switch directories once I am in dbase.  The PATH command doesn't
JF> do me much good, since a number of my file names are common to both

    From the ASSISTANT, ALT-T, D, ALT-D, PgDn, <enter>, enter the new
directory name (pressing <ENTER> at the end, of course)(note: while it
doesn't show anything on the screen, in 1.5 (not sure about 1.1) you can
press SHIFT-F1, at this point, to create a directory tree and use that to
change directories) then ESC out to the ASSISTANT, and you will be in the
new directory.
 
     Tom Frazer    tom.frazer@canrem.com    canrem!tom.frazer 
                       RIME = ->CRS   FIDO = 1:229/15              
---
 * Qwkit 1.0 * "Romulans, Ferengi, and Borgs.  Oh My!!"
--
Canada Remote Systems  - Toronto, Ontario
World's Largest PCBOARD System - 416-629-7000/629-7044
Newsgroups: comp.databases
From: oliver@delphi.nosc.mil (George Oliver)
Subject: Re: Secure databases
Organization: Naval Ocean Systems Center, San Diego, CA
X-Newsreader: TIN [version 1.1 PL7]
Date: Thu, 28 Jan 1993 16:02:35 GMT

Bradley Edelman (brad@hawk.adied.oz.au) wrote:
: What databases are Multi-Level Secure (MLS) and run on CMW?  I know there is 
: Trusted Oracle, Secure Ingres and Informix-OnLine/Secure that are supposed to 
: be MLS, but do they run on Sun CMW?
: 
: Brad. [brad@hawk.adied.oz.au]
: Australian Defence Industries Ltd,
: Enterprise Unit 3, Technology Park,
: Bentley, WA 6102, Australia.
: Tel: (09) 333 8888.  Fax: (09) 333 8889.

I know Trusted ORACLE is available (or soon to be available) on Sun CMW

Geo.
From: tener@cs.widener.edu (Stuart Tener)
Newsgroups: comp.databases
Subject: Re: Clarion
Date: 21 Jan 1993 14:43:20 -0500
Organization: Widener University CS Department, Chester PA
NNTP-Posting-Host: lucy.cs.widener.edu

In article <1993Jan21.053958.25082@serveme.chi.il.us> pkim@gagme.chi.il.us (Peter Kim) writes:
>Stuart Tener (tener@cs.widener.edu) wrote:
>: Is anyone on this net into clarion? I just got the clarion 3.0
>: pre-release! I am looking for fellow clarion programmers to discuss and
>: clarion tips and tricks with.
>: 
>: What does anyone think of 3.0beta?
>: 
>
>I am not a heavy user but I was impressed with the beta version. It is
>about time after such a long delay. 
>
>Do you know if there is a way to get Clarion articles on CompuServe
>without having to be a CompuServe member? 

Don't know of anyone providing such a service, but I guess it would be
nice if someone did. How about starting an FTP site for clarion stuff?
Will anyone be willing to sponcer such a thing?

There is alot of public domain clarion stuff out there. The problem is
that clarion developers are very disconnected. Most people don't care
for or don't want to pay for compuserve. ClarioNet is now dead, and we
are all forced to use compuserve if we are looking for on-line support.

Me I choose to use electronic mail to clarion via the internet:

76711.1034@compuserve.com

I mean why pay to use compuserve email, when you can use the internet,
right? Why pay for the same service twice I say!

Newsgroups: comp.databases
From: michaelh@g2syd.genasys.com.au (Michael Haldey)
Subject: Re: Recommendation for dBase III+ development system/libraries
Keywords: dBase development
Organization: Genasys II, Sydney, Australia
Date: Wed, 27 Jan 1993 04:00:20 GMT

In article <1993Jan27.035809.3971@g2syd.genasys.com.au> michaelh@g2syd.genasys.com.au (Michael Haldey) writes:
>
>CodeBase will give you more flexibility than Clipper but development is
>slower; if you do need to port your systems, say, into UNIX, I do not
>advise you to use it.
	       ^^^^^^^

I meant Clipper.  CodeBase is the most suitable (and probably the only)
product for that.
-- 
Michael Haldey  |  Genasys II Pty Ltd, Sydney, Australia
                |  Phone:    +61-2-954-2878 (-9930 FAX)
                |  Internet: michaelh@g2syd.genasys.com.au
From: jimc@tekcae.cax.tek.com (Jim Carden)
Newsgroups: comp.databases
Subject: Looking for inexpensive SQL db, widely available
Summary: Need SQL db for Win3.1, Unix, and VMS
Date: 28 Jan 93 17:11:26 GMT
Organization: Mitron Corp., Beaverton,  OR.


[[** Posted for patl@goldfish.mitron.tek.com **]]

I am looking for databases that support SQL that are available
on Windows 3.1, the major Unixes (Sun, HP, IBM), and VMS.

Ideally, dbs should be able to be distributed without royalty.

Any help is appreciated.
--
posted for:
Patrick Logan, patl@goldfish.mitron.tek.com, (503) 690-8350
Newsgroups: comp.databases
From: boggs@a.cs.okstate.edu (BOGGS RICHARD GRAN)
Subject: Database development systems
Organization: Oklahoma State University, Computer Science, Stillwater
Date: Wed, 27 Jan 93 23:30:50 GMT

I've decided that I'm using the wrong language (C++) for the application I need
to write.  I was just exposed to DBASE IV and was impressed with the ease of
application generation possible (via the form designer and simple near-BASIC
like language).

I know there are several development packages out on the market for PC's.  The
question is, which one?

I would like a package that has a form designer and report designer.  I under-
stand some packages allow you to link in C/C++ modules for extra processing
power (WATCOM SQL?).

Network capability is not necessary (though would be nice to be able to upgrade
to that with minimum maintainence).

Any suggestions from the people in the field?

Anyone worked with WATCOM SQL or CA-CLIPPER?  Opinions?  References?


-- 
Grant Boggs
boggs@a.cs.okstate.edu
Oklahoma State University
Stillwater, Oklahoma
From: rfitzgerald@cpva.saic.com
Newsgroups: comp.databases
Subject: Re: Dbase III question
Date: 22 Jan 93 10:36:00 PST
Organization: Science Applications Int'l Corp./San Diego

In article <93020.210833U56779@uicvm.uic.edu>, <U56779@uicvm.uic.edu> writes:
> I working on a programm where I want to be as easy as possible.
> I created a name field in the .dbf file.  I call it by using
> x=space(20)
>  @12,12 "Enter name " get x picture "!XXXXXXXXXXXXXXXXXXXX"
> read
> 
> This way it will allow user to type name with first letter being
> capitalized.  My question is that is there a way so that last name
> typed after a space within the same field could also have the
> first letter capitalized?
> I would appreciate all the help.
> 
>                                                    -AP.
Hi, and I thought dBASE III was dead!
Here are a few options:
1) Add a second field for the last name and use the same picture clause as in
the first name.
2) Write more code after the read to parse the field and capitalize the first
letter of each word.  ie: a loop with a substring command.

Richard
Newsgroups: comp.databases,comp.object,comp.databases.theory