HDTenEightyP/NetNews huggingface dataset:
From: mwgordon@nyx.cs.du.edu (Mike Gordon)
Subject: Re: Auto-modification date in FM
X-Disclaimer: Nyx is a public access Unix system run by the University
	of Denver for the Denver community.  The University has neither
	control over nor responsibility for the opinions of users.
Keywords: Filemaker
Organization: Nyx, Public Access Unix at U. of Denver Math/CS dept.
Date: Mon, 11 Jan 93 21:14:21 GMT

In article <1993Jan11.203119.10597@Newbridge.COM> jeffl@Newbridge.COM (Jeff Laks - qmail) writes:
>In our db, we have defined one of the fields as an auto-entry field for 
>the modification date.  So, everytime I change the data in a record, the 
>date will change to reflect this.  The problem arises when we do a 
>'relookup' - we have two dbs linked, and if you do a relookup, it obviously 
>does a comparison search on every single record and therefore updates the 
>modification date for every single record! 


Jeff,
     
    Add a serial number field to your database and tell your script to find
the current recor before you issue your relookup command.   Then do a Find All 
to get back to all your records.

Here's the script: 
 

Copy                Serial_Number
  Select entire contents     
 
Enter Find Mode
 
Paste               Serial_Number
  Select Entire Contents

Relookup
  Perform Without Dialog

Find All


     Oh, one other thing.  You have to put the serial number field in the 
layout that you'll be doing the search from.  I set mine to a 1 point yellow
typeface (yellow doesn't show on the B/W monitors) and make it non-printing, 
delete it from the tab order, and push it off the right side of the screen.
This makes it more-or-less invisible to the user.

Mike Gordon  N9LOI  mwgordon@nyx.cs.du.edu

Newsgroups: comp.sys.mac.databases
From: triantos@netcom.Netcom.COM (Nick B Triantos)
Subject: Re: FileMaker Pro help
Organization: Netcom Online Communications Service
Date: Tue, 12 Jan 1993 15:35:02 GMT

In article <1itc70INNo2d@escargot.xx.rmit.OZ.AU> s914370@minyos.xx.rmit.OZ.AU (David Morrison) writes:

>Help needed with FileMaker Pro!

>Using the ScriptMaker (under v2.0) I am trying to pass some information
>from one file to another. This I use Copy / Paste. However, I need to be
>able to hold two pieces of information in the clipboard at once. Is this
>possible ?

Well, what you can do is to concatenate both fields into one text
calculation and separate them by something obvious, like this:
  MyTextCalc = Field1 & ":::" & Field2  , result is Text.
You can then search for ":::" with the Position() function and parse your
two original fields back into two fields with the Let() and Right() functions.

>Am I correct is assuming that FileMaker Pro cannot implement properly a 
>many-to-many relation (as in a true relational data base). I know you can
>look at info. in another file by using the Lookup feature, but can you
>transfer information from a particular record to another record (different
>type - in a different file) to create a new record of this type.

Unfortunately, you are right.  FileMaker Pro is still just an extremely
powerful FLAT FILE database, with hints of relational capability through the
lookups and external scripts.  Again, this is something on my own personal
wish list of future FileMaker Pro changes...

Nick Triantos                     Avoid bus errors... Take the train!

Though I work for Claris in Technical Support, the thoughts, words, and
suggestions expressed here are NOT officially endorsed by Claris in any way

Newsgroups: comp.sys.mac.databases
From: danw@netcom.com (Daniel Wasserman)
Subject: Re: SQL Server/Client
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Date: Tue, 12 Jan 1993 19:22:22 GMT

-- 
Newsgroups: comp.sys.mac.databases,comp.sys.mac.apps
From: danw@netcom.com (Daniel Wasserman)
Subject: Re: Mapping software for Mac -- experience anyone?
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Date: Tue, 12 Jan 1993 19:30:48 GMT


Geoff,

I've had a chance to perform some database mapping in the past and
have attempted to use both GeoQuery and Atlas Pro.  For street-level
mapping I would go with Atlas Pro.  At the time I was doing this
(about a year ago) GeoQuery did not support any street-level maps, it
could only plot people by their zip code.

If you are attempting get a national picture of your data by plotting
the address across many states then the zipcode-based plots in GeoQuery
would work fine.  However, if you are looking to plot addresses within
a particular county with resolution down to the street level you will
have to use a more ddetailed product like Atlas Pro.

The street-level maps are an extra item that you would have to order
through the company making the software.  These maps are produced on a
county level and typically cost around $500.  There is usually a choice
of multiple maps a given county, each with better clarity than the next.
Street-Level ETAK maps are produced by the government and are pretty
good but may have some streets in new developments missing and the 
graphical clarity is a little rough.  Many companies take these from
the govt and then clear them up and add additional street detail. Of
course, the price rises as you get better, more accurate maps.

Atlas Pro is made by:

Strategic Mapping
3135 Kifer Road
Santa Clara, CA  95051
(408) 970-9600

-Dan Wasserman      danw@well.sf.ca.us       danw@netcom.com

-- 
Newsgroups: comp.sys.mac.databases
From: tom_milligan@mentorg.com
Subject: FoxBase+Mac Books + Dev Libraries
Date: Tue, 05 Jan 1993 17:37:58 GMT
Organization: Mentor Graphics Corporation

 I have been prowling the local software stores for books on programming
FoxBASE+ Mac and have come up empty.  There are, however, *lots* of books
on FoxPRO for the PC.  One book in particular stands out as looking very
useful, it is a FoxPRO developers library with all sorts of cool utilities 
(like zip code cross-checking with State, etc.) on a PC disk.  

The question I have is "Why isn't any of this stuff available for FoxBASE+ 
Mac?"  Is it available and I just haven't found it?  Have I found a market 
niche that I can fill? :-)

Tom Milligan
Newsgroups: comp.sys.mac.databases
From: rgaros@bio.vu.nl (Rene G.A. Ros)
Subject: Writing 4D Ext.packs
Organization: VU Biology, Amsterdam, The Netherlands
Date: Tue, 5 Jan 1993 14:55:30 GMT

Hi,

Because I don't yet own a External Kit, and I will not buy it until the new
3.0 compatible is available I need to learn it from source files from
others. However, I haven't seen the source files of an external pack yet.
So, can someone explain me the basics of doing this (pref. THINK Pascal)?

Thanks in advance,
Rene Ros

rgaros@bio.vu.nl
From: dbox@net4.ics.uci.edu (Don Box)
Subject: MacTCP External for 4D
Newsgroups: comp.sys.mac.databases
Reply-To: dbox@ics.uci.edu (Don Box)
Organization: UC Irvine
Date: 5 Jan 93 04:16:28 GMT


Does anyone know of an external that allows you to open a TCP
connection using MacTCP?  I only need to open it, send some data down
the pipe and close it, so there is no need for any global state
between procedure calls.

Thanks,
Don Box



Newsgroups: comp.sys.mac.databases,comp.sys.mac.apps,comp.databases,comp.os.ms-windows.apps,comp.os.msdos.apps
From: lance@hartmann.austin.ibm.com (Lance Hartmann)
Subject: FoxBase -- Comments?  Status?
Summary: Seeking advice/recommends on FoxBase.
Date: Thu, 7 Jan 1993 18:53:41 GMT
Reply-To: lance%hartmann.austin.ibm.com@ibmpa.awdpa.ibm.com
Organization: IBM, Austin
Keywords: foxbase foxpro microsoft database sql macintosh ibm pc dos windows
Followup-To: poster

If anyone has ANY comments or experiences you'd like to share surrounding
FoxBase for the Mac, I'd really like to hear from you -- email PLEASE!

    >>>  Please note my "funky" email address  <<<
    >>>  with the percent ('%') sign in it.    <<<

We have a database up and running between FoxPro 2.0 on a PC clone and
4th Dimension on a Mac II.  Having incurred too, too many aggravations in
dealing with 4D (performance, proprietary database manipulation language,
etc.), I'd really like to find another database product to use for the
Mac.  Ideally, I believe, that would be FoxBase due to our continued
commitment to FoxPro 2.0 on the PC (which, incidentally, is EXPONENTIALLY
FASTER and, in my opinion, a lot easier to use).

Also, Microsoft is working toward releasing a Windows version of FoxPro
in 1st quarter '93.  Microsoft has stated that they're trying to
offer better support across hardware platforms.  Does anyone know of
any current developments with FoxBase?  Is it approaching the level
of FoxPro 2.0?  Is a new release of FoxBase expected corresponding
to the Windows version?  I haven't been able to wrestle much info from
a Microsoft sales rep via their 800 number (though he was very friendly).

We've just learned that we need to make a decision soon as we currently
have an "offer" by Acius to upgrade 4D and save $100 if we do so by
the end of January.  I very much want to move away from that platform
to something with a reasonable interface, nice programming tools,
GOOD performance, and with SQL support.

I'll be more than happy to post a summary of the replies should
interest warrant it!

Thanks to all in advance,
Lance Hartmann (lance%hartmann.austin.ibm.com@ibmpa.awdpa.ibm.com)
               Yes, that IS a '%' (percent sign) in my network address.
------------------------------------------------------------------------------
All statements, comments, opinions, etc. herein reflect those of the author
and shall NOT be miscontrued as those of IBM or anyone else for that matter.
From: bruhn@exaib (Peter Bruhn )
Newsgroups: comp.sys.mac.databases
Subject: FileMaker Pro --> Open Access
Date: Wed, 6 Jan 93 15:42:53 MESZ
Organization: WU-Wien
Distribution: world
NNTP-Posting-Host: exaib.wu-wien.ac.at

Anyone out there who knows an easy way to convert data from FileMaker
Pro (2.0) to Open Access (DOS)?

Any help is appreciated.

Thanks

Peter (bruhn AT uxe.wu-wien.ac.at)

Newsgroups: comp.sys.mac.databases
From: rob@leland.Stanford.EDU (Rob Tanner)
Subject: Problem with FileMaker Pro version 2.0v2 on a CAP volume
Keywords: CAP FileMaker
Reply-To: "Rob Tanner" <rob@sherlock.stanford.edu>
Organization: Stanford University, California
Distribution: na
Date: Mon, 11 Jan 93 05:30:43 GMT


I have an on-going (meaning I haven't been able to fix it yet) with
FileMaker Pro version 2.0 (both 2.0v1 and 2.0v2) files becoming
damaged (and sometimes NOT recoverable) when residing on a CAP volume.
I have not had the same problem with files residing on the Mac.

Is there some parameter, et cetera, I need to be aware of in building
CAP (I'm using 6.0pl100 and about to upgrade to 60pl126)?  Has anybody
seen a similar problem.  It is intermittent.  The user may go for
several days with no problem and then try to open the file and get the
message: 

           This file was not closed properly. Filemaker
           is now performing a consistency check

Followed immediately by:
 
           Sorry, this file is badly damaged. Please use
           the recover command.

I'd appreciate any help I can get with this problem.

Thanks,

Rob Tanner
Stanford University

-- 
Rob Tanner                              Internet: rob@sherlock.stanford.edu
System Administrator
Stanford University, California
Newsgroups: comp.sys.mac.databases
From: mwgordon@nyx.cs.du.edu (Mike Gordon)
Subject: Slight problems in FMP2.0
Organization: Nyx, Public Access Unix @ U. of Denver Math/CS dept.
Date: Fri, 8 Jan 93 16:18:54 GMT

    Is there any way to limit passworded users from accessing FMP2.0 
program elements?  For example, I locked our data entry people out of 
making layout changes, but they can still get themselves into layout mode 
and get stuck there.   I'd like to prevent them from touching the "Browse,
Find, Preview, Layout" pullup, the status area toggle, the magnify up and 
down boxes, and the zoom window box (upper right corner).
    Also, is there an easy way to attach a sound byte to a script?  I'd like 
to have a voice announce an on-screen button when pressed, and do some voice 
prompting.  So far I've done it by storing the sound bytes in a another
file (as picture/sound fields) and subscripting out to that file to a script 
that does a "go to layout - select/play".  It works, but it takes about 4 
seconds to play a 1 second phrase.

Thanks much,

Mike Gordon  N9LOI  99681084@uwwvax.uww.edu
From: clark@netcom.com (Sue Clark)
Newsgroups: comp.sys.mac.databases
Subject: Whatever happened to Nubase?
Summary: did it ever get released?
Keywords: Nubase dbase mac
Date: 12 Jan 93 02:45:08 GMT
Distribution: usa
Organization: Netcom - Online Communication Services  (408 241-9760 guest)

What ever happened to Nubase, the latest incarnation of DBase Mac?  Did
it ever get released?  Anyone knowing anything, please e-mail me:
clark@netcom.com.  Thanks.

Sue
-- 
-----------------
Sue Clark
clark@netcom.com
Newsgroups: comp.sys.mac.databases
From: Mary.Curtin@bbs.actrix.gen.nz
Subject: Comparisons of rdbm software?
Organization: Actrix Information Exchange
Date: Tue, 12 Jan 1993 11:14:03 GMT


Have any of the major magazines published a comparison of relational
database packages for the Mac recently (say in the last year)?  

-- 
\   \/   /  |  
 \/\/\/\/   |  mary.curtin@bbs.actrix.gen.nz

Newsgroups: comp.sys.mac.databases
From: jeffl@Newbridge.COM (Jeff Laks - qmail)
Subject: Auto-modification date in FM
Keywords: Filemaker
Organization: Newbridge Networks Corporation
Date: Mon, 11 Jan 1993 20:31:19 GMT

Does having an auto modification date preclude linking Filemaker Pro files?

In our db, we have defined one of the fields as an auto-entry field for 
the modification date.  So, everytime I change the data in a record, the 
date will change to reflect this.  The problem arises when we do a 
'relookup' - we have two dbs linked, and if you do a relookup, it obviously 
does a comparison search on every single record and therefore updates the 
modification date for every single record! 

We are currently running Filemaker Pro 1.0v3, but we also have a copy of 2.0
in-house.
-- 
Jeff Laks                      | jeffl@newbridge.com   | 
Newbridge Networks Corporation | Phone: (613) 591-3600 |
Kanata, Ontario, Canada.       | FAX:   (613) 591-3680 |
Newsgroups: comp.sys.mac.databases
From: triantos@netcom.Netcom.COM (Nick B Triantos)
Subject: Re: Exporting ASCII text from Filemaker Pro
Organization: Netcom Online Communications Service
Date: Sun, 10 Jan 1993 01:15:26 GMT

Tim Myers recently asks about exporting to tab-separated text from FileMaker
Pro.

Actually, Tim, FileMaker Pro seems to export everything as it claims it
will.  The snag that you may be getting caught on, though, is that FileMaker
will export a Vertical Tab (ASCII 11), for any returns within a field.  So,
if you have one field that may have several lines of information which you
have manually added in carriage returns to, you will get these VT
characters.  The standard carriage return is used to signal the
end-of-record marker.

Good luck, and Happy FileMaking!
-Nick

Nick Triantos                     Avoid bus errors... Take the train!

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

Newsgroups: comp.sys.mac.databases
From: jeffp@netcom.com (Jeff)
Subject: 4D 2.2 Externals in 3.01
Organization: BeHereNow
Distribution: usa
Date: Sun, 10 Jan 1993 18:36:47 GMT

Does anyone know if 2.2 external objects will work with 3.01?
I have an external that I would like to use with the new
version, but I have no idea if it will work or not.

Jeff-

Newsgroups: comp.sys.mac.databases
From: michaelh@Xenon.Stanford.EDU (Mike Hennahane)
Subject: Re: 4D Server Memory
Organization: CS Department, Stanford University, California, USA
Date: 10 Jan 93 22:23:43 GMT

Morris Weinstock <MAW14@psuvm.psu.edu> writes:

>Does anyone know how much memory the 4D server (for 3 simultaneous users) would
>take up?

this depends on the complexity of the database that it is running.
there *is* a downside t giving it too much memory; 4d server has to
flush its cache every so often, so if the memory is bumped up high,
then the cache will be large and users will have to wait.  most
databases probably don't need much more than the amount of memory that
is the default (i think 1500K).

--mike
From: chuckp@u.washington.edu (Chuck Pliske)
Newsgroups: comp.sys.mac.databases
Subject: Re: Database recommendation
Date: 9 Jan 93 19:45:22 GMT
Article-I.D.: shelley.1ina0iINNffi
Distribution: world
Organization: University of Washington
NNTP-Posting-Host: chuckp.staffdev.washington.edu
X-UserAgent: Nuntius v1.1.1d17
X-XXMessage-ID: <A7746B522701372A@chuckp.staffdev.washington.edu>
X-XXDate: Sat, 9 Jan 93 19:45:22 GMT

Depending on your power requirements, you may find the 4D/MSI Access 
route interesting.  4D is very powerful, and using either MSI Access from 
Metropolis Software, or the new, expensive 4D Server, can be accessed 
from Pascal or even Hypercard with relatively simple calls.

Chuck
Newsgroups: comp.sys.mac.databases
From: triantos@netcom.Netcom.COM (Nick B Triantos)
Subject: Re: FM Pro 2.0 --> AppleEvents --> MicroPhone II
Organization: Netcom Online Communications Service
Distribution: World
Date: Sun, 10 Jan 1993 01:20:56 GMT

In article <C0I805.Ju9@bcstec.ca.boeing.com> rgc3679@bcstec.ca.boeing.com (Robert G. Carpenter) writes:

   Is it possible to send a fax via AppleEvents from FM Pro 2.0 via
   MicroPhone II?

   I haven't upgraded to FM Pro 2.0 yet, nor do I yet own MP II, so
   reading their manuals isn't an option. But, if this can be
   done I'll spend the money.

Why worry about Apple Events to send a fax from FileMaker Pro?  Is the
document you wish to fax some sort of Word, MacWrite II, or other kind of
document?  If you wish to fax a report from FileMaker Pro, look for some
faxprint software, such as FaxSTF (what I use), FaxPro, or QuickLink Fax.
Any of these will let you "print" to a faxmodem.

Also, only MicroPhone Pro includes fax-related software, as best as I know.
It includes a version of FaxSTF...

Hope this helps!
-Nick

Nick Triantos                     Avoid bus errors... Take the train!

I may work in Claris Technical Support, but not when I'm logged in on
the Internet...
From: dbox@net4.ics.uci.edu (Don Box)
Subject: Externals for 4D 3.0.1 vs 2.2.3
Newsgroups: comp.sys.mac.databases
Reply-To: dbox@ics.uci.edu (Don Box)
Organization: UC Irvine
Date: 5 Jan 93 04:20:13 GMT

Can 2.x.x externals be used with 3.x.x?  Does anyone have the External
Kit for 3.x.x, and does it include what is needed to develop externals
for 2.x.x?

Also, is Acius going to continue to support or even sell 2.2.3
runtimes??

DB
Newsgroups: comp.sys.mac.databases
From: danw@netcom.com (Daniel Wasserman)
Subject: Re: SQL Server/Client
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Date: Tue, 12 Jan 1993 19:29:24 GMT


Matt,

Most of the major mac database players support using the SQL language
to query _remote_ databases from within their programs.  This means that
products like 4th Dimension, Foxbase, Omnis can all query outside systems
and bring the data back into their program for manipulation.  What the 
mac programs lack however is the ability to allow SQL queries on their
own data.  The only noted exception to this is Oracle on the Mac.

If you are looking to set up a client-server solution to your IBM server
any of the above products could be used to access the data via DAL.  DAL
is a generic way of accessing a wide variety of SQL databases (Sybase,
Oracle, Ingres, Informix, DB2, etc).  The drawback to DAL is that because
of its generic approach you are working with a "lowest common denominator"
of the SQL languange and will find it difficult to make use of any
extended SQL features particular to your host system.  The benefit of DAL
is that your end code will survive a change of the back end.  If you wrote
your database to access an Oracle database today, you could change the
back-end to Sybase tomorrow with very little change to your front-end.

4th Dimension is definitely the most well-rounded program when it comes
to Connectivity options.  ACIUS sells tools that support DAL, SQL Server &
Oracle Server.  The latter two options are a more direct way of dealing
with Sybase and Oracle servers respectively.  The SQLServer product
communicates on a DBLib level with the server so you have access to all
of sybases advanced capabilities, as well as a much faster communication
path between the two products.  The Oracle Server (to be released soon)
acts much the same way, using SQL*Net to directly communicate with the
host.  Both of the ???_Server products are the way to go if you know
you will only be connecting to the specific platform.

-Dan Wasserman      danw@well.sf.ca.us       danw@netcom.com

--
From: ainsley@uniwa.uwa.edu.au (Ainsley Calladine)
Newsgroups: comp.sys.mac.databases
Subject: Lots of nested If's in FMP
Date: 12 Jan 1993 16:06:43 +0800
Organization: The University of Western Australia
NNTP-Posting-Host: uniwa.uwa.edu.au
X-Newsreader: Tin 1.1 PL5

Hi!
I'm currently setting up a db in FMP2 which is largely to make data
entry by a number of novices straight forward, chances are they won't
understand the data structure at all.
In a number of cases I have fields which have up to 50 pre-defined
values (although most are <20) to choose from. These categories are then
grouped into a smaller number of categories (3-5). What I want is to
have the data entry people only choosing one of the lower categories
(using radio buttons) and the higher one being entered automatically.
I've used a field defined as a calculation with a nested 'If' statement
like this:

If (Field 1 = "X" or Field 1 = "Y" or Field 1 = "Z", "It's one of
these", If (Field 1 = "A" or Field 1 = "B" or Field 1 = "C" or Field 1 =
"D", "It's something else", "Or it's nothing"))
 
This works fine but I'm concerned that a nested 'If' testing 50 cases
might be a bit big! Also, am I right in believing that this calculation
definition is stored once and only the result is stored several thousand
times once for each record?
 
Any suggestions will be appreciated
 
Ainsley
Newsgroups: comp.sys.mac.databases
From: jak@panix.com (Jack Krueger)
Subject: Re: SQL Server/Client
Organization: PANIX Public Access Unix, NYC
Date: Tue, 12 Jan 1993 20:07:44 GMT

In <1993Jan12.154359.8130@midway.uchicago.edu> aaron@noproblem.uchicago.edu (Aaron L. Bratcher) writes:

>In article <1993Jan10.122239.414008@magicbb.uucp>  writes:
>> What database programs for the mac support the SQL language and can be  
>used as
>> clients to IBM servers?


>There's Oracle.

And there' Omnis by Blyth Software.
From: s914370@minyos.xx.rmit.OZ.AU (David Morrison)
Newsgroups: comp.sys.mac.databases
Subject: FileMaker Pro help
Date: 12 Jan 93 02:59:44 GMT
Organization: RMIT Computer Centre
NNTP-Posting-Host: minyos.xx.rmit.oz.au

Help needed with FileMaker Pro!

Using the ScriptMaker (under v2.0) I am trying to pass some information
from one file to another. This I use Copy / Paste. However, I need to be
able to hold two pieces of information in the clipboard at once. Is this
possible ?


Am I correct is assuming that FileMaker Pro cannot implement properly a 
many-to-many relation (as in a true relational data base). I know you can
look at info. in another file by using the Lookup feature, but can you transfer
information from a particular record to another record (different type - in
a different file) to create a new record of this type.

Thank you...

David
email : s914370@minyos.xx.rmit.oz.au