HDTenEightyP/NetNews huggingface dataset:
From: durai@ORTTA (Appadurai V.)
Subject: Re: FOXPRO 2 - TOTALLING COLUMNS IN A BROWSE WINDOW ???????????
Organization: U of Mn
Date: Wed, 9 Sep 1992 17:30:28 GMT

In article <4SEP199213041228@apsicc.aps.edu> einhorn_d@apsicc.aps.edu (E. Drew Einhorn) writes:

>In article <i15.1@cs-acad-lan.Lakeheadu.Ca>, i15@cs-acad-lan.Lakeheadu.Ca writes...
>>Can this be done?  I am useing a browse window as a data input screen.  Due 
>>to the nature of the input a browse window makes the most sense.  At the 
>>bottom of each column in the browse window I need to be able to see the 
>>current total of that column (field).  It is not necessary to be able to see 
>>these total at all times - it's good enough to see them when you reach the 
>>bottom of the window.  Is this possible, or is there a way to open an 
>>additional window under the browse window to display these totals?  This one 
>>is kind of stumpping me.
>> 
>>Thanks a million
>> 
>>Dan Sullivan

>Check out Example in FoxPro Developer's Guide (One of the thick books in
>the FoxPro 2.0 Documentation Set) starting on page D2-89.

I could not find the example.  Can you be more specific ?  Thank You.

Meanwhile, Dan may want to try this out.

You can open as many windows concurrently active with the browse based data 
entry window.  You can display the totals in one of those windows.
From: DEVRIES@NAUVAX.UCC.NAU.EDU (Ernie DeVries)
Newsgroups: comp.databases
Subject: Re: Yet Another Simple (?) Question on Paradox
Date: 10 Sep 92 20:57:34 GMT

Using CoEdit instead of Edit will allow you to open a blank record, but will not
let you leave the record blank by moving off of it to another record.  This
makes sense if you think of what Paradox does with blank records in Edit, it
simply discards them when you Do_It!  I suppose CoEdit could have done the same
thing, but since it writes each record to disk when you leave the record,
Borland apparently decided not to let you post the record at all.
+========================================================+
|     /\                   Ernie DeVries                 |
|    /  \/\      Academic/Personal Computer Services     |
| /\/    \ \/\       DeVries@nauvax.ucc.nau.edu          |
|   Northern Arizona University   "The Mountain Campus"  |
+========================================================+
From: walz@elde1.epfl.ch
Newsgroups: comp.databases
Subject: C-tree and db-VISTA, any experiances ?
Date: 11 Sep 92 09:47:58 GMT
Organization: Ecole Polytechnique Federale de Lausanne


I plan to write an interactive database application generator and I'm
looking for a database engine I can use for this. I've had a look on
Faircom's C-tree and Raima's db-VISTA. Has anybody had good or bad
experiance with one of those products of with some other similar products
(C-written database engines in source form) ?

Michael Walz
walz@elde.epfl.ch
Newsgroups: comp.databases
From: thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040)
Subject: Re: HELP! db_Vista needed!!
News-Software: VAX/VMS VNEWS 1.4-b1  
Organization: NASA/GSFC-Laboratory for Astronomy and Solar Physics
Distribution: usa
Date: Sun, 13 Sep 1992 18:46:00 GMT

In article <1992Sep13.144203.10766@bts.com>, phil@bts.com (Phil Eschallier) writes...
>In article <1992Sep11.135105.12243@magnus.acs.ohio-state.edu> dyoung@magnus.acs.ohio-state.edu (Donn C Young) writes:

	(stuff deleted)

>   Raima db_VISTA (now designated Raima) is a database management system using
>   a combination of network and relational database models. Raima is written in
>   C and may be ported to many operating systems including MS Windows, OS/2, Unix,
>   Xenix, and VAX VMS giving you a wide range of hardware options. The system
>   features such things as LAN and multi-user computer support, client-server
>   architecture, transaction processing/logging, a SQL-based ad hoc query
>   system, and database security functions.
> 
>[ more stuff deleted ... ]
> 
>   Donn Young, Director, Biostatistics Unit, OSU Cancer Center, 614/293-3075
>   dyoung@magnus.acs.ohio-state.edu
> 
>i am happy to see that others on the net are using db_vista (now the
>raima data manager).  i have used this product suite for years (my
>company even provides consulting in this area).
> 
>while i am very happy with raima's tools, i have to question the
>'client-server' capabilities stated above.  while it is possible to
>configure data manager applications to work across a tcp/ip network,
>you'll find a strong performance penalty due to the nature of their
>implementation decisions.  in particular, as found in the release
>notes of 3.21, the tcp/ip lock manager closes files and re-opens them
>on the server after each update (rather than relying on the lock
>daemon).
> 
>when relible lock daemons are available across all hosts in your
>network, this is not a problem.  the source to the libararies can then
>be changed.

I've heard that Raima is supposed to be coming out with a "true" client-server
by the end of the year.  I don't know any more about it than that, though--I
just got that from their sales rep.

Bill Thompson
From: neal@mnopltd.UUCP
Newsgroups: comp.databases
Subject: Re: Simple Warm Standby DBMS's -
Date: 7 Sep 92 20:13:47 GMT
Reply-To: emory!mnopltd!neal
Organization: MNOP Ltd., Atlanta, Ga.

There has been a lot of interesting discussion on this problem.   Here is 
a simple arrangement which does seem to work:

Progress RDBMS Version 5 and higher support a separate after-image file.  
This file can be forced over to an RFS mounted file system on the hot system. 

After failure, the roll-forward will bring the database up to the last 
complete transaction written.   Thus, recovery time is about 20 minutes, 
depending on how long since a backup copy of the primary db was placed on
the secondary. 

Version 7 may avoid doing seeks on the after image file, so it could be 
placed on /dev/rct0, thus avoiding the networking.   Use on the spare
involves pulling out tape, inserting, doing roll forward.   

If you can stand having the system down for a few minutes several times 
a day the AI files can be switched, and you can run the roll forward on 
the spare, keeping it closer to the contents of the live system and 
making failure cutover quicker. 

Now I wouldn't use this for Air Traffic Control, but if you can afford
to be down for 20 minutes it might work. 


------------------------------------------------------------------------------
Neal Rhodes                       MNOP Ltd                     (404)- 972-5430
President                Lilburn (atlanta) GA 30247             Fax:  978-4741
                             emory!mnopltd!neal 
------------------------------------------------------------------------------
Newsgroups: comp.databases
From: aahz@netcom.com (Mean Green Dancing Machine)
Subject: Re: Paradox Command Line Switches?
Date: Fri, 11 Sep 92 23:45:11 GMT
Organization: Bill 'n' Opus for Prez
Distribution: na

In article <1992Sep11.173501.2991@murdoch.acc.Virginia.EDU> cyj9h@csissun12.ee.Virginia.EDU (Charles Y. Choi) writes:
>Does anybody here know what all of the command line switches to
>Paradox 3.5 are?  For the life of me, I can't find it in the docs.

Look in the index of the User's Guide under "command-line".

>What I really want to do is to be able to view a table through
>some variation of paradox <some switch> <filename>.  I don't want
>to have resort to a script file to accomplish this.

You need to use a script.
-- 
                         --- Aahz (the *other* Dan Bernstein)
                             @netcom.com 

Hugs and backrubs -- I break Rule 6

IRWTFM -- and that ain't fun
Newsgroups: comp.databases
From: tnishi@kansas.Berkeley.EDU (NISHIYAMA Tetsuto)
Subject: HELP! db_Vista needed!!
Reply-To: tnishi@lsa.ncl.omron.co.jp
Organization: Omron Computer Systems R&D Labs 
Date: Fri, 11 Sep 1992 01:03:05 GMT

	Does ANYONE know about db_Vista?  It's my understanding
that db_Vista is "free software" but no one here at my office has
ever heard of it...

	If it IS free and someone has the source to this, I would 
appreciate it if it could be e-mailed to me...also, any information 
about it would be helpful.

	If this isn't the right group, could someone please tell me 
where I could find out about this?

	thank you in advance.
=========================================================================
Teddy Nishiyama  (tnishi@lsa.ncl.omron.co.jp)  OMRON Corporation  (^_^;
R&D Support Dept(LSA), Shimokaiinji, Nagaokakyo-shi, Kyoto-fu 617  JAPAN
Newsgroups: comp.databases
From: cyj9h@csissun12.ee.Virginia.EDU (Charles Y. Choi)
Subject: Paradox Command Line Switches?
Organization: University of Virginia
Distribution: na
Date: Fri, 11 Sep 1992 17:35:01 GMT

Does anybody here know what all of the command line switches to
Paradox 3.5 are?  For the life of me, I can't find it in the docs.

What I really want to do is to be able to view a table through
some variation of paradox <some switch> <filename>.  I don't want
to have resort to a script file to accomplish this.

Thanks!

-charles
 cyj9h@Virginia.EDU

 
-- 
"What a morning!  Birds, fish, frogs, and humans!"
                                      -Maya the Bee
From: syeoh@acsu.buffalo.edu (Lam Yeoh)
Newsgroups: comp.databases
Subject: secure databases w/ encryption
Date: 15 Sep 92 17:18:40 GMT
Distribution: usa
Organization: UB

I'm looking for a database (to run on a PC) that will provide some forms of
security.  It should support multiple user concurrently (though it doesn't
have to).  The primary features required are password access to files and
some sort of encryption of the data.

DES is not required and cost will be a concern, so other options will be
explored also.

The system should also have a good (and easy to use) ad hoc query tool.

-- 
Stephen Yeoh                    SUNY@Buffalo

psyeoh@ubvms.cc.buffalo.edu
syeoh@acsu.cc.buffalo.edu
Newsgroups: comp.databases
From: jtw@cbnewsh.cb.att.com (jui-tai.wang)
Subject: Re: Paradox -- O Woe is Me!
Organization: AT&T
Distribution: usa
Date: Mon, 14 Sep 1992 22:44:31 GMT

In article <1992Sep11.163841.4099@dcatlas.dot.gov>, joet@dcatlas.dot.gov (Joe Trott) writes:
> exuptr@exu.ericsson.se (exuptr@exu.ericsson.se) writes:
> 
> >In article <5233@news.duke.edu> maria@acpub.duke.edu (Maria Spicer) writes:
> >>From: maria@acpub.duke.edu (Maria Spicer)
> 
> >>And so begins my Paradox nightmare...
> 
> ...lots of grief deleted...
> 
> >I think your best bet is going to be re-modifying the table structure to
> >exactly match what you had before the goof.  
First, assume your are using Paradox 3.5.

Don't remember and cannot find the exact article, but I remember within
last half year that I have read an article that may be helpful to your
situation. That articule specifically deal with "obsolete" forms and
record caused by change in table structure. I remember that article
mentioned that Paradox saved its form/report info "header" (or some
kind of pointer type information) in the table. With a trick you can
actually reset that pointer/header/counter so that the table will not
think the form/report being obsolete any more.

Obviously the best solution is to have a good backup to recover from (which
from your post it seems like out of question).

Sorry I cannot locate article. I just want to suggest you to ask around,
or even ask Borland if they can show your the way to do so. I will imagine
to alter that type of pointer/header/counter you may need to use some
binary file editor to do it.

Good luck

Richard Wang

standard disclaimer included.
From: exuptr@exu.ericsson.se (exuptr@exu.ericsson.se)
Newsgroups: comp.databases
Subject: Re: Paradox -- O Woe is Me!
Date: 10 Sep 92 23:12:20 GMT
Distribution: comp.databases
Organization: Ericsson Network Systems, Inc.

In article <5233@news.duke.edu> maria@acpub.duke.edu (Maria Spicer) writes:
>From: maria@acpub.duke.edu (Maria Spicer)
>Subject: Paradox -- O Woe is Me!
>Date: 10 Sep 92 21:39:58 GMT


>And so begins my Paradox nightmare...

>I accidentally copied an older version of my database over the
>newest version, while in DOS.  I had recently made some minor
>modifications to the structure (field width, etc.), so forms
>and reports had been changed slightly by Paradox as a result.
>Of course, in my diligent backing-up style, I also performed 
>this screw-up on my back-up copy:

>           HOW INCREDIBLY EFFICIENT OF ME!!!

>I can deal with the loss of a little data, but now, when I 
>attempt to access the forms and reports, I get a message that 
>they are "obselete" or "corrupt".  These were very nice forms
>that I had developed to perfection over the last two months;
>I cannot deal with the idea of having to recreate them from
>scratch. 

>If anyone knows of a way to trick the program into believing
>that the forms are okay, or has any other suggestions, 
>condolences, etc., PLEASE let me know...

>In advance, thanks,
>Maria

>-- 
>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>^   Maria Spicer, DP Specialist         maria@soc.duke.edu           ^
>^   140 Soc-Psych Bldg                  919-660-5602                 ^
>^   Duke University, Durham, NC         919-660-4317                 ^

I think your best bet is going to be re-modifying the table structure to
exactly match what you had before the goof.  

Assuming you don't remember exactly what that was (fair assumption, i 
think), you might try undeleting in your data directories, because paradox
makes a temporary table when you do restructures, and it might still be 
intact even though the "real table" is not.  Longshot, but worth a try.

Last but not least, call Borland tech support.  They may actually be able to 
help you recover the reports / forms.  I'm assuming you cannot edit them, 
either.

Good luck.
 ----------------------------------------------------------------------------
    "This must be Thursday.  I never could get the hang of Thursdays"
                                                       - Douglas Adams
  - Patrick Taylor                                       (Arthur Dent)
    Ericsson Network Systems
    exuptr@exu.ericsson.se                       "Don't let the .se fool you"
    or exuptr@ZGNews.Lonestar.Org, exu.exuptr@memo.ericsson.se
From: someday@milton.u.washington.edu (Scott Johnson)
Subject: Re: AREV 3.0
Organization: University of Washington, Seattle
Date: Fri, 11 Sep 1992 19:23:40 GMT

In article <15024@mindlink.bc.ca> Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg) writes:
>I'd be interested in other people's reactions to the AREV 3.0 release.
>The "coming out" presentation I attended made it appear more like an
>"AREV 2.6". The nature of the Lightspeed optimizations eluded the
>demonstration, I understand (had to leave early), which suggests that
>there are specific conditions under which you can expect phenomenal
>speed-ups, but that you have to aim for them.

Mainly INDEXED queries with complex ANDing and ORing clauses.

>Well, at least the mouse interface is now on a par with, say, the
>Borland IDE. Still can help feeling that the basic AREV architecture,
>which embeds so much in declarative form (windows, menus, popups
>and esp. file dictionaries) is crying out for 1-to-1 translation
>into native Windows objects --- if the objective of 3.0 is to
>make it more accessible to the first-time user, then surely it
>would make sense to jump directly to a native Windows app, with
>the Open Engine running the Mutant File Systems.
>
>Still can't figure what the literature means by the free-roaming
>mouse; it's not as if you can switch between stacked AREV processes
>with a mouseclick, is it?

"Free roaming" means the pointer moves around and can point and select things.
Compare to the horrendous mouse "support" in 2.x where mouse motion gets
translated into cursor keystrokes, transparently.  Yuck-o!

>Well, my two cents worth.
>--
>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.

-Scott Johnson
 not a spokesman for,
 but sitting at my desk at,
 Revelation Technologies, Inc.
Newsgroups: comp.databases
From: THOMASG@epx.cis.umn.edu (ThomasD.Gasser)
Subject: WATCOM SQL  (Opinions sought)
Organization: Department of Neurosurgery, University of Minnesota
Date: Tue, 8 Sep 1992 20:51:52 GMT

Ok every one,  I am looking for opinions on WATCOM's SQL database server for 
Novell.  The price seems right ($395for the developers version and $95 to 
upgrade to the 6 user network version).  I am a Dbase and Rbase programmer 
looking to get some experience with SQL.  We also my be considering using 
this as our campus standard (since you upgrade to an unlimited version for 
about $800.00.
From: Mehmet.Guerbuez@p16.f2002.n241.z2.fidonet.org (Mehmet Guerbuez)
Newsgroups: comp.databases
Subject: Re: XBASE Unix database
Date: 30 Aug 92 08:04:49 GMT
Article-I.D.: fast.715614364.F00003

To: jamesc@genghis.borland.com (James Chuang )
JC> How about the real thing? dBase IV version 1.1 is availables for:
JC> Sun Sparc
JC> Sun 3
JC> SCO Unix
JC> RS6000/AIX
JC> VAX/VMS
JC> MAC
JC> and MSDOS, of course.  The Latest DOS version is 1.5.
Hi James,
there is also a product called FLAGSHIP.
This produckt takes your Clipper surce code and compiles it on much more
unix platforms (i have seen a long list, if there is need i can type send
it here).
I think it converts your prog into a c programm and compiles it with cc.
As i heard about it, a support for nantucket tools II was also planned.
It is however too expensiv. (3000.- DM or more). But you can get an
evoluation copy for a month for about 250.- DM. With this copy you can test
all your applications without any restriction.
The firm MULTISOFT in M"unich is the distrubitor.

P.S.. I've read all this in an ad.

greetings Mehmet
Newsgroups: comp.databases
From: joser@gfimda.uucp (Joe Rodriguez)
Subject: Re: dBase to Ingres conversion
Date: Fri, 4 Sep 1992 22:40:27 GMT
Organization: Kraft General Foods

From article <Bu02Es.9Ew@rivm.nl>, by jwd@rivm.nl (Jan Diesel):
> I'm posting this for a colleague who expects to receive several
> dBase III+ tables on a regular basis in the near future. Each
> shipment consists of exactly one dBase III+ table.
> We need to convert the dBase data to Ingres so we're looking for
> software that creates and fills an Ingres table from the original
> dBase data.
> Does anyone know if something like this exists ?
> 

One thing you could do is to buy a dbase library in C source.  Write 
some embedded C code to read the dbase file, using the dbase libary, 
and fill the Ingres table.  There is a dbase libary called SoftC Database
Library.  It comes with C source, so you should be able to compile on VMS,
or UNIX with minimal changes.  I have not tried it yet.  I can tell you
more about it in the future.  I intend to do the same thing as you are
except in the other direction.  I have data in an INGRES table which I want
to fill into a dbase file.

+--------------------------+------------------------------------+
| Joe Rodriguez            |    ||   //    /====\    +=======   |
+--------------------------+    || //     ||         ||         |
| Kraft General Foods      |    |</       ||  ====   ||====     |
| General Foods-USA, IMD   |    || \\     ||    ||   ||         |
| Mailcode:  T12-1         |    ||   \\    \====/    ||         |
| 555 South Broadway       |------------------------------------+ 
| Tarrytown, NY  10591     | joser@gfceb   - ICES INGRES Host   |
| (914) 335-6059           | joser@gfimda  - IMD System         |
|                          | INTERNET/UUCP:  gfimda!joser@uunet |
| Pager: (212) 356-5116    |                 uunet!gfimda!joser |
+--------------------------+------------------------------------+
-- 
+--------------------------+------------------------------------+
| Joe Rodriguez            |    ||   //    /====\    +=======   |
+--------------------------+    || //     ||         ||         |
| Kraft General Foods      |    |</       ||  ====   ||====     |
From: aahz@netcom.com (Mean Green Dancing Machine)
Newsgroups: comp.databases
Subject: Re: Yet Another Simple (?) Question on Paradox
Date: 11 Sep 92 01:38:19 GMT
Organization: Bill 'n' Opus for Prez

In article <01GOMEBB5K9400066K@NAUVAX.UCC.NAU.EDU> DEVRIES@NAUVAX.UCC.NAU.EDU (Ernie DeVries) writes:
>Using CoEdit instead of Edit will allow you to open a blank record, but will not
>let you leave the record blank by moving off of it to another record.  This
>makes sense if you think of what Paradox does with blank records in Edit, it
>simply discards them when you Do_It!  I suppose CoEdit could have done the same
>thing, but since it writes each record to disk when you leave the record,
>Borland apparently decided not to let you post the record at all.

First, do be careful about historical referents to Paradox: the design
to which you refer has existed since version 2.0, when Ansa still owned
Paradox.

Second, as long as you're not talking about a keyed table, Paradox
allows you to have as many blank, *modified* records as you wish.
-- 
                         --- Aahz (the *other* Dan Bernstein)
                             @netcom.com 

Hugs and backrubs -- I break Rule 6

IRWTFM -- and that ain't fun
Newsgroups: comp.databases
From: dkirkpat@nyx.cs.du.edu (David Kirkpatrick)
Subject: database client dev. tools?
Organization: Nyx, Public Access Unix @ U. of Denver Math/CS dept.
Distribution: usa
Date: Tue, 15 Sep 92 16:04:24 GMT


Hello all,

Does anyone have information on toolkits for writing a DOS/Windows client
application that allow one to support a variety of database server vendors?
For example, I would like my client application to support Oracle, Informix, 
Sybase, etc... without writing my own layer of code to support them all.

The client application doesn't know at compile time what the database looks
like, so the toolkit would need to support dynamic SQL.

The toolkit shouldn't care whether the SQL server is running locally or on
a remote machine.  At some sites, the application might be configured to use a 
local database, and at other times access a remote database via the database
vendor's network products (Sybase NET-Library, Informix INET-PC, etc..)

Any information on this sort of development would be appreciated, whether it 
is info on toolkits, or experience rolling your own!

Thanks, David Kirkpatrick

dkirkpat@nyx.cs.du.edu								303-259-6161
72170.3566@compuserve.com
From: Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg)
Newsgroups: comp.databases
Subject: AREV 3.0
Date: 11 Sep 92 03:04:15 GMT
Organization: MIND LINK! - British Columbia, Canada
Distribution: world

I'd be interested in other people's reactions to the AREV 3.0 release.
The "coming out" presentation I attended made it appear more like an
"AREV 2.6". The nature of the Lightspeed optimizations eluded the
demonstration, I understand (had to leave early), which suggests that
there are specific conditions under which you can expect phenomenal
speed-ups, but that you have to aim for them.

Well, at least the mouse interface is now on a par with, say, the
Borland IDE. Still can help feeling that the basic AREV architecture,
which embeds so much in declarative form (windows, menus, popups
and esp. file dictionaries) is crying out for 1-to-1 translation
into native Windows objects --- if the objective of 3.0 is to
make it more accessible to the first-time user, then surely it
would make sense to jump directly to a native Windows app, with
the Open Engine running the Mutant File Systems.

Still can't figure what the literature means by the free-roaming
mouse; it's not as if you can switch between stacked AREV processes
with a mouseclick, is it?

Well, my two cents worth.
--
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