HDTenEightyP/NetNews huggingface dataset:
Organization: Penn State University
Date: Mon, 4 Jan 1993 20:40:03 EST
From: <SJD9@psuvm.psu.edu>
Newsgroups: comp.sys.mac.databases
Subject: Omnis multiuser

In Omnis (v7) how do you deal with verifying/limiting the
number of multiple users in an application?

If you are distributing a custom application, what approach
can you use to ensure that the software is not pirated and used
for 12 machines, instead of the 3 copies which were purchased?

4th Dimension handles this pretty thoroughly, if a bit harshly.
With 4D (through version 2.2.3) each runtime copy has a serial
number coded into it and when the runtime is started up, it looks
out over the network to see if any other copies with the same
serial number are running. With 4D Server (just out) they use
a dongle (hardware key) which is also obnoxious, but effective.

Is there a way to achieve similar results with Omnis? Maybe keep
track of the number of simultaneous users? But then what if someone
crashes while logged onto the database--will they still be
considered logged on?

Any thoughts and ideas appreciated.

Steve
 -----------  Steve Dahm   --------- Internet -->  sjd9@psuvm.psu.edu -----
|         InfoSolutions, Inc.        BITNET   -->  sjd9@psuvm              |
|         147A Silverdale Rd.                      (business acct on VM)   |
|          Julian, PA 16844          Compuserve->  70713,2423              |
----------- 814-355-2983   --------- AppleLink-->  dahm1   ---------------
Newsgroups: comp.sys.mac.databases
From: jbk@world.std.com (Jeffrey B Kane)
Subject: Re: FM Pro 2.0 --> AppleEvents --> MicroPhone II
Organization: The World Public Access UNIX, Brookline, MA
Distribution: World
Date: Fri, 8 Jan 1993 23:41:23 GMT

>
> I've not done anything with AppleEvents yet. How do you learn about using
> or writing them? ...Buy a book or is it explained in each application's
> manuals.
>

The easiest and best way for a non-programmer to understand and learn to
write Apple Events is with a program called UserLand's Frontier.  They
have created a wonderful scripting environment that can control all the
programs on your mac that understand apple events.  You can see the
way they are sent and received, and what information is needed when you
want to send them.  They also have high level commands (glue) that call
the actual AE for a number of AE aware programs including Excel, PageMaker,
Microphone, FileMaker, Navigator, Hypercard, On Location, Stuffit Deluxe,
Claris Resolve, Claris MacProject, etc, etc.

On compuserve they have a very active area of people who do scripting
and can give you a hand.  Everything the program does is with AppleEvents,
and none of the code is hidden.  If you are curious about how anyone's
glue and scripts work just take a peek.

             Jeffrey


======================================
Jeffrey Kane, MD
Kane Biomedical Systems
Boston, MA

Internet    jbk@world.std.com
Compuserve  74206,640
AppleLink   D0738

[Don't take life too seriously... it's not like anyone gets out of it alive.]
Newsgroups: comp.sys.mac.databases
Distribution: world
From: Dave_Burnett@bmug.org
Organization: BMUG, Inc.
Date: Thu, 07 Jan 1993 19:31:48 PST
Subject: Re: FileMaker Pro --> Open Access

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

Probably the easiest way is to export the data from FileMaker to a tab
delimited file on a 3.5 floppy formatted as an IBM floppy and then import into
your DOS system.

--Dave Burnett

**** From Planet BMUG, the FirstClass BBS of BMUG.  The message contained in
**** this posting does not in any way reflect BMUG's official views.

Xref: sparky comp.sys.mac.databases:1657 comp.sys.mac.misc:21428 comp.sys.mac.apps:19382
From: mk46+@andrew.cmu.edu (Matthew E. Kowalczyk)
Newsgroups: comp.sys.mac.databases,comp.sys.mac.misc,comp.sys.mac.apps
Subject: Excel 4.0 question
Date: 6 Jan 93 03:56:55 GMT
Article-I.D.: andrew.YfGiIb200WBMA1TVdf
Organization: Junior, Social & Decision Sciences, Carnegie Mellon, Pittsburgh, PA

Does anyone know any possible way to create an excel spreadsheet with
different levels of security. I need to create a spreadsheet that has 10
different passwords, each with its own level of security. For example,
someone with a level 1 security is only able to edit the first column of
cells, but he/she can see all the other cells. 
I have already created this program using FM 2.0, but my boss needs me
to recreate the program in Excel. Is this possible?, and if it is
possible, does anyone know how to do it?

Any help would be appreciated.
Please respond directly to this account.



     Matthew Kowalczyk     Carnegie Mellon University   mk46+@andrew.cmu.edu
-------------------------------------------------------------------------------
"...In a good way. 10 songs. Spontaneous. Creation. Emotion. Very
pleasing. Real Music. No analyzing. No pressure. No hype. Just music to
make music. Friends and a reason. Chemistry. Beauty. Life Rules!" -Jeff
Ament (Temple of the Dog)
-------------------------------------------------------------------------------
Newsgroups: comp.sys.mac.databases
From: jeffp@netcom.com (Jeff)
Subject: Re: 4D v3.0 is Buggy
Organization: BeHereNow
Date: Sun, 10 Jan 1993 18:17:29 GMT

In article <1inse1$no1@agate.berkeley.edu> rwahbe@madrone.CS.Berkeley.EDU (Robert Wahbe) writes:
>I bought 4D v3.0 about 3-4 weeks ago and have been developing
>a fairly large application with it.  Had I to do it over again,
>I doubt I would get 4D.  I chose 4D because it is a well reviewed product

I have just purchased 3.01 (I think I will send it back and buy a used copy
of 2.2.3). I have noticed no bugs in it, but I am a beginner at this, and I
don't use the multi-user and server features, so it seems that 3.01 is
over kill for my needs and 2.2.3 will do just fine. 

Anyway, just a note to let you know that 3.01 looks fairly stable to me...

Jeff-



Newsgroups: comp.sys.mac.databases
From: 5703dgau@lavalvm1 (Denis Gauthier)
Subject: FileMaker 2.0 et system 7.1?
Followup-To: comp.sys.mac.databases
Organization: Universite Laval
Date: Mon, 11 Jan 1993 15:38:03 GMT

Hi folks
Any comments about FileMaker Pro 2.0 and System 7.1

The machine is a Macintosh IIFX, 20 meg of Ram (32 bit adressing ON)
SYSTEM 7.1 english

FileMaker refuse to work  the application has quit .........

Any idea or suggestions ?????

Denis Gauthier
Centre de traitement de l'information
Services a la clientele
Universite Laval
Quebec
e-mail : 5703DGAU@VM1.ULAVAL.CA or 5703DGAU@lavalvm1.bitnet
Newsgroups: comp.sys.mac.databases
From: heuring@riker.cs.colorado.edu (Vincent Heuring)
Subject: FMP Custom Date Format Problem
Organization: University of Colorado, Boulder
Date: Sun, 10 Jan 1993 23:41:56 GMT


I am trying to create a date field with a custom date format of the
kind mm/yy, as in 12/92. I go to the date format in the format menu,
and create a custom date that looks like: month /  year empty empty empty.
But when I try to actually enter a date in that form, I get a dialog box
that says

	"The date in this field must have a valid date in the range of
	years 1 to 3000, and should look like "12/31/92."

Is this a FMP message, or a system message? The system date format
does not allow a format of the form mm/yy. The day must always be
present. Is this a FMP bug, or am I overlooking something?

I've tried calling Claris Tech Support, but their line is *always* busy,
at least when I've called.

-- 
---
 Vincent Heuring   Dep't of Electrical & Computer Engineering
 University of Colorado at Boulder      Boulder CO 80309-0425
 heuring@cs.Colorado.EDU   o) 303-492-8751    h) 303-449-8868
Newsgroups: comp.sys.mac.databases,comp.sys.mac.oop.macapp3,comp.sys.mac.programmer
From: schorsch@cheshire.oxy.edu (Brent William Schorsch)
Subject: database engines
Summary: I need to find a database engine for a MacApp project
Keywords: database, engine
Organization: Occidental College, Los Angeles, CA 90041 USA.
Date: Wed, 13 Jan 1993 00:36:01 GMT


I am trying to find a database engine.
It needs to be a set of libraries which can be linked into my code.
The
project will be written with MacApp.
The database probably has to be relational (although I might be able
to get away with doing it myself in a flat file engine...)
I know about InsideOut (I am currently awaiting literature from them.)
Is there anything else on the market?
Please respond by e-mail or phone:
schorsch@oxy.edu
or 818-780-2220 x115 (work) 213-344-0476 (home)
Thanks!
-Brent Schorsch
Newsgroups: comp.sys.mac.databases
From: triantos@netcom.Netcom.COM (Nick B Triantos)
Subject: Re: FM Pro Menu Hiding
Organization: Netcom Online Communications Service
Date: Sun, 10 Jan 1993 01:26:02 GMT

In article <1993Jan6.204321.16431@fns-nc1.fns.com> mcnc!fns-nc1.fns.com!hph (Paul Holzworth) writes:

   I am generating a Filemaker Pro database that I would like to be
   completely button driven.  I do not want the user to access or even
   see the menu bar or the status area.  I can hide the status area from
   a script but the user can make it visible again.  I would appreciate
   any suggestions.

Unfortunately, there is no way to remove the Show/Hide Status button in
FileMaker Pro 2.0, nor is there a way to remove the menus.  You can, of
course, set up access privileges to remove certain access for the users,
though.

-Nick

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

Though I work for Claris in Technical Support, the thoughts, words, and
suggestions here are NOT officially endorsed by Claris in any way
From: cconstantine@galaxy.gov.bc.ca
Newsgroups: comp.sys.mac.databases
Subject: Database Programming experience anyone??
Date: 9 Jan 93 03:35:07 GMT
Organization: BC Systems Corporation

Does anyone out there have experience with writing code to read/write/display
.dbf files from dBase, FoxPro2 (PC) or FoxBase+/Mac 2.0.1???

If so, I would like to here from you and pick your brains on some problems I
have been having with my routines.


Thanks Muchly!!!


Carl B. Constantine
CCONSTANTINE@galaxy.gov.bc.ca
Newsgroups: comp.sys.mac.databases
From: mwgordon@nyx.cs.du.edu (Mike Gordon)
Subject: Different Layouts based on password (or group)
Organization: Nyx, Public Access Unix @ U. of Denver Math/CS dept.
Date: Tue, 12 Jan 93 18:35:51 GMT

      Is there a way to make FMP start at a different layout depending on 
the password that they enter the database under?  I want our data entry 
people to get right to their screen, but I want supervisors to get a 
menu layout that they use to select which reports to print.  
      I absolutely don't want the data entry people to be faced with the
menu screen.  They pull up several databases during the day.  (Identical
templates, different data.)  And that would be an added inconvienance.  I
also don't want the data entry people faced with the menu, as they shouldn't
ever need to print reports.

Thanks much,

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

Newsgroups: comp.sys.mac.databases
From: charlesa@niwot.scd.ucar.edu (Charles Albrecht)
Subject: Re: MacTCP External for 4D
Organization: Scientific Computing Divison/NCAR Boulder, CO
Date: Wed, 6 Jan 1993 19:29:02 GMT

In article <2B490B9C.14938@ics.uci.edu> dbox@ics.uci.edu (Don Box) writes:
>
>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
>

Tom Lane at Cornell University is currently working on the documentation
for his set of TCP/IP externals.  The following message came through the
4D mailing list last month.

-Charles Albrecht   (charlesa@ncar.ucar.edu)

On the 4D mailing list, tcl1@popsrv.mail.cornell.edu (Thomas Lane) wrote:
>
> Date: Thu, 3 Dec 1992 17:40:07 -0500
> To: 4D@MIT.EDU
> From: tcl1@postoffice.mail.cornell.edu
> Subject: 4D & TCP/IP
> 
> I recently completed porting Apple's TCP/IP XCMD's to 4D.  Before I bundle
> the set of externals up and put them in a free archive, I want to know if
> anyone is interested in using them.  If you are, would you eMail me at
> 
> tcl1@popsrv.mail.cornell.edu
> 
> The response will give me a feel for what kind of documentation (if any) is
> warrented.  Thanks.
> 
> Thomas C Lane@popsrv.mail.cornell.edu  (..tcl)
> Analyst/Programmer
> Office Support Services
> Division of Information Technologies
> Cornell University
> Ithaca, New York, USA

--
To subscribe to the 4d Mailing list, post a message to 4D-request@mit.edu
    that includes your internet mailing address.  
To post a message to the list, send mail to 4D@mit.edu.  The message will
    be forwarded to the 200+ members of the list.
Newsgroups: comp.sys.mac.databases
From: ccetaneh@nuscc.nus.sg (Woppee)
Subject: Looking for a Mac database
Organization: National University of Singapore
X-Newsreader: Tin 1.1 PL4
Date: Sat, 9 Jan 1993 02:24:51 GMT


I am currently evaluating for a database that allows me to place a
background graphics as a template, import a photo(in PICT format) into it and
print to a LaserWriter with the person's particular on it.

I used FileMaker Pro 1.0v1 from Claris currently but we are not very
please with its speed performance.  I don't know if FileMaker Pro 2.0 is
any faster than version 1.0. Can anyone recommend a database program that
can suite our need? I would also be interested in reviews and comparison
notes of database on Mac, can anyone direct me to appropriate source. Many
thanks in advance.

Regards,
JEFF
Newsgroups: comp.sys.mac.databases
From: michaelh@Xenon.Stanford.EDU (Mike Hennahane)
Subject: Re: Looking for ideas on large mac databases
Organization: CS Department, Stanford University, California, USA
Date:  7 Jan 93 02:39:48 GMT

paulm@steelmel.bhp.com.au writes:
[...]
>Since we only report on historical data occasionally, I thought I would keep
>history on a tape, and copy it onto a disc when I need to use it.  I also
>thought I would keep a separate database for the most recent two years.
[...]
>But I was wondering if anyone has some thoughts on ways to manage historical
>data.  Sometimes I will want to report on time periods which overlap years
>(hence I have one big historical database instead of a few smaller ones-is it
>possible to overcome this difficulty in the new version of 4th dimension?). 
>Any ideas on managing large databases on a pc would be appreciated.  Also, any
>ideas on designing a faster database would also be of interest.

if the problem is that having the extra info around is confusing, then
you might consider archiving old data to another table of the database
instead of off onto tape. that way, you can still browse the old data
in the historical section, but you only have a more manageable amount
of current data in the current section. these two tables can have
identical structures, so that you can run reports from either one, or
you can implement an un-archive function to merge some/all of the old
data back in with the current data to run reports.

as for designing a faster database, that depends mostly on the quirks
of 4d (the obvious way is not always the best), on whether you have
compiled your database, or on whether you are running the new 4d
server software.

--mike

Newsgroups: comp.sys.mac.databases
From: charlesa@niwot.scd.ucar.edu (Charles Albrecht)
Subject: Re: FMP Custom Date Format Problem
Organization: Scientific Computing Divison/NCAR Boulder, CO
Date: Mon, 11 Jan 1993 21:40:30 GMT

In article <1993Jan10.234156.10100@colorado.edu> heuring@riker.cs.colorado.edu (Vincent Heuring) writes:
>
>I am trying to create a date field with a custom date format of the
>kind mm/yy, as in 12/92. I go to the date format in the format menu,
>and create a custom date that looks like: month /  year empty empty empty.
>But when I try to actually enter a date in that form, I get a dialog box
>that says
>
>	"The date in this field must have a valid date in the range of
>	years 1 to 3000, and should look like "12/31/92."
>
>Is this a FMP message, or a system message? The system date format
>does not allow a format of the form mm/yy. The day must always be
>present. Is this a FMP bug, or am I overlooking something?
>

This is a FM Pro message, but I believe it checks your system's international
settings to find the form that it expects.  Changing the Date format
as you describe will only change the way the data is displayed.  FM Pro
doesn't have input filters (unlike 4D).  The only thing FM is smart enough
to do is to add the current year if you leave it off.  So in your example,
it's assuming that you mean 12/92/93, which doesn't make any sense to it.

One way to simulate this is to use a Text field and a Date-Calculation field.
Your calculation would parse the text expression and add "one" for the day
of the month.  It would use the display option that you designed above.
In my opinion, this is a bit too much work.

-Charles
 charlesa@ncar.ucar.edu
From: tmyers@oucsace.cs.ohiou.edu (Tim Myers)
Newsgroups: comp.sys.mac.databases
Subject: Exporting ASCII text from Filemaker Pro
Date: 8 Jan 93 03:20:04 GMT
Organization: Ohio University CS Dept,. Athens

I have a question about exporting ascii-only text from FileMaker Pro
2.0 that I hope someone can help me with.

One of the databases I use frequently has information that I also like
to upload to online services as ascii text.  I have been able to develop
a script to locate and export only the text from a particular field, but
the text contains extra ascii characters that foul my upload. This is
text from a scrolling field that can be lengthy, and FMPro adds ascii
characters at each carriage return. I thought that tab-separated text
would be the best export format, but when I try "merge" or some of the
others, I get additional information, field names, quotation marks, etc.

Obviously I could manually copy and past the text from the field into
a word processor.  I can even send an Apple event to open my word 
processor and copy the field text, so all I have to do is paste it
into the word processor.  That saves a little time, but I'd rather just
export the text to a file and upload it later.

Am I missing something easy here?  I'd appreciate any advice.

Tim

-- 
Tim Myers                      
Ohio University             tmyers@oucsace.cs.ohiou.edu
Organization: Penn State University
Date: Fri, 8 Jan 1993 11:04:17 EST
From: Morris Weinstock <MAW14@psuvm.psu.edu>
Newsgroups: comp.sys.mac.databases
Subject: 4D Server Memory

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

Thanks,
Morris
From: paulm@steelmel.bhp.com.au
Newsgroups: comp.sys.mac.databases
Subject: Looking for ideas on large mac databases
Date: 7 Jan 1993 01:13:47 GMT
Organization: BHP Steel
Distribution: world
Reply-To: paulm@steelmel.bhp.com.au
NNTP-Posting-Host: 134.18.127.94

 I have a very large database which I am putting onto a Macintosh using 4th
dimension.  It is initially about 40-45 mb, and it will increase by about 250
mb when I get the historical data into it.  Thereafter it will increase at the
rate of about 45 mb per annum.

Now, I don't really need to keep the database on a mainframe, which is more
expensive (both in running costs and development costs) and takes longer to
develop the system.  Also, the time taken to run reports isn't really an issue.
 I am happy to set the reports off in the evening and pick them up the next
morning.

Nevertheless, I would like to keep the database as small and fast as possible. 
Since we only report on historical data occasionally, I thought I would keep
history on a tape, and copy it onto a disc when I need to use it.  I also
thought I would keep a separate database for the most recent two years.

But I was wondering if anyone has some thoughts on ways to manage historical
data.  Sometimes I will want to report on time periods which overlap years
(hence I have one big historical database instead of a few smaller ones - is it
possible to overcome this difficulty in the new version of 4th dimension?). 
Any ideas on managing large databases on a pc would be appreciated.  Also, any
ideas on designing a faster database would also be of interest.


Thank you for any assistance


Paul.
From: utleyc@ucbeh.san.uc.edu
Newsgroups: comp.sys.mac.databases
Subject: Filemaker Pro -- Good books?
Date: 8 Jan 93 03:47:54 EST
Distribution: world
Organization: Univ. of Cincinnati

Does anyone know of any good books for creating templates in Filemaker Pro 2.0?

Thanks in advance.
From: HUENSD@VAX1.BHAM.AC.UK (David Huen)
Newsgroups: comp.sys.mac.databases
Subject: Database recommendation
Date: 2 Jan 93 18:15:13 GMT
Organization: CRC Laboratories, Univ. of Birmingham
NNTP-Posting-Host: rincewind.can.bham.ac.uk
X-UserAgent: Nuntius v1.1.1d16
X-XXMessage-ID: <A76B8D2F07014006@rincewind.can.bham.ac.uk>
X-XXDate: Sat, 2 Jan 93 18:19:27 GMT

I am looking for a database that can be accessed by some means
programmatically from programs written in THINK Pascal. Its use is
primarily for storing genetic information on pedigrees so that it can 
be accessed to set up linkage analysis program runs.

Does one exist? Any suggestions appreciated. I have looked at Excel
and Filemaker Pro and they don't seem to do the job.

I am not a database specialist but can write most types of software.

Many thanks,

David Huen
Dept. of Cancer Studies
Univ. of Birmingham
e-mail: HUENSD@VAX1.BHAM.AC.UK
Newsgroups: comp.sys.mac.databases
From: jeffp@netcom.com (Jeff)
Subject: Re: 4D Check Boxes
Organization: BeHereNow
Distribution: usa
Date: Sun, 10 Jan 1993 01:03:58 GMT

I got it figured out here. 3.01 docs don't seem to spell it out very
well...

thanks,

Jeff-
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:03:01 GMT

-- 
Xref: sparky comp.sys.mac.databases:1695 comp.sys.mac.apps:19702
From: n3x092@rick.cs.ubc.ca (Geoff Lloyd Burian)
Newsgroups: comp.sys.mac.databases,comp.sys.mac.apps
Subject: Mapping software for Mac -- experience anyone?
Date: 11 Jan 1993 21:32:17 -0800
Organization: Computer Science, University of B.C., Vancouver, B.C., Canada
Distribution: world
NNTP-Posting-Host: gambier.rick.cs.ubc.ca

I am in the process of investigating software which can link address
information in a database with physical location on a map.  I would like
to use it to, given a list of addresses, show the locations of these
addresses on a map, and for each address, be able to determine the closest
location to it amongst a group of locations distributed throuout the map.
(For instance, given an address I would like to find the closest
restaurant to this address among a group of restaurants.)

I read the recent Byte article about mapping software (January 1992), and
noticed GeoQuery 3.0.  Anyone used it?  What types of things have you used
it for?  Is it fully programmable, along the lines of a high-level language
database (e.g. FoxBase, Omnis 7).

Any system that I would put into use would have to have data available on
Vancouver, B.C., Canada, the surrounding metropolitan area and it would
be good to have data for the whole of southern B.C. and Vancouver Island
as well.  Is there ANY mapping program for the Mac (or even, yuck, DOS)
that can be configured with detailed data from these areas?

Thanks if you can help me out.

Geoff Burian

-- 
===================================================================
Geoff Burian                   Computer Science Undergrad
n3x092@rick.cs.ubc.ca          The University of British Columbia
                               Vancouver, Canada
Newsgroups: comp.sys.mac.databases