HDTenEightyP/NetNews huggingface dataset:
Newsgroups: comp.sys.mac.databases
Distribution: world
From: Scott_W._Fisher@bmug.org
Organization: BMUG, Inc.
Date: Tue, 15 Dec 1992 22:14:26 PST
Subject: Foxbase+/hypercard

Is there a way that I can use foxbase as my database and have hypercard act as
a window for it? That is data would be entered into text fields in a hypercard
stack which would update the database automatically. The database could then
be the source of information for the hypercard stack.My wish is to then use
the stack on a network of computers and then have access to the central
foxbase database. This would get around the fact that hypercard on a network
can be used by only one person at a time.
***************************************************************************
             From Planet BMUG, the FirstClass BBS of BMUG, Inc.
              The above message was gatewayed via PostalUnion
***************************************************************************
The message contained in this posting is entirely the poster's personal
opinion.  Any possible, real or perceived, (dis)similarities with the
views held by BMUG, are purely coincidental.
***************************************************************************
Organization: Queen's University at Kingston
Date: Tue, 15 Dec 1992 22:35:57 EST
From: <CHARLESW@QUCDN.QueensU.CA>
Newsgroups: comp.sys.mac.databases
Subject: Is FileMaker Pro multi-user?

  Can several users access a FileMaker Pro database concurrently (with proper
record locking that is)?  If so, does it require a dedicated server?

  Also, while I'm at it, a) is there a way to import data via terminal emula-
tion or will I need a separate program such as MicroPhone, and b) can I write
the equivalent of XCMDs for it like I can for FoxBase?

  Thanks for your help.


.../dave   Dave Charlesworth
Newsgroups: comp.sys.mac.databases
Subject: Start a new database, asking for help/assistance
From: larson@TIGGER.STCLOUD.MSUS.EDU
Date: 16 Dec 92 15:26:30 -0600
Reply-To: larson@TIGGER.STCLOUD.MSUS.EDU
Organization: St. Cloud State University, St. Cloud, MN

	The athletic dept. on our campus is looking into a new scheduling
system and trying to compile information on what program to purchase. I'm
the person responsible for gathering the info. The project would involve
have a schedule broken up into 15 minute segments for a whole day, covering
a year schedule. The database needs to be able to update a master schedule,
billing sheet, and a invoice sheet. Also the master schedule needs to able to
cross-check to see if both the biiling sheet & and the invoice sheet have been
updated when a time segment has been deleted/added. The last part of the
database needs to networked for 2-3 computers entering information. They want a
server computer to run the database all the time and have to macs sending info
to the master database and back to the macs. Also they would like password
protection on the database.

Is there a database program that would able to programmed to deal with
something like this (4th dimension??, Filemaker Pro)?

Would this that difficult of a system to setup. Need help...

please E-mail info/adivce to
larson@tigger.stcloud.msus.edu
Newsgroups: comp.sys.mac.databases
Distribution: world
From: Dave_Burnett@bmug.org
Organization: BMUG, Inc.
Date: Tue, 15 Dec 1992 12:25:14 PST
Subject: FMPRO-Buttons to other DB's

A while ago someone posted a question that went something like this:

"How do I get FileMaker to go to a layout in another database via an on screen
button"

I responded with a suggestion that perhaps having FileMaker send an AppleEvent
to itself would solve this problem.  It will not.

However, it is possible, with FileMaker Pro 2.0, to activate a script within
another FileMaker database.  This can be implemented by tieing your on-screen
button with a script that will activate a script in the target database. 
Thus, when you press the button, the other database will be activated, brought
to the foreground, and the layout defined by the script in the target database
will be displayed.

--Dave Burnett 
***************************************************************************
             From Planet BMUG, the FirstClass BBS of BMUG, Inc.
              The above message was gatewayed via PostalUnion
***************************************************************************
The message contained in this posting is entirely the poster's personal
opinion.  Any possible, real or perceived, (dis)similarities with the
views held by BMUG, are purely coincidental.
***************************************************************************
Newsgroups: comp.sys.mac.databases
Distribution: world
From: Dave_Burnett@bmug.org
Organization: BMUG, Inc.
Date: Sun, 13 Dec 1992 15:22:31 PST
Subject: Re: Filemaker Pro problem

Anthony,

Sure you can right justify the result of your calculation.  Just select the
field and set the justification for align right.

However, one of the limitations of FileMaker is that you do lose all
formatting in text fields when you concatenate them using a calcuation field. 
You can, of course, format the result, but this will effect the entire field.

The only hack that I'm aware of to this problem is to create a custom font
that has bold characters as option characters, italic characters as option
italic, etc.  Then when you format the field with this custom font you will
have the formatting you desire.  

If anyone knows of an easier way with FM Pro 2.0 please cc me on it, but to
the best of my knowledge, FM Pro 2.0 only allows you to copy the results of a
calcuation field, not adjust the formatting character by character.

-- Dave Burnett

***************************************************************************
             From Planet BMUG, the FirstClass BBS of BMUG, Inc.
              The above message was gatewayed via PostalUnion
***************************************************************************
The message contained in this posting is entirely the poster's personal
opinion.  Any possible, real or perceived, (dis)similarities with the
views held by BMUG, are purely coincidental.
***************************************************************************
Newsgroups: comp.sys.mac.databases
From: triantos@netcom.Netcom.COM (Nick B Triantos)
Subject: Re: Is FileMaker Pro multi-user?
Organization: Netcom Online Communications Service
	<92352.115543CHARLESW@QUCDN.QueensU.CA>
Date: Sat, 19 Dec 1992 08:18:18 GMT

FileMaker Pro cannot use anything along the lines of XCMDs or XCFNs to pull
data.  One possible workaround, though, would be to use a nice little
Hypercard script to pull the data and extract the parts you want, then use
AppleEvents to communicate to FileMaker Pro 2.0 and place in the data.  It
would certainly be slow, but as an overnight job, it sounds possible...

Good luck with it!

FM Pro Tip of the Night: Holding down the Cmd key and dragging out a
selection rectangle in Layout mode selects all objects that even touch the
rectangle.  FileMaker Pro normally only selects objects completely enclosed
in the rectangle.

--
-Nick "Ever wonder why so many people think Windows is great?" Triantos

I may work in Claris Technical Support, but not when I'm logged in on
the Internet... 

-- 
-Nick "Ever wonder why so many people think Windows is great?" Triantos

I may work in Claris Technical Support, but not when I'm logged in on
the Internet...
Newsgroups: comp.sys.mac.databases
Distribution: world
From: David_F._Sheppard@bmug.org
Organization: BMUG, Inc.
Date: Sat, 19 Dec 1992 08:34:23 PST
Subject: Re: 4D and accounting problems

This note is in response to Rui Campos.

4D is probably the best choice you could make for the task you have. The
latest version of 4D, 3.0, was just released. It is the first version of 4D
that has tru client/server architecture. Read this weeks MacWeek for a review.
I have no idea how bug-free 3.0 is, however. Also, the new version has not
have all accompanying modules released yet. So 4D Write, 3D Graph, Calc, XREF,
Mover, Compiler, Externals kit etc. are not yet available. 

I'm a fairly new 4D developer. Please be aware that the prior versions of 4D are notoriously slow for multiple users since they are not based on client/server architecture

**** From Planet BMUG, the FirstClass BBS of BMUG.  The message contained in
**** this posting does not in any way reflect BMUG's official views.
From: kby@cco.caltech.edu (Kimo B. Yap)
Newsgroups: comp.sys.mac.databases
Subject: FMP 2.0 question
Date: 20 Dec 1992 01:29:57 GMT
Organization: California Institute of Technology, Pasadena
NNTP-Posting-Host: alumni.caltech.edu
Summary: Best way to implement this
Keywords: labels multiple field

I'd like to make a database in which a company is a record, with contacts
(a reasonable number) as a field within that record.  Two questions:

1.  For repeating fields, is there a way to access the repetitions of the
    field other than those that the first "n" specified for the "display
    n of m fields" question?

2.  (More important) Is there a way I can make a layout that will print
    one label for each contact from the single company, and do this auto-
    matically for variable numbers of contacts for each company?  That is,
    (for example) if I have two companies (two records) and the first one
    has one contact and the second two contacts, I want to be able to (if
    both of these records are in the currently selected set) get a total
    of three labels out of the same layout.  Although I asked (1) implying
    the contact was a repeating field, it doesn't have to be that way if
    that's the only thing that would prevent me from doing (2).  The main
    criterion is one record = one company = 1 to n contacts.

Email is the preferred response. -kby@alumni.caltech.edu

PS  I saw something a while ago about being able to select a record based
(oops, I mean select a layout) based on a field in a record, but I can't
find the thing I saw; could someone refresh me on this; I thought I might
be able to switch layouts per record or something like that.
Newsgroups: comp.sys.mac.databases
From: koehn@vms.macc.wisc.edu
Subject: Re: 4D and accounting problems
Organization:  University of Wisconsin Academic Computing Center
Date: 17 DEC 92 14:44:05    

In article <BzDKIx.KM9@umassd.edu>, rufus@cis.umassd.edu (Rui N. Campos) writes...

>Hello, everyone, I'm new to this group and I have a question.  I am a 4D
>developer, and I have just been contracted to do a database for a retail firm.
>This database invloves the usual things: inventory, Acounts Payable, 
>Accounts Receivable, Vendor maintenance...  I have never done any 4D work
>that required accounting.  My question is:  Is 4D suitable for general ledger,
>and payroll, among other accounting problems, or am I better off looking
>elsewhere?  
> 
>One more question.  How is 4d's performance over networks, and what is a good
>server for this?

I wrote a database in 4D for a client that did some similar things and my advice 
to you is this: don't do the accounting crap in 4D. Just buy some third party 
package (Insight from Peachtree, or Great Plains) and just export the records to 
it. Both of the aforementioned packages have pre-fab external kits that allow 
you to post records to them with a bare minimum of hassle, and they make sure 
that proper accounting procedure is followed.

I'm not an accountant. I hate accounting, and if I can help it I will never 
ever write an accounting system. There are programs out there already that do 
this, and much better than anything that I could write, and I'm happy using 
them.

Just my opinion. And no, I am not affiliated with any software companies 
mentioned in this article.

Brad Koehn
koehn@macc.wisc.edu

Newsgroups: comp.sys.mac.databases
From: michaelh@Xenon.Stanford.EDU (Mike Hennahane)
Subject: Re: 4D and accounting problems
Organization: CS Department, Stanford University, California, USA
Date: 17 Dec 92 00:09:00 GMT

rufus@cis.umassd.edu (Rui N. Campos) writes:
[...]
>This database invloves the usual things: inventory, Acounts Payable, 
>Accounts Receivable, Vendor maintenance...  I have never done any 4D work
>that required accounting.  My question is:  Is 4D suitable for general ledger,
>and payroll, among other accounting problems, or am I better off looking
>elsewhere?  

4d is suitable for anything, if you know what the design issues are...
i have done accounting systems before with no problems, but every
client has different needs and likes to do things in a different way.
:-( 

>One more question.  How is 4d's performance over networks, and what is a good
>server for this?

get as fast a server as you can; performance is proportional to the
server speed.  the performance of 4d server is surprisingly good; you
will probably even get adequate performance without ethernet (although
enet helps a lot).

--mike
Newsgroups: comp.sys.mac.databases
From: jmckee@world.std.com (Jim McKee)
Subject: Re: Odesta's Double Helix
Organization: The World Public Access UNIX, Brookline, MA
Distribution: usa
Date: Mon, 21 Dec 1992 03:54:37 GMT

In article <1992Dec21.003958.20064@ultb.isc.rit.edu> jek5036@ultb.isc.rit.edu (J.E. King) writes:
>
>Seems as though everybody uses Filemaker Pro 2.0v2 and 4th Dimension.. Some
>people have mentioned FoxBase/Mac.. what ever happened to Double Helix?
>How do people feel about DH?  As a consultant I recommend DH for most
>applications because of it's flexibility and power.  Other comments on DH?
>
>I'm just interested to know how many people even know about DH.

Jim ...
   
   Odesta released Helix Express a few months back. It is essentially
the same product as Double Helix, with a few additions, mainly:

     * you can now "store" documents from other applications within
        your database, and open them directly from inside HE

     * several window-styles for your Views, including "Invisible", 
        which is handy for doing large postings (you no longer have
        to wait for the window to draw on-screen) - Custom Windows

     * New calculation tiles -> 11 in all, including "LowerCase,"
        and 10 document-specific tiles

     * User selectable indexes and Custom Icon Names - both for use
        in Custom Mode

     * Several new Keyboard equivalents

     * True/False query optimization, new cursors, Defined/Undefined
        options for Queries

As regards your other questions: I don't know how many people use
DH or HE -> it seems 4D and FoxBase Mac are the two most heavily
used relational DBMS on the Macintosh platform. Most Mac users are
probably more than well served with a flat-file system like FMPro.
And, my sense is that a lot of serious db programmers are turned-off
by DH/HE's "iconic" programming environment. All of that said, I
am entirely pleased with Helix Express. For my small business it has
more than paid for itself over the years - and I haven't had to hire
a programmer to set up or tweak my system for me. The beauty of the
program is its ease of customization (no programming language 
required), and its rock-solid code -> I haven't lost a single byte
of data in 6 years.

DH/HE has its niche out there in Mac-land. Those that like it
seem to REALLY like it. I for one am glad it's there.

---------------------------------------------------------------------------
Jim McKee                    \  "The reward is in the journey."
jmckee@world.std.com         /  On the Red Road with my brothers and all my
jmckee@silver.lcs.mit.edu    \  relations. Ho! Mitakuye Oyasin
---------------------------------------------------------------------------
From: hades@coos.dartmouth.edu (Hades)
Newsgroups: comp.sys.mac.databases
Subject: Re: Is FileMaker Pro multi-user?
Date: 16 Dec 92 16:22:23 GMT
Reply-To: hades@Dartmouth.Edu
Organization: Dartmouth College, Hanover, NH
Disclaimer: Personally, I really don't care who you think I speak for.
Moderator: Rec.Arts.Comics.Info

<CHARLESW@QUCDN.QueensU.CA> writes:

>  Can several users access a FileMaker Pro database concurrently (with proper
>record locking that is)?  If so, does it require a dedicated server?

    Yes FM Pro is multi-user, no it does not require a dedicated server,
nor does it require Appleshare or System seven filesharing. However,
since it is shared-file you are limited by the speed of the host Mac,
and anytime you have more than 4 people working at once, you will slow
down extremely.

>  Also, while I'm at it, a) is there a way to import data via terminal emula-
>tion or will I need a separate program such as MicroPhone, and b) can I write
>the equivalent of XCMDs for it like I can for FoxBase?

    I'm not sure what you mean here. Importing data into FM Pro can be
done only with a data file on an accessible drive. This data can be in a
number of formats, but it still requires a file to read from. You can't
write XCMDs for FM Pro, but if you have version 2.0 you can use Apple
events to basically perform the importing if you wanted.

--
-Brian V. Hughes
	     "If you could care less, then why don't you?"
From: triantos@netcom.Netcom.COM (Nick B Triantos)
Newsgroups: comp.sys.mac.databases
Subject: Re: FMP 2.0 Printing Problem
Date: 15 Dec 92 05:39:18 GMT
Distribution: usa
Organization: Netcom Online Communications Service

In article <7941@news.duke.edu> gk1@acpub.duke.edu (Gavin  Kistner) writes:

   Alright, I feel like this is a simple problem, but I'm not sure why it is
   occurring.  When printing pages of records which are viewed as lists,
   each of which is about two lines long, FMP doesn't seem to be checking
   where the bottom of the page is, and consequently prints records which
   fall into the bottom page margin, and thus get chopped off.

   If it makes a difference, I'm using the NEC SilentWriter 95.

In fact, it makes no difference.  Unfortunately, this is a problem inherent
with the way that FileMaker prints.  It is the user's responsibility to keep
the layouts set in such a way that no fields can overlap the page break
boundary.  One suggestion would be to set a footer to a small amount and
tweak it until you get what you want.  I know, sounds, silly, but if you
don't like it and you're a registered customer, please do send in a
suggestion.  It's the only way that Technical Support and Customer Relations
have of creating leverage to fix problems that we see that haven't been
fixed yet.

If you want, send it in to my attention, from the address in your manual.

--
-Nick "Ever wonder why so many people think Windows is great?" Triantos

I may work in Claris Technical Support, but not when I'm logged in on
the Internet... 

-- 
-Nick "Ever wonder why so many people think Windows is great?" Triantos

I may work in Claris Technical Support, but not when I'm logged in on
the Internet...
From: lishka@dxcern.cern.ch (Christopher Lishka)
Newsgroups: comp.sys.mac.databases
Subject: Advice: which Mac database to get?
Date: 15 Dec 92 10:11:14 GMT
Organization: CERN European Lab for Particle Physics

I am currently building up a database of computer equipment here at
our site, to be used to track the status of various pieces of
mainframe and workstation hardware.  I would like to organize this in
several seperate databases, with a unique ID for each individual piece
of equipment linking the records across databases.  Currently I am
using Excel v4.0 to store the data, but it is apparent that this is
*not* an acceptable solution.

I have had experience doing professional database programming for both
DBase IV and FoxPro, both running on IBM PCs.  Although I am familiar
with Macs (I am the system manager for our group), I am not at all
familiar with the different databases available for them.

I would prefer a relational or object-oriented database program.
Could you provide me with suggestions as to which database program is
best for my needs?  I would appreciate discussions of strengths and
weaknesses of the database program.  Otherwise, could you point me to
a place to look for this information?

Please send all responses to me at lishka@dxcern.cern.ch.  I will
write up and post a summary if there is interest.

						.oO Chris Oo.


-- 
                                                           Christopher Lishka
 Never drive a car when you're dead...			   PPE Division, CERN
				-- Tom Waits		  lishka@dxcern.cern.ch
							     vxaluw::lishka
Newsgroups: comp.sys.mac.databases
From: bromwich@phoenix.Princeton.EDU (Adam Todd Bromwich)
Subject: I'd like to know difference betwn. FileForce and 4D
Originator: news@nimaster
Organization: Princeton University
Date: Fri, 18 Dec 1992 03:27:44 GMT

I'm thinking of purchasing FileForce and I'm wondering why it s made by
Acius but doesn't cost as much as 4th Dimension.

I'm trying to set up an inventory/order/invoicing system for a
relatively small business.

Thanks.

Adam
bromwich@phoenix.princeton.edu

Newsgroups: comp.sys.mac.databases
From: pgiltner@epas.utoronto.ca (Philip W. Giltner Jr.)
Subject: Help w/ filemaker Pro db construction
Organization: University of Toronto - EPAS
Distribution: na
Date: Fri, 18 Dec 1992 16:02:27 GMT

I'm using FileMaker Pro to make a Database for a large class of
students I'm teaching (abt 180 students). I've been able to make
several different layouts, for different purposes. The first layout is
an individual student's record, with comments on his different papers
& tests. The second layout is a record of who who has or hasn't handed
in a given work (using if(x,y)). The third one is the one that's
giving me trouble, and why I ask for help.

This third onI've included a grand total summary at the end of this
layout. In the summary, I've figured out how to make count of all the
grades issued,  but I also want to make count of a the total count of
grades of each kind of grade issued, where A is greater than 80, B
is between 70-79, c between 60-69, e between 50-59, and zero-to-e is
obviously zero to 49.  This has taken several days of my time to
figure out, & still no progress is shown. How do I define a field to
look at all the fields (called "Overall Grade") and count the number
in each category? Anyone?  Please respond directly, as I don't
subscribe to this Newsgroup. I appreciate it.

Phil Giltner					Dept of History
pgiltner@epas.utoronto.ca			Univ of Toronto
From: donp@novell.com (don provan)
Newsgroups: comp.sys.novell
Subject: Re: 3.11, TCP/IP routing w/ subnets
Date: 17 Dec 92 19:43:54 GMT
Organization: Novell, Inc., San Jose, California

In article <1992Dec17.082115.1536@novell.com> donp@novell.com (don provan) writes:
>In article <16DEC199208530385@spades.aces.com> gavron@ACES.COM writes:
>>That's right, so save your lightning stories to spook your kids 
>>with, and while you're so gung ho on RFCs perhaps you'll explain
>>why your brain-damaged software doesn't send a UDP Port Unreachable
>>thereby making TRACEROUTE useless.
>
>[ Provan's extended rambling about ICMP Port Unreachable deleted. ]

Now that i've had a good night's sleep, it occurs to me that the
really critical ICMP feature for traceroute is ICMP Time Exceeded, not
the Port Unreachable.  (Traceroute depends on Port Unreachable, too,
but only on the ultimate destination machine. Time Exceeded is
necessary at each hop in the route.)  No matter: my story is just the
same, as Time Exceeded was another one of those ICMP features i had to
leave out initially and then put in during that same clandestine coding
session after their lack was brought to my attention.

I didn't want anyone to get the impression i didn't know what i was
talking about.

>and it's been in all versions of TCPIP.Nlm since September or so and
>it will be in all future NetWare releases, but that's not as funny.

It occurs to me that this might be misleading.  I added these changes
to the 2.xx versions of TCPIP.NLM.  NetWare v3.11 includes version
1.00.  2.xx versions are only available in newer products, including,
as i said, MPR 2.0 and "future NetWare releases".  So far as i know,
it is not available through NetWire or anonymous FTP.

						don provan
						donp@novell.com