HDTenEightyP/NetNews huggingface dataset:
From: lapworth@mizar.usc.edu (Bill Lapworth)
Newsgroups: bit.listserv.dbase-l
Subject: AEval(), parameters & RTFM
Date: 23 Nov 1992 10:15:48 -0800
Organization: University of Southern California, Los Angeles, CA
NNTP-Posting-Host: mizar.usc.edu

In my Clipper book by Booth, Lief & Yellick, it clearly states that
aeval() automatically passes two parameters to the code block,
the first is the value of the array element being processed, and
the second is the number of the same element.  I have yet to be 
able to RTFM this in the docs from Nantucket.  Can anyone enlighten
me the a page number or location in norton guide database?

I suppose a related question is am I a fool for attempting to use
Nantucket documentation?  ( no, don't bother answering that one ... )

Thanks in advance.
* USC - The University of Spoiled Children  (I just work here)
Newsgroups: bit.listserv.dbase-l
From: eddie@wariat.org (Eddie Anthony)
Subject: dbase III question
Organization: Akademia Pana Kleksa, Public Access Uni* Site
Date: Mon, 23 Nov 1992 13:01:53 GMT

Is it possible for me to put a command in a dbase script that will check
for birthdays against the clock card in the computer so I don't have to
have to run a FIND routine when I want to check for birthdays? I would have
to index on birthday and search for them that way. I would like to have a
short routine in the startup to check the birthdate field against the clock
card when I start running a dbase file. 

Any ideas?

                      Eddie Anthony....eddie@wariat.org
-------------------------------------------------------------------------------
     And as Ben Franklin once said...."This is all positively shocking...."

Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 19 Nov 1992 09:26:31 PST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         VHASS%CAT700.gm@HAC2ARPA.HAC.COM
Subject: Re: Recognize Current Field Name

>     I will have to move to the next field, at least that's the impression
>I have been given, to store the data put into that particular field unless
>you tell me otherwise.
>
> Vishwa
>
>Here's a simple solution (if it gives you exactly what you want.....)
>in the GET postblock of the variable, place a keyboard up character.  This
>will put you back to the current field providing it is not the last field.

>Jeff

        Here's what I tried.  Created TEST.DBF with four fields Field_1
through Field_4.

        Created TEST.PRG as follows

        USE TEST
        ON KEY LABEL F10 DO Tellme
        EDIT

        PROCEDURE Tellme
                KEYBOARD CHR(13)  && Forces a carriage return so that I
                                     move to the next field
                KEYBOARD CHR(5)   && Forces an Uparrow to move back
                CurrentField = VARREAD()
                @ 15,5 SAY "Field Name = "
                @ 15,18 SAY CurrentField
                @ 17,5 SAY "Field Contents = "
                @ 17,18 SAY &CurrentField
        RETURN

        The above does not seem to work and I can't figure out why.  Any
suggestions ?

        Thanks

        Vishwa
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 20 Nov 1992 13:31:53 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Rich=Gautier%SETA%DRC@S1.DRC.COM
Subject:      RE- Indexing Problem

Someone said I could access FoxPro-type indeces.  What is the difference
between FoxPro indices, and Clipper indices?  What gain can I get from doing
that, and HOW can I access FoxPro indices with Clipper?

                                Rich
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 19 Nov 1992 10:06:45 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         jeff lewis <JLEWIS@INDYCMS.BITNET>
Subject: Re: Recognize Current Field Name
              18 Nov 1992 14:27:55 PST from <VHASS%CAT700.gm@HAC 2ARPA.HAC.COM>

On Wed, 18 Nov 1992 14:27:55 PST <VHASS%CAT700.gm@HAC2ARPA.HAC.COM> said:
>> dBASE IV (at least) provides the VARREAD() function for this very purpose.
>
>>  I tried using VAREAD() and it works fine as long as I move away from
>> the field after editing the contents of it.  I can't expect the user
>> to know that one has to edit the field move to the next field and then
>> press the PROGRAMMED ON KEY to do a comparison.
>
>> Why do you have to go to the next field?  The following works fine for me
>> (dBASE IV):
>
>> STORE SPACE(6) TO fielda, fieldb
>> ON KEY LABEL F2 DO whatfield
>> @ 10,10 GET fielda
>> @ 10,20 GET fieldb
>> READ
>> RETURN
>
>> PROCEDURE whatfield
>> ? VARREAD()
>> RETURN
>
>     I will have to go to the next field, at least that's the impression
>I have been given, to store the data put into that particular field unless
>you tell me otherwise.
>
>        Thanks
>
>        Vishwa

Here's a simple solution (if it gives you exactly what you want.....)
in the GET postblock of the variable, place a keyboard up character.  This
will put you back to the current field providing it is not the last field.

Jeff
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Thu, 19 Nov 1992 06:42:20 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Rich=Gautier%SETA%DRC@S1.DRC.COM
Subject:      re: dbase, foxbase, x-base clone source code?

Question 1: No.

Question 2: Of course we would LIKE the source to Clipper/Foxbase clone...

But where are we going to get it?

Rich Gautier
From: BURNFIELD@UTHSCSA.BITNET
Newsgroups: bit.listserv.dbase-l
Subject: Re: Recognize Current Field Name
Date: 16 Nov 92 15:07:00 GMT
              dialects" <DBASE-L@NMSUVM1.BITNET>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Original_To:  BITNET%"DBASE-L@TECMTYVM.BITNET"
Original_cc:  BURNFIELD

You should be able to put your comparison function in a VALID clause in the
GET statement that corresponds to the variables of interest. The function would
get called after the user entered data into the current get variable. You could
pass the needed data as arguments to the function similar to the following:

@ x,y GET var1 VALID checkdata(var1,var2,...)

The checkdata function would get called after the user terminated the data in
var1; which then gets passed to checkdata as an argument. You could then
return .T. or .F. depending on whether you wanted to remain in that get or
go on to the next one.

I've never used dBase IV; however, the above method works in Foxbase+ and
should be very similar to what you could do with dBase IV.

Dean Burnfield
The University of Texas Health Science Center at San Antonio
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: dbase-l@NMSUVM1.BITNET
X-VMS-To: IN%"dbase-l@nmsuvm1.bitnet"
Newsgroups: bit.listserv.dbase-l
Date:         Wed, 18 Nov 1992 21:37:00 CST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Chee-Ming CHEW <C034CCM@UTARLG.UTA.EDU>
Subject:      HELP ! Detect an incomplete SSN field input .

Hi all,

        This may be a simple and stupid question, but I can't figure out.

        I have a field define for social security number. I try to validate
        the field whenever a user key in a incomplete SS#, another word,
        it should prompt back the user to re-enter the SS# until it is
        valid.

        I did    SAY 'SSN : ' GET SSNUMBER PICTURE '999-99-9999'
        next, I guess it should follow by the VALID arguement, right ?
        If yes, what is it ?

        I'm new to database programming. I had look through some
        reference books and I can't find any example on validation for
        SSN field. This is way I assume that it is SO basic even does not
        mention in the book. ( OK, may be I just read some lousy books )

        Thanks in advance, any help will greatly appreciate.

C.M. CHEW
IN%"C034CCM@UTARLG.UTA.EDU"
The University of Texas at Arlington
Academic Computing Services
Newsgroups: bit.listserv.dbase-l
From: "tom frazer" <tom.frazer@canrem.com>
Subject: dbase info needed
Reply-To: "tom frazer" <tom.frazer@canrem.com>
Organization: Canada Remote Systems
Distribution: bit
Date: 16 Nov 92 02:32:46 EST

To: eddie@wariat.org

======\ Quoting: EDDIE ANTHONY \======\ On: 11/14/1992 \===========

EA> I am working on a project for a muffler shop where I want to set up a
EA> dbase for him where he can enter a year of car, and have the screen com
EA> up with options for Chevy, Ford, etc....
EA> 
EA> I was trying it with dBase III+ but the snag was that I have 16 fields 
EA> since that program will only list them (under the command LIST FOR YEAR
EA> left to right, they scroll onto 2 lines, as does the data in those fiel
EA> I need a program where I can recall those screens listed from top to bo
EA> Any suggestions would be appreciated.

======================================\ END QUOTE \======================
    dBASE IV 1.5 - with it you can create a non-destructive popup picklist
of the data in a field.
---
 . MegaMail 2.10 : Toronto Blue Jays 1992 World Series CHAMPIONS!
--
Canada Remote Systems  - Toronto, Ontario
World's Largest PCBOARD System - 416-629-7000/629-7044
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Organization: State University of New York - Central Administration
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 20 Nov 1992 07:53:10 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         EVERETT OGDEN <OGDENEB@SNYCENVM.BITNET>
Subject:      Re: Indexing Problem
              20 Nov 1992 07:03:26 EST from <Rich=Gautier%SETA%DRC@S1.DRC.COM>

I don't know of any way to look at a database in every possible
combination of index orders, other than to create all possible indexes.
But maybe that's not really what you're after.  If your goal is to
select records using criteria based on several fields in different
orders, then FoxPro 2.0's Rushmore and SQL SELECT should be able to
help.  There are lots of caveats, but if you follow the rules SELECT
will use available indexes to do its work.  When it's set up right it
can be *very* fast even on databases as large as yours.  SELECT works
best without any controlling index (SET ORDER TO 0); having to follow an
arbitrary index order just slows it down.  Rushmore's capabilities
aren't limited to the SELECT statement, but SELECT makes the best use of
them.

      Everett Ogden    ogdeneb@snycenvm.bitnet
From: DSMITH@INDYVAX.BITNET (DON SMITH)
Newsgroups: bit.listserv.dbase-l
Subject: Re: Recognize Current Field Name
Date: 18 Nov 92 21:29:46 GMT
              dialects" <DBASE-L@NMSUVM1.BITNET>
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: DBASE-L@NMSUVM1.BITNET
X-VMS-To: IN%"DBASE-L@NMSUVM1.BITNET"
X-VMS-Cc: DSMITH
MIME-version: 1.0
Content-type: TEXT/PLAIN; CHARSET=US-ASCII
Content-transfer-encoding: 7BIT

> dBASE IV (at least) provides the VARREAD() function for this very purpose.

>  I tried using VAREAD() and it works fine as long as I move away from
> the field after editing the contents of it.  I can't expect the user
> to know that one has to edit the field move to the next field and then
> press the PROGRAMMED ON KEY to do a comparison.

Why do you have to go to the next field?  The following works fine for me
(dBASE IV):

STORE SPACE(6) TO fielda, fieldb
ON KEY LABEL F2 DO whatfield
@ 10,10 GET fielda
@ 10,20 GET fieldb
READ
RETURN

PROCEDURE whatfield
? VARREAD()
RETURN

Don Smith
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.dbase-l
Date:         Fri, 20 Nov 1992 06:59:08 EST
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         Rich=Gautier%SETA%DRC@S1.DRC.COM
Subject:      Re: Recognize Current Field Name

The KEYBOARD() command will only STUFF the keyboard buffer.  Until you return
to a point that the program is waiting for input, the command will have no
effect whatsoever.
  The RETURN/UP-ARROW will sit in the keyboard buffer until program control is
returned to GetSys.

Someone mentioned using Get:buffer to look at it.  Why don't you try that out?

                                        Rich
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Original_To:  DBASE-L
Original_cc:  BURNFIELD
Newsgroups: bit.listserv.dbase-l
Date:         Mon, 23 Nov 1992 09:53:00 CDT
              dialects" <DBASE-L@NMSUVM1.BITNET>
From:         BURNFIELD@UTHSCSA.BITNET
Subject:      RE: Indexing Prohlem

One approach is to look at your possible seek variables and see if there
are any combinations that will come up more frequently than the others and
build your indexes to more efficiently handle those cases. If the search
criteria doesn't quite match your indexes then you may be able to use one
of them eliminate a good portion of the database and use a WHILE loop to
get at the rest of the records. For example, suppose you have an index
whose expression is SSN+DTOS(date) and the user wants to search by SSN
+ organization + whatever. You could eliminate a great portion of the
database by using the SSN+date index and soft seek on SSN. You could then:

DO WHILE SSN = srchssn
   if DB->org = srchorg and DB->Whatever = srchwhatever
      ... process this record
   endif
Enddo

This way you wouldn't have to plan for every combination; however, you may
be able to come up with some indexes that will contain at least one of the
search items the user is looking for most of the time. If you get real lucky
and 2 search fields match indexes you've set up, choose the one that will
eliminate the most records.

Another approach that you might consider is to index the database on the
fly, based on the search criteria that the user entered and delete that
file after it's no longer needed. The time you lose indexing might be made
up when you seek. You'll probably want to do some time trials to see
if this approach improves speed over what you're already doing.

Hope this is of some use ...

Dean Burnfield
The University of Texas Health Science Center at San Antonio
Internet address: burnfield@uthscsa.edu
Bitnet address:   burnfield@uthscsa
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Fri, 20 Nov 1992 16:46:34 EST
From:         Patrick=Smoker%Admin%Ag@ADMIN.AGAD.PURDUE.EDU
Subject:      re: Printing Solutions?

>Can one REALLY send postscript jobs to a laserwriter (macintosh) printer
>from a PC??  This would certainly be a great time/money saver for us.  If
>an Appleshare file server and attendant print spooler is running in the
>Mac side of the house, will Banyan jobs just spool to Printserver like
>any other Mac job? Hmmmmmm

John:

Yes you can send postscript jobs to a laserwriter from Banyan Vines
5.0(x).  You can setup the PAP que to look like a normal VINES print
service from DOS and still have it show up as it normally does in you MAC
chooser.  You may optionally remove the "real" appletalk name so that only
the que shows up on both the DOS and Apple side.

*******************************************************************
* Patrick Smoker              E-Mail:   pds@admin.agad.purdue.edu *
* MIS Manager                 Phone:    (317)494-9330             *
* Ag. Administration          FAX:      (317)496-1104             *
* Purdue University                                               *
*******************************************************************
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Return-path: Gerald=Langiewicz%Staff%SS-GradLab@phobia.ss.uci.edu
Newsgroups: bit.listserv.banyan-l
Date:         Wed, 18 Nov 1992 08:11:19 PST
From:         Gerald=Langiewicz%Staff%SS-GradLab@PHOBIA.SS.UCI.EDU
Subject:      Mac Software

I need to know the latest versions of the MAC Client Software.  Curently we
are using VINES Network 1.2.1, VINES Mail 1.2 and VINES Utils 1.2.  So far my
VAR has of little help.

gerald

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ Gerald Langiewicz                 ~  VINES:      glang@staff@ss-gradlab  ~
~ University of California, Irvine  ~  Internet:   GWLangie@uci.edu        ~
~ School of Social Sciences         ~  AT&T:       (714) 856-5404          ~
~ Irvine, CA 92717                  ~                                      ~
~                                   ~                                      ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: BANYAN-L@VM1.CC.UAKRON.EDU
Content-transfer-encoding: 7BIT
Newsgroups: bit.listserv.banyan-l
Date:         Thu, 19 Nov 1992 09:51:27 +0100
From:         SCHUTGENS@VSNU.NL
Subject:      ERROR 198

I,m afraid I bumped into  unknown error.
If I manage my communications from the console, and I try to connect a
remote site, I get the following message:
ERROR: Call Failed - 198, Connection not made.

One problem is that I can't connect to a remote server which used to be no
problem. Another problem is that error 198 is not documented, neither on
paper nor in VNSERR.

About the first problem I'd like to add that both the server I try to
connect(A) and my server(B) have a connection with a another server(C) we
both can see and communicate with. So at this moment if I want to send a
mail from (A) -to-> (B) I goes via (C). I run Vines 4.11(5) and already
applied some patches ( EL-1  BW-1 )



Guus Schutgens, VSNU
Schutgens@vsnu.nl



Since catchphrase are hip
----------------------------------------
H.D. is a dog's disease, Guzzi is a Bike
----------------------------------------
not relevant at all, but true
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Fri, 20 Nov 1992 11:10:28 PST
From:         John=Hanna%ComputerSvcs%OCC@BANYAN.CCCD.EDU
Subject:      re: Mac Software

RE: Mac software for Vines.

Does anyone know if Banyan uses Apple's TCP/IP drivers, or did they write
their own?

Apple just announced a price increase on Mac TCP....

Hmmmmmm

------------------------------------------------------------
John P. Hanna                           Orange Coast College
Microcomputer support specialist           Costa Mesa, Calif
                                      Voice     714-432-5500
  "Moof"                              Fax       714-432-5018
'Everything in moderation, including moderation'
------------------------------------------------------------
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Mon, 23 Nov 1992 21:27:04 EST
From:         John=Valenti%cs%SSC@BANYAN.CL.MSU.EDU
Subject:      re: 4.11 on a PS2/95

Keith Lally writes:

> I am trying to install 4.11(0) on a brand new ps2/95 with two SCSI disks.
> After booting from the install/utility disk and selecting the option to
> prepare all disk space for vines I see the following warnings:
>
> WARNING:  HD warning:  reading drive 0
> ... etc ...

You might want to look at the file novtqa.zip from csus.edu. At about line
447 there is an comment about these messages. Basically, the hard disk on the
95 has an extra sector that Vines ignores (but produces an error message
about). It should be harmless.

I think this might be specific to certain models of the PS/2 95, since I've
been running one for a year and don't recall seeing the message.

Oh, I would recommend going to 4.11(5) ASAP. Maybe 4.11(0) is OK, but my 95
would reboot if loaded heavily under 4.10(5) (for instance, running Norton's
SI against a network drive from 4 stations at once). The problem disappeared
when I upgraded to 5.0(5).

-jav     John Valenti    valenti@msu.edu    Michigan State University
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: Banyan-l@akronvm.BITNET
Content-transfer-encoding: 7BIT
Newsgroups: bit.listserv.banyan-l
Date:         Mon, 16 Nov 1992 10:44:04 +0100
From:         Hendrik.Klompmaker@BEHEER.ZOD.WAU.NL
Subject:      RPL support.

Hi,

I've been spending the last Fryday afternoon playing around with RPL just to
find out that I did NOT RTFM good enough :-(.
I seems that RPL is only supported on a few cards and I thougt the 3c503 was
one of them but as I found out only in the server :-(.
Does anyone out there have experiance with RPL with other then the cards
mentioned in the VINES RPL Service Guide for 4.11. We run 4.11(5). I tried a
3c503 client with a Lan Manager bootprom (that supports RPL !) to connect to a
Server with a NE3200. As the Manual states it indeed does not work.
What I would like to know is if the support will be expanded in future and to
what NIC's for both client en server. Also I would like to know if there are
(like the backup units discussed over and over) unsuported (working) options
available.

Bye

Hendrik.

PS. RPL = Remote Program Load. It allows diskless clients to boot on a server
          disk.

===============================================================================
|******** Wageningen Agricultural University. Animal Production Group ********|
-------------------------------------------------------------------------------
Hendrik Klompmaker              Internet : Hendrik.Klompmaker@Beheer.Zod.Wau.Nl
System Manager                  Bitnet   : KLOMPMAKER@HWALHW50.BITNET
Phone : +31 (0)8370-83934       Fax      : +31 (0)8370-83962
Snail : Marijkeweg 40, 6709 PG  WAGENINGEN, The Netherlands
===============================================================================
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.banyan-l
Date:         Wed, 18 Nov 1992 22:25:41 EST
From:         John=Valenti%cs%SSC@BANYAN.CL.MSU.EDU
Subject:      re: Mac Software

> The current version that is released from Banyan, as far as we are aware is
> 1.2.  I am pretty sure that there is a newer version that is being worked on
> 1.3, but doesn't seem to be released.

Our VAR (Syntrex) sent me a copy of 1.3B6. I don't think the B stands for
beta. I think it fixed about 5 bugs, there was a file included from someone
at Banyan that encouraged everyone to upgrade.

We hoped that this version would make mail work on Powerbook 145 (w/ Asante
ENSC interface), but it didn't help. File sharing works fine on the PB145,
but mail starts running and then terminates (as do the Vines utilities). Any
ideas?

-jav     John Valenti    valenti@msu.edu    Michigan State University
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: Banyan-l@akronvm.BITNET
Content-transfer-encoding: 7BIT
Newsgroups: bit.listserv.banyan-l
Date:         Thu, 19 Nov 1992 09:46:51 +0100
From:         Hendrik.Klompmaker@BEHEER.ZOD.WAU.NL
Subject:      New 3c509 packet driver

Hi,

John J I hope you read this as well because I didn't send you a direct
message.

I uploaded a new packet driver (3c509d.zip) for the 3c509 to
 /pub/banyan/incoming.

I tried it and it works ok now BUT !!!
on fast machines (486 etc)  it's very critical about bus speed and Ram wait
states. I couldn't get it to work with higher then 11 Mhz bus speed and/or
less the 2 wait states ( no correct Ethernet address found or Banyan will tell
that the network is down).
About speed. Well I got the same results as the NDIS driver which was fast
allready.
For impatient guys (who cannot wait for John to move the driver) the driver
is available on cheetah.ece.clarkson.edu
Comments as allways to Russel Nelson <nelson@crynwr.com> or
comp.protocols.tcp-ip.ibmpc on Usenet news.

Have fun

Hendrik

===============================================================================
|******** Wageningen Agricultural University. Animal Production Group ********|
-------------------------------------------------------------------------------
Hendrik Klompmaker              Internet : Hendrik.Klompmaker@Beheer.Zod.Wau.Nl
System Manager                  Bitnet   : KLOMPMAKER@HWALHW50.BITNET
Phone : +31 (0)8370-83934       Fax      : +31 (0)8370-83962
Snail : Marijkeweg 40, 6709 PG  WAGENINGEN, The Netherlands
===============================================================================
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU