HDTenEightyP/NetNews huggingface dataset:
From: charlesa@niwot.scd.ucar.edu (Charles Albrecht)
Subject: Re: Another FileMaker Pro question
Keywords: FMPro, Calc Fields, If(,,)
Organization: Scientific Computing Divison/NCAR Boulder, CO
Date: Fri, 14 Aug 1992 14:58:15 GMT

In article <1992Aug14.090939.14131@nntp.uoregon.edu> srussell@cie.uoregon.edu (Steven Russell) writes:
>
>Ok, here's another question:  I want to be able to create a field
>that adds values from two other fields.  If field "A" contains the
>value 20, and field "B" contains 17, I want my proposed field to
>become 37.  So far, this is trivial, but I would like this same field
>to be selectable for manual data entry if both fields "A" and "B" are
>undefined.  If this is not possible, I will settle for having the
>field be selectable for data entry without depending on the values in
>fields "A" and "B".  Is this possible, or am I asking too much?  I've
>looked through the manual for help with this, but haven't found a way
>to make it work.
>
>--
>-Steven Russell
>srussell@uoneuro.uoregon.edu
>

How about this:  create a field "C" that has the data you'll put into your
calculation field if "A" and "B" are empty.  Then define your CalcField
with:

CalcField = if ((A = "") and (B = ""),C,A+B)

I've done something similar in a database here.  I then make C a non-printing
object in the layout definition, so that only the CalcField is printed.


Charles

----
Charles Albrecht                "Nonsense, they only say you can't survive
charlesa@ncar.ucar.edu           The Fire Swamp because no one ever has."
303/497-1828                        - Westley, The Dread Pirate Roberts

NCAR - Scientific Computing Division * P.O. Box 3000 * Boulder, Colorado  80307

The opinions you are about to have read are fictitious...
          ...any similarity to opinions living or dead is purely coincidental.
Newsgroups: comp.sys.mac.databases
From: pejacoby@mmm.serc.3m.com (Paul E. Jacoby)
Subject: Hiding empty DATE fields in 4D?
Organization: 3M Company
Date: Tue, 18 Aug 92 14:03:27 GMT

(I'll post this here too for wider distribution)

Does anyone have a good way to 'hide' empty DATE fields when printing a
layout?  I have a number of date fields in a layout, any number of which
may not yet have data entered in them.  4D is happy to provide
"00/00/00" as a default value, but I don't want this value to show in
the printout!

I have played with SET COLOR( ) with no success at this point. This code
_doesn't_ work:

  If (Before & isprinting)
     If ([traveler]datein=!00/00/00!) ` date is blank
        SET COLOR(datein;0)  ` hide blank date fields
     End if 
  End if

Aside from not working, this approach is _slow_ as the Before phase
executes for EVERY record being printed.  Yuck.

* If I have to, I'll make the fields ALPHA instead of date, but I'd
  prefer to NOT make this change.
-- 
| Paul E. Jacoby, Consultant  | pejacoby@mmm.com      CIS:70404,2507 |
| David Mitchell & Associates |                                      |
| 3M Center, Bldg 235-3F-27   |--------------------------------------|
| Maplewood, MN   55144-1000  | (612) 737-3211 [w]      731-6392 [h] |
From: Mark.Tucker@f421.n109.z1.fidonet.org (Mark Tucker)
Sender: Uucp@blkcat.UUCP
Newsgroups: comp.sys.mac.databases
Subject: Re: PANORAMA II CRASHES
Date: Thu, 13 Aug 1992 12:59:54 -0500

 > Hello.  I have been running Panorama II 2.0.6 rather successfully up
 > until recently.  Whenever I try to enter data or do just about 
 > anything,
 > Panorama crashes with a system error, us. "Ilegal Instruction", but
 > sometimes "bus error".  I have a Mac II with 32 bit memory 
 > addressing
 > turned off, System 7 Tuner 1.1.1 and 8 MB of RAM.  I have tried 
 > turning
 > off all my extensions, but it still crashes, and I tried other files
 > and they worked fine.  Halp!  Thanks.

Did you try replacing the application?
From: geoffb@coos.dartmouth.edu (Geoff Bronner)
Newsgroups: comp.sys.mac.databases
Subject: Re: Another FileMaker Pro question
Date: 15 Aug 92 21:34:59 GMT
Reply-To: geoffb@Dartmouth.EDU
Organization: Amos Tuck School

In <1992Aug14.090939.14131@nntp.uoregon.edu> srussell@cie.uoregon.edu (Steven Russell) writes:

>Ok, here's another question:  I want to be able to create a field
>that adds values from two other fields.  If field "A" contains the
>value 20, and field "B" contains 17, I want my proposed field to
>become 37.  So far, this is trivial, but I would like this same field
>to be selectable for manual data entry if both fields "A" and "B" are
>undefined.  If this is not possible, I will settle for having the
>field be selectable for data entry without depending on the values in
>fields "A" and "B".  Is this possible, or am I asking too much?  I've
>looked through the manual for help with this, but haven't found a way
>to make it work.

The only way you could do this would be to define your proposed field as a
calculation field, let the calculation run, and thenb redefine it as a
number field. But you would have to re-run the calculation on an irregular
basis.

-Geoff
--
geoffb@Dartmouth.EDU - Computing Support Consultant, Tuck School of Business
_____________________________________________________________________________
 Cerebus for Dictator in 1992!!    |    He doesn't love you, he just wants
     "Vote for me or else."        |           all of of your money.
Newsgroups: comp.sys.mac.databases
From: ham@aifbmozart.aifb.uni-karlsruhe.de (Harald Mueller)
Subject: Looking for 4D-externals
Keywords: 4D, external
Organization: AIFB, University of Karlsruhe (Baden / Germany)
Date: Fri, 21 Aug 1992 11:25:39 GMT

I am looking for 4D-externals. At ftp.scri.fsu.edu [192.70.169.254], I found some very fine
ones, but they are rather old. Do you know any FTP-Sites where I can get more?

I am especialy interrested in the NiceChoice.ext. 

Harald Mueller
(ham@aifb.uni-karlsruhe.de)
Newsgroups: comp.sys.mac.databases
From: mward@netcom.com (Michael Ward)
Subject: Re: Problem with Reflex Plus for Mac
Date: Sat, 22 Aug 92 00:26:40 GMT
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Distribution: na

jgeniec@cis.ohio-state.edu (Joseph Geniec) writes:


>	I have a small problem with Reflex Plus. I am trying to convert
>a Database to text format so I can upload it to UNIX. Seems simple,
>doesn't it? Anyway, It will not allow the DB to text conversion for
>some reason. Here is everything I did-

>loaded Database
>selected file|new
>selected table report and gave the report a name
>picked the corresponding Database from the Hard Drive
>hit "include all" button to select all fields
>hit "include all" button to select all fiels for record selection
>selected "export data"
>clicked on text format

>now-- here's the problem. There should be a list of all of the fields on
>the left list, but it is completely empty. Why isn't reflex listing all
>of the fields from the database? BTW, I'm new with this database stuff,
>so If it's simple, go easy on me.

You cannot export a table report (or any report, for that matter) 
in Reflex Plus.  The only thing you can export is a fairly simple set
of collected fields (the exact terminology escapes me at the moment - 
it's been a few months since I last used Reflex).  I have always
loved Reflex (in a love/hate sort of way), but it was easily the
most difficult DBMS for me to learn.  The only way I found to export
data to a file was to format it in a text string using special characters
to indicate tabs and the like, then use SuperGlue to capture the
printout.  This is not an easy thing to learn to do.

Reflex is diffcult to learn and is NOT supported by Borland.  I would
suggest that you consider using another DBMS to perform your task.
I find Omnis to be the best database system I've ever used, but it
is pretty expensive.

Michael Ward
mward@netcom.com
From: peirce@outpost.SF-Bay.org (Michael Peirce)
Newsgroups: comp.sys.mac.databases
Subject: Re: What database program should I buy?
Date: 18 Aug 92 17:49:21 GMT
Reply-To: peirce@outpost.SF-Bay.org (Michael Peirce)
Organization: Peirce Software
X-Mailer: uAccess - Macintosh Release: 1.5v4


In article <17AUG199216404126@deimos.ucc.umass.edu> (comp.sys.mac.databases), s0671922@deimos.ucc.umass.edu (D. BESONEN) writes:
> 
> Hello,
> 
> I am about to purchase a database program for a lab that will
> consist of Macintosh and PC computers.  I've already decided
> on FoxPro for the PCs and am leaning in the same direction
> for the Macs, figuring that it will be much easier to support
> one program rather than two.
> 
> Does anyone recommend a different database program?  If so,
> why?

At least checkout FileMaker Pro.  It's will be out shortly and support
both Macintosh and Windows.

--  Michael Peirce      --   peirce@outpost.SF-Bay.org
--  Peirce Software     --   Suite 301, 719 Hibiscus Place
--                      --   San Jose, California USA 95117
--  Makers of...        --   voice: (408) 244-6554 fax: (408) 244-6882
--            SMOOTHIE  --   AppleLink: peirce & America Online: AFC Peirce
Newsgroups: comp.sys.mac.databases
From: srussell@cie.uoregon.edu (Steven Russell)
Subject: Calculating "days" in FileMaker Pro
Organization: University of Oregon Campus Information Exchange
Date: Thu, 13 Aug 92 18:08:42 GMT

I am trying to create a calculated field in FileMaker Pro that will
return the number of days since a date located in another field.  For
example, if today is the 13th of August, I want to know how many days
have passed since (for example) June 27th, 1991.  Is there a simple
way to do this?  The calculation functions don't seem to lend
themselves well to this task, but I may not be using them properly. 
Can anyone help me out with this?

--
-Steven Russell
srussell@uoneuro.uoregon.edu
From: Mark.Tucker@f421.n109.z1.fidonet.org (Mark Tucker)
Sender: Uucp@blkcat.UUCP
Newsgroups: comp.sys.mac.databases
Subject: Re: ANY SUGGESTIONS FOR SETTING UP FILE
Date: Thu, 13 Aug 1992 12:57:19 -0500

 > Be VERY Careful of setting up a FM Pro database across a network.
 > Small abberations in your network can cause catasrophic data losses.
 > Claris' suggestion is to have a dedicated server for FM Pro [sic]. I 
 > don't
 > know about you, but we didn't want to shell out for a Mac *just* for
 > FM Pro.  In my experience, and I am only one datapoint, FM Pro is
 > NOT very stable over a shared network, especially if multiple users
 > are sharing the file simultaneously.
 > 
 > Just my $0.02 worth.
 > -- 

We currently have FileMaker Pro running on our EtherNet with no porblems.  There
are always at least 3 users connected, and up to as many as 8.  We have never
expeirenced any data loss or corruption.  One thing to keep in mind is that
whoever opens the file first becomes the host and can not quit out of the file
until all of the guests have.  To solve this problem we have the file open in
the background on our server under system 7 all of the time.  This way the
server is always the host.
From: pricec@prism.CS.ORST.EDU (price carl wayne)
Newsgroups: comp.sys.mac.databases
Subject: 4D problem
Date: 14 Aug 92 21:49:12 GMT
Organization: Oregon State University, Computer Science Dept.

I'm having a problem with 4D that I thought someone might have already solved.
I want to print labels sorted by zip code, but the problem is the mailing 
address can come from one of two files.  The only way I've been able to 
think of to do this would be with an array, but this tends to be very 
memory intensive for a large mailing list.  Has anyone done this?
If more info is needed (ie I'm not stating my problem clearly) mail me
and I'll provide more info.


On another note, I've finished writing a procedure to properly produce the
ABC zip-code with framing bars so that USPS barcodes can be printed using
the USPS barcode font available from Sumex (I haven't sent these through the
post office yet, so I can't say if the font works on the Post Offices barcode
readers, but the numbers come out according to the post office Regulations.)
If you want the code so you can adapt it to your database, e-mail me and I'll
either mail you a copy, or if there is enough intrest I will post it.
   Note:  This code is not as clean as I would have liked, there are some
   things that could have been done more elagently in another language, but
   I couldn't find the commands in the 4D language.  It does work however, 
   so It is a good point to start on your own.  You will have to adapt it 
   for you application since it is written specificly for my app.

--Carl

-- 
Carl W. Price		 	*      * Work keeps us from three evils:     * 
Computer Engineering Student	*      * boredom, vice, and need.            *
Oregon State University		*      *                                     *
pricec@prism.cs.orst.edu	*      *       ---Voltaire                   *
Newsgroups: comp.sys.mac.databases
From: sjb@theory.TC.Cornell.EDU (Stephen J. Bradshaw)
Subject: Filemaker & Mailmerge
Organization: Cornell Theory Center
Date: Mon, 17 Aug 1992 15:25:21 GMT

I am interested in using Filemaker Pro to handle a database of names
and addresses. Could someone indicate if the current or future versions
of Filemaker can be used in conjunction with a * SEPARATE * word
processing package for mail merges. I appreciate that it is possible to
compose letters from within Filemaker but I am more interested in using
a dedicated word processor. Has anyone had any success with any specific
word processors ?

Thanks in advance 

Steve Bradshaw,
sjb@theory.tn.cornell.edu


Newsgroups: comp.sys.mac.databases
From: martind@acf9.nyu.edu (David Martin)
Subject: Dbase IV -> FoxBase+
Organization: New York University
Date: Tue, 18 Aug 1992 15:14:30 GMT

I have heard that FoxBase is compatible with DBase III+.  How compatible
is it with DBase IV?  I have some DBase IV programs that make extensive
use of pull-down menus, pop-up menus and lists.  Will FoxBase properly
translate these programs?


David Martin
martind@cims.nyu.edu
martind@acf9.nyu.edu
Newsgroups: comp.sys.mac.databases
From: s0671922@deimos.ucc.umass.edu (D. BESONEN)
Subject: What database program should I buy?
News-Software: VAX/VMS VNEWS 1.41    
Organization: University of Massachusetts, Amherst
Date: Mon, 17 Aug 1992 20:40:00 GMT


Hello,

I am about to purchase a database program for a lab that will
consist of Macintosh and PC computers.  I've already decided
on FoxPro for the PCs and am leaning in the same direction
for the Macs, figuring that it will be much easier to support
one program rather than two.

Does anyone recommend a different database program?  If so,
why?


Thanks,

David Besonen
s0671922@deimos.ucc.umass.edu
From: thingles@xerxes.cs.umn.edu (Jamie Thingelstad)
Newsgroups: comp.sys.mac.databases
Subject: Re: Any suggestions for setting up Filemaker Pro?
Date: 15 Aug 92 19:20:08 GMT
Followup-To: thingles@xerxes.cs.umn.edu
Organization: University of Minnesota, Minneapolis, CSci dept.


On our network we have a dedicated File Server (of course) and a dedicated
Mac IIci running FileMaker Pro (1.0v3, eagerly waiting for 2.0). We have had
_extremely_ good experience with this configuration. The question I have
is, anybody using this type of configuration, the machine has 5 MB of RAM.
What is the best way to allocate this. Currently I have a 768k RAM cache set
up, and am giving FM Pro upwards of 3 MB. It is sharing 7 databases on the
network. Is there a better way to configure this memory? for optimum
performance of course.

Thanx

--
+------------------------------------------------------------------------------+
|  Jamie Thingelstad                 | Ronald Reagan: A Triumph of the         |
|  thingles@alexander.cs.umn.edu     |                         embalmer's art. |
+------------------------------------------------------------------------------+
From: u437737@sparc17.ncu.edu.tw (im)
Newsgroups: comp.sys.mac.databases
Subject: Help ! oracle access : commit *close* all context area ?
Date: 20 Aug 92 08:29:02 GMT
Organization: National Central University


	currently I am developing an application of 4d with oracle,
I realize if I can allocate several context area, then I can
program more easily. But the oracle access manual really confuses me,
	this is what it said : (p.A-5)
	All open context areas are *closed* prior to COMMITing the work

	but the fact is I can use the same context area after commit,
this bother me because if I depend on it ( I might depend on it a lot ) 
then it may be incompatible with future version ( since it does not
conform to what document said .) It also maybe possible I mistake
the *close* action, does it mean deallocate ? what happens if
I use it after commit, does it has some side effect ?
	
	I will appreciate any reply.
  ________ 
  \      /                               Reply to: steve@im.mgt.ncu.edu.tw
___\ MGT.NCU.EDU.TW __________________________________________________________
    \  /                                         
     \/   /   |)    ------       --		Steve Chiu
	 /+-+ |)     +-+ |     ------
	  | | |      +-+ |      \  /		EMail: steve@im.mgt.ncu.edu.tw
	 -+-+-|         _|     ------		Phone: 886-03-426-7288
	Department of Information Management,  
	National Central University, Chungli, Taiwan, R.O.C.
______________________________________________________________________________
Newsgroups: comp.sys.mac.databases
From: eah0065@zeus.tamu.edu (HASKIN, EDWARD ARTHUR)
Subject: Filemaker Pro w/ MacWrite II
News-Software: VAX/VMS VNEWS 1.41    
Organization: Texas A&M University, Academic Computing Services
Date: Tue, 18 Aug 1992 15:07:00 GMT

Has any one had experience with merging information with filemaker Pro and 
MacWrite II??


Newsgroups: comp.sys.mac.databases
From: dent@DIALix.oz.au (Andrew Dent)
Subject: Re: 4D problem
Organization: DIALix Services, Perth, Western Australia
Date: Mon, 17 Aug 92 12:14:14 GMT


To create an "on-the-fly" link to two or more different databases,
the most elegant solution I know of is based on the use of pointers
and arrays.

Note, the following is being typed in from memory so minor syntax errors
may creep in...

Firstly, let's assume you have files [zip] and [addr1] or [addr2] used
as source for addresses, each with fields for Name, Address, City & Zip
(they DO NOT have to have the same names or be in the same position for
this technique to work)

Note: I'm going to use >> to indicate the 4D pointer (option-\) char.
                                               
Define an array to point to the relevant fields
ARRAY POINTER (addrFlds; 2; 4)
addrFlds{1}{1} = >>[addr1]Name
addrFlds{1}{2} = >>[addr1]Address

and so on...
addrFlds{2}{4} := >>[addr2]Zip


our [Zip] database has an integer field used to indicate which address
file is relevant (ie: it always contains 1 or 2).

To reference a given address, simply use
addrFlds{[Zip]whichAddr}{1}>>       
addrFlds{[Zip]whichAddr}{2}>>       
addrFlds{[Zip]whichAddr}{3}>>       
addrFlds{[Zip]whichAddr}{4}>>       

This technique has lots of other applications - I've just finished a 
system for converting ArchiCad output files to a jobcosting file, which
is totally user-defined. They can define "factors" that describe how to
extract data, ask the user or perform a calculation. Using the above      
technique I have one master [Factors] file and a number of "variant"
files. This is very much like object-oriented programming in that you
can add new Factor types without changing a bit of existing code!

If anyone's interested in more detail, I'll post again, enough dribbling
for now!

Andy Dent (A.D. Software - Mac & VAX programming)
94 Bermuda Dve, BALLAJURA  Western Australia  6066
Phone/Fax: 09 249 2719 (local)  +619 249 2719 (International)
       Internet: dent@DIALix.oz.au    Compuserve: 100033,3241

Newsgroups: comp.sys.novell
From: kreidler@convex.rz.uni-duesseldorf.de (Homer Simpson)
Subject: network failure
Organization: Heinrich-Heine-Universitaet Duesseldorf
Date: Fri, 14 Aug 1992 16:13:41 GMT

Hi you gurus outside!

There is a problem with our Novell 3.11 installation. When copying files
from a local disk to a network drive with ncopy the server hangs with
the unpleasant message : General Protection Processor Exception(Error Code
00020000). The same message with Code No. 00000000 appears each time
we close the server with DOWN. Any idea of the cause???

Kay Kreidler,
Dept. of Inorganic Chemistry
Heinrich-Heine-University Duesseldorf
Germany

Newsgroups: comp.sys.novell
From: nachtman@fh-ulm.de (RZ Peter Nachtmann)
Subject: Re: HELP: RPRINTER wo'nt work
Organization: Fachhochschule Ulm, Germany
Date: Tue, 18 Aug 1992 10:49:38 GMT

In article <1992Aug17.134606.7108@menudo.uh.edu> mylai@cs.uh.edu (Ming-Yung Lai) writes:
>From: mylai@cs.uh.edu (Ming-Yung Lai)
>Subject: HELP: RPRINTER wo'nt work
>Date: 17 Aug 92 13:46:06 GMT


> Hi, I have been tried to make RPRINTER to work for about 2 weeks, but...
> Let me describe the configuration of my system first:
>  One print server with two queues, one queue setup with the server, this
>  works OK, the second queue used in the remote workstation, every time
>  when I print something to the remote printer, the document did get into
>  the second queue, but it takes about 10 minutes to print ONE LINE.
> What went wrong, I used PCONSOLE to setup everything as the manual described,
> But why it take so long to print just one line? Is there something I missed.
> If someone can help me out of this, I'll be much appreciated.

Hi,
I had the same problem. my remote printer was connected to a slow 8088 PC.
The server responses came too fast for the slow machine, doing lots of
retries ...
- Peter -

      |  Peter Nachtmann     |  Mail:  nachtmann@fH-ulm.de  |
      |  Fachhochschule Ulm  |                              |
      |  Postfach 3860       |  Phone: 0731/502-8198        |
      |  7900 Ulm / Germany  |  Fax:           -8270        |
From: vandenhu5655@iscsvax.uni.edu
Newsgroups: comp.sys.novell
Subject: Remote Printer Problems
Date: 19 Aug 92 09:31:11 -0500
Organization: University of Northern Iowa



I am having some major problems with a remote printer.  I am using
Novell 3.11 and have the print queues set up.  The information I send
to the printer gets there and everything is printed, but then the machine
that I am using that is actually hooked up to the printer hangs.
I think I'm doing everything correctly since the information is making it
to the printer but why does my machine hang every time?

Any solutions?

Thanks...

- Todd
vandenhu5655@iscsvax.uni.edu

Newsgroups: comp.sys.novell
From: weber@rhrk.uni-kl.de (Christoph Weber-Fahr [KIT])
Subject: Re: problems with system login script
Keywords: help, system login script
Organization: University of Kaiserslautern, Germany
Date: Fri, 14 Aug 1992 16:57:37 GMT

Hello,

kreidler@convex.rz.uni-duesseldorf.de (Homer Simpson) writes:
May I assume that you are not Homer Simpson, may I ? :-)

>I have a big problem with our new NetWare 3.11 installation.
>After configuring the server and two clients i made a horrible mistake
>editing the system login script, that caused NetWare to hang, when you
>try to login from a client. Even as supervisor you cannot reach the
>server (he also has this script). Is there a way of editing or erasing
>this damned file from the server????

>I have no idea what to do and noone i asked yet, can help me!!

>Any idea from the gurus outside??

Hm...I leave it to your imagination to call me guru or not :-)

You have several ways to solve that problem:

- Use LOGIN /S<another script here> . This will execute another script file
  instead of your system script.
- Get attach.exe friom one of the utilities disk. The attach to your 
  file-server as supervisor. Also get map.exe the same way, because
  you have to do all the mapping by hand. You can do that easier, if you 
  are already logged in to another fileserver on your network, because you
  don't need to search for all these utilities.

Maybe I forgot some ways...

BTW - have a look at the faq for this group and also that of 
bit.listserv.novell. Your question is at least in the bitnet faq.

Regards

Christoph Weber-Fahr

-- 
  Christoph Weber-Fahr                  |  E-Mail:  weber@rhrk.uni-kl.de 
  Universitaet Kaiserslautern,  KIT     |  S-Mail:  Postfach 3049
  Tel. 0631/205-3391                    |           D-6750 Kaiserslautern
--------------------------  My personal opinion only    ---------------------
Newsgroups: comp.sys.novell