HDTenEightyP/NetNews huggingface dataset:
From: triantos@netcom.Netcom.COM (Nick B Triantos)
Subject: Re: Searching for non-blanks while using a script in FMP2.0
Organization: Netcom Online Communications Service
Date: Mon, 28 Dec 1992 21:45:54 GMT

In article <1992Dec28.172331.7003@mnemosyne.cs.du.edu> mwgordon@nyx.cs.du.edu (Mike Gordon) writes:

>Is there a way to search for non-blank records in a script?  Actually,
>I need to search for records that are not blank in fields W, X, Y, or Z, but
>all records will have data in fields A,B,C, and D.

What you can do is to set up a calculation field that would be a small IF
statement for whether the fields are blank.  Here's a way to do it:
 If (W & X & Y & Z & "_" = "_", 1, 0)
This is the preferred way to test for a blank.  What we've just done is
concatenated all four fields together, and placed an underscore at the end
of the whole thing.  If that whole mess equals just an underscore, then we
know that the first four fields were blank.  You can now have your script
Perform a Find for any records with a 1 in this calculation field, and
you'll have all the ones with W, X, Y, and Z blank...

> I can't even figure out a way to get Filemaker to perform a search for 
>a pre-defined string when running a script.   There must be a way to do this, 
>because there are many applications I can see where you would want a button to
>find all occurences of something and print a report.

Set up a Find request exactly as you want the script to do the find.  Enter
the ScriptMaker, and add the "Perform Find" command, with the "Restore"
option on.  That should do it.

If you want to find a string that could be in any one of several fields, set
up your Find by placing the string in one of the fields, asking for a "New
Request", placing the string in the second field, adding a new request,
placing it in the third, and so on.  When you perform the find, FileMaker
Pro will find any records with the string in any one of the fields you
requested it look in.  New Requests in Find mode can be thought of as
analagous to the logical OR operation.

> Also, is there a way to make FMP2.0 print a report to a file instead of
>the printer?  I could save quite a few trees each month with this feature.

Not directly, but there's a great shareware program called Print2Pict that
gives you a chooser document to which you can print.  Print2Pict will create
PICTs, extract the text, create standalong postcards, and I believe there's
even more.  Check it out by FTPing it from your favorite Mac archive site,
such as mac.archive.umich.edu, sumex.stanford.edu, etc., or from America
OnLine.

-Nick "A moose once bit my sister" Triantos

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

Xref: sparky comp.sys.mac.databases:1637 comp.sys.mac.programmer:20397
From: rwt@stiatl.salestech.com (Roger Terrell)
Newsgroups: comp.sys.mac.databases,comp.sys.mac.programmer
Subject: Looking for cheap DB with ESQL
Date: 29 Dec 92 18:11:47 GMT
Organization: Sales Technologies, Inc.


I'm looking for a cheap database which supports embedded SQL.  The
compiler I'm using is Think C 5.0.1, on a Mac LC.

Alternatively, inexpensive ISAM file-access routines would work, too.

Does anyone know where I could get one or the other of these?

Thanks!

Roger
-- 
Roger Terrell
UUCP: ...!uupsi!stiatl!rwt
Internet: rwt@stiatl.salestech.com
Newsgroups: comp.sys.mac.databases
From: arie@eecs.umich.edu (Arie Covrigaru)
Subject: Re: In 4D I can only open one database at a time
Reply-To: arie@eecs.umich.edu
Organization: AI Lab, The University of Michigan
Date: Sat, 26 Dec 1992 19:18:51 GMT

>>>>> On 11 Dec 92 01:37:52 GMT, jas@ISI.EDU (Jeff Sullivan) said:

| In article <ARIE.92Dec3112408@quip.eecs.umich.edu> arie@eecs.umich.edu (Arie Covrigaru) writes:

|>Having used a Mac for a long time now, it seems to me that one of the
|>basic interface design considerations on the Mac is that applications
|>are able to open several "documents" at the same time. In 4D, the
|>equivalent of the document concept is a database. Why is it then,
|>that 4D is limited to opening only one database at a time. I am new
|>to 4D, so maybe this is true for other relational database management 
|>applications. What I do know that FileMaker Pro, for example has no
|>such limitation.
|>
|>There are many advantages to being able to open two or more separate
|>databases at the same time and I wonder if this limitation in 4D is
|>common in relational database applications or there is some other
|>specific reason for it in 4D.

| Try 4D 3.0; you can have multiple processes, each with their own file
| open, rnning simultaneously.  It's rather nice.

| jas
| --
| --------------------------------------------------------------------------
| Jeffrey A. Sullivan             | Research Scientist et al.
| jas@isi.edu (Internet)          | Information Sciences Institute
| 72511,402    (Compuserve)       | University of Southern California

I haven't upgraded yet to 4D 3.0 so I don't have the documentation.
Will you please elaborate on the processes and their own files?

Thanks,
--


Arie.

=========================================================================
| Arie Covrigaru                 |  University of Michigan AI Lab       |
| Phone: (313)994-8887           |  Room 149, Advanced Technology Bldg. |
| Internet: arie@eecs.umich.edu  |  1101 Beal Ave., Ann Arbor, MI 48109 |
=========================================================================
Newsgroups: comp.sys.mac.databases
From: mwgordon@nyx.cs.du.edu (Mike Gordon)
Subject: Do-it-yourself dialog-type boxes in FMP2.0 scripts?
Summary: I want to make some.
Organization: Nyx, Public Access Unix @ U. of Denver Math/CS dept.
Date: Tue, 29 Dec 92 21:50:05 GMT

 
     Is there any way to pop up a do-it-yourself dialog box in FMP2.0?  
I have a script that will only work correctly if the user selects a record to
start from (in a view as list type of layout) before running the script.
I'd like to put a message like "select a line to start from and push the OK 
button" at the begining of the script.   
     Because the script does a find / relookup, the results would be ugly if 
it occured on the wrong (older) records.
     Also, thanks to Nick and Laurie for their assistance on my previous 
question.

Mike Gordon  99681084@uwwvax.uww.edu
From: mdtaylor@apple.com (Mark Taylor)
Newsgroups: comp.sys.mac.databases
Subject: Inventory/Resource Management?
Date: 22 Dec 92 21:49:16 GMT
Followup-To: comp.sys.mac.databases
Organization: Apple Computer

Does anyone know of a simple, off-the-shelf solution that would be
appropriate
for inventory management?

This is for a situation where there are several hundred items that need to
be
checked out and/or reserved to be checked out by members of a group of
about
twenty people.  People in the group need to be able to see what items are
available for the time period when they would need it.

I guess this is very similar to running a library, except that reservations
need to be made for specific, non-overlapping time periods that can be up
to
several months in the future.

I had even thought about using Meeting Maker for this purpose, but there
must
be something a little better suited.  I don't want to spend the effort
creating
a full-blown relational database.

Thanks very much,
- Mark
Newsgroups: comp.sys.mac.databases
From: mccarty@vmser.enet.dec.com ()
Subject: Re: Odesta's Double Helix
Reply-To: mccarty@vmser.enet.dec.com ()
Organization: Digital Equipment Corporation
Distribution: usa
Date: Wed, 23 Dec 1992 22:21:43 GMT


A word from a programmer on Helix Express:

I have programmed in C, FORTRAN, COBOL, VAX MACRO-32 and I'm learning
the 680x0 assembler instruction set.

But I still enjoy Helix - just because it's object oriented doesn't mean
it's a wimp!  To me, it's a much more sensible than other packages that
require you to learn yet another "language"...

Just my $.02

			Bret McCarty
			Digital Equipment Corp
			Colorado Springs CO
Newsgroups: comp.sys.mac.databases
From:  (Steven E. Reiley)
Subject: Re: I'd like to know difference betwn. FileForce and 4D
Followup-To: comp.sys.mac.databases
Organization: Loral - WDL
Date: Tue, 22 Dec 1992 18:54:04 GMT

In article <1992Dec18.032744.13018@Princeton.EDU>,
bromwich@phoenix.Princeton.EDU (Adam Todd Bromwich) wrote:
> 
> 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

FileForce is basically a stripped down version of 4th Dimension.  It does
not support the full set of commands nor as robust a development
environment.  It was targeted at competing with FileMaker Pro.  Also, there
is no runtime version so each seat costs that same as the development
version.  There is also no compiler so you are always running interpreted.

This may be fine for a small database application and if you outgrow
FileForce, you can upgrade to 4th Dimension and not have to rewrite a
single line of code.  There is a converter application that converts
FileForce to 4D.

Steven E. Reiley
Newsgroups: comp.sys.mac.databases
From: brekshyn@shearson.com (Bohdan Rekshynskyj)
Subject: Re: Odesta's Double Helix and re:  LISTSERVER!
Reply-To: brekshyn@shearson.com
Organization: Ordinatio
Date: Wed, 30 Dec 1992 20:09:53 GMT

It's now Helix Tachnologies "Helix Express".  I have had it since 1984 and it is
the only database I'd recommend to my small-business clients, especially if they
want to maintain it in the future.  I've never had data problems and we're
talking eight years here!  As for technical support I have had no problems,
mirabile dictu!  Rumour has it that the "management" of Odesta just lost it
and ran aground - they ignored Helix in the end to concentrate on that
silly "Geo-query" product.  True, as in all things, there are problems
even now, but Helix has been around longer than any database product
for the Mac.  Also, its speed (I think MacWorld or MacUser) is faster than
other relational db's.

Furthermore - there's a(n?) HELIX LISTSERVER!

Contact Peter Yamamoto <pjyamamo@watdragon.waterloo.edu> for information on
how to subscribe.

				Regards,

				Bohdan
















=====================================================================
 
Bohdan Peter Rekshynskyj
 
Consultant                     
 
Compuserve:  72576.1754@compuserve.com


                              
All promulgations are my own.  No corporate entity has authorization
to represent me.
 
Imprimatur.						Nihil obstat.
 
=====================================================================
From: bernd@bcomp.hamm.sub.org (Bernd Hinkmann)
Newsgroups: comp.sys.mac.databases
Subject: 4D and Quicktime picts
Date: 23 Dec 92  19:22:00 +0100


If I use Quicktime picts in an 4D application, all is going well. I can show
them on the screen and I can print them on the screen. But if I print them
on a Laserwriter IIg (or GCC BLP Elite, that's the same), the picture (and
only that) is inverted! I ask the german ACI support, but they never heard
about such a problem.

Is anybody here, who can give a little hint?

Thanks in advance,

Bernd


--
** Bernd Hinkmann, Boenener Str. 42, 4703 Boenen, Tel. ++49-2383-5358 **
Newsgroups: comp.sys.mac.databases
From: thingles@xerxes.cs.umn.edu (Jamie Thingelstad)
Subject: FileMaker Pro 2.0 and Frontier 2.0 HELP!
Followup-To: thingles@xerxes.cs.umn.edu
Organization: University of Minnesota, Minneapolis, CSci dept.
Date: Thu, 31 Dec 1992 09:03:48 GMT


Anybody out there have experience with sending appleevents around
between FileMaker Pro 2.0 and Frontier 2.0.

I have these running on my FileMaker server and have Frontier backing
up all the databases every 60 minutes to a AppleShare server. I want
to have Frontier 2.0 set off certain scripts inside of my FileMaker
databases (e.g. scripts to Relookup every record, scripts to generate
weekly reports, etc...). Well,Ihave ran into a few snags with this.

   1. Turns out that FileMaker Pro will not do a script in any database
      except the frontmost database. So if I have script 'Relookup ALL'
      in database A, but database B is in the foreground, it wont
      execute.

   2. Also, FileMaker will not execute the script until it is
      brought to the foreground, a rather odd behaviour it seems
      to me. Dont understand it at all.


Sooo, to rememdy this I tried doing things like:

      sys.bringAppToFront ("FileMaker Pro")

and then sending the script, alas I couldn't get this to work... :(


Well, anyone with experience with FileMaker Pro <--> Frontier 2.0
that could help, I would be most indebted.

((Calling Claris Tech support tomorrow, maybe I'll talk to Nick.
Going to call UserLand tech support too.))

BTW - I fully recommend Frontier 2.0 to any net managers out there.
It is beautiful, has made my job much happier.

--
--

   _/_/_/_/ _/_/   _/  _/ _/ _/_/_/   Jamie Thingelstad               624-4037
      _/   _/  _/ _/_/_/ _/ _/_/      Technology Coordinator
Newsgroups: comp.sys.mac.databases
From: jhs@ipsa.reuter.com (Henri Schueler)
Subject: inside out ii
Organization: H&h Software, Toronto, Ontario
Date: Thu, 31 Dec 1992 22:25:37 GMT

We are planning to use Inside Out II as our DBMS. The overall application
has these characteristics:
	100 MACs - not connected to each other, but connected to
			a central vax.
	150 meg database on each mac, and a central copy in Oracle on
			the vax which will act as a data re-distributor.
	10 main tables, plus 50 that are basically static validation tables
	custom built everything (screens,reports) using MPW C. 
I'd appreciate any general comments on Inside Out, and any comments about its
suitability to the this project.

/jhs

p.s. is there a FAQ for this group? (I've been seen any lately.)
-- 
J. Henri Schueler, H&h Software, Toronto	+1 416 698 9075 
Newsgroups: comp.sys.mac.databases
From: geek@casbah.acns.nwu.edu (Myrland Gray)
Subject: Re: Odesta's Double Helix
Organization: Northwestern University, Evanston Illinois.
Distribution: usa
Date: Tue, 22 Dec 1992 22:36:20 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?

First of all, Odesta Corporation went out of business almost a year ago, and
the Double Helix product line was purchased and a new company called Helix
Technologies was started to continue to support and develop Double Helix. Just
recently, the next generation of Double Helix (called "Helix Express") was 
released which included all sorts of new features (that I won't go into now)
and some much-needed bug fixes.

Now that that's cleared up...my comments about Helix. Don't bother. Helix can't
do anything that any (if not every) other Mac database can't do. Much (~50%) of
Helix's source is almost 10 years old and completely unintelligible to humans.
As more and more changes happen in the Machintosh world, Helix gets further and
further out of date - with little or no chance of ever catching up. The 
management at Helix Technologies can't seem to grasp the concept that the world
around them is changing and they need to take their blinders off and at least 
try to get back in the race. 

Joey Gray
geek@casbah.acns.nwu.edu

PS - If you couldn't tell, I have a disliking of the company because of the way
I was (and still am) treated. I used to work on Helix, both before and after 
Odesta went down in flames. Never have I seen a more talented, yet severly
misguided group of individuals.

Newsgroups: comp.sys.mac.databases
Newsgroups: comp.sys.mac.databases
Distribution: world
From: Dave_Burnett@bmug.org
Organization: BMUG, Inc.
Date: Sun, 20 Dec 1992 23:50:59 PST
Subject: Re: More choices on expanding/shrinking views in FMPro?

Franklin P. Burdette,fburdette@worldbank.org,Internet writes:

		>Has anybody figured out a way to view layouts in more ways that
 	>FM Pro allows (i.e. 50%, 100%, 200%, ...). Being able to view
		>layouts at 133% is the goal. Thanks for any suggestions!

Sorry, FileMaker does not support percent of original viewing other than the
built in options. 

--Dave Burnett You can, however, print out your documents at any 

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

Newsgroups: comp.sys.mac.databases
From: drabe@uunet!tellab5!odgate (Daniel Rabe)
Subject: Re: Odesta's Double Helix and re:  LISTSERVER!
Keywords: n
Organization: Odesta Systems Corporation, Northbrook IL.
Distribution: usa
Date: Sat, 2 Jan 1993 18:22:08 GMT


In article <1992Dec31.165918.19645@news.acns.nwu.edu> geek@casbah.acns.nwu.edu (Myrland Gray) writes:
>Actually, it's Helix Technologies. Future? Helix? *hack* --cough-- (*&^*%*&
>NOT! Helix is bound to die a quick and painful death (IMHO) in the not too
>distant future.

What I hear Joey saying is that the code is old and unpleasant to
work with, and that, therefore, the product will die.  If you use
this argument, then you'll have to give up a lot of other software
(like Unix, maybe)!  Just because code is challenging to work with
doesn't mean you can't maintain and enhance it.  One of the difficulties
of being an engineer is that you know all the weak points of a technology.
It's refreshing to hear success stories about how people are actually
making use of the technology to do real work.

The other key point that Joey hits on is what management decides to
do with the technology and the product.  Any technology-based
company has to make difficult tradeoffs about whether to give the
customers what they ask for (assuming the customer is always right),
or to figure out what the customer needs (assuming the customer
is always wrong).  It has been my experience that the Helix gurus
have always placed an emphasis on figuring out how to give the
customer functionality that fits into the Helix system with maximum
internal consistency.  IMHO, that has led to a very consistent
product that doesn't have all the expected features.

Joey describes the other Odesta product as
>...(essentially a mac
>front end to a mainframe database).

I think what he's referring to is what we now call "Open ODMS", which
is much more than a front end to a database.  At Odesta Systems
Corporation, we develop client-server technologies to provide
document management and workflow management solutions.  We
chose an open client-server configuration using standard SQL databases
(like Sybase and Rdb) because we recognized that customers don't
always like having their data in a closed, proprietary system.  Our
client software ("design mode" as well as end-user) is written to
be portable across Mac, Windows, and Motif platforms.

--daniel rabe
(helix programmer in a previous life)

Disclaimer: I speak only for myself, and do not represent Odesta,
Odesta Systems, or Helix Technologies.

Newsgroups: comp.sys.novell
From: jc@i5120h.nrl.navy.mil (J. Clark)
Subject: Searching documwnts for key words
Organization: NRL
Date: Mon, 28 Dec 1992 15:41:32 GMT

Happy Holidays all !

I'm looking for a piece of software that can search through documents
on a LAN, looking for key words.  Suppose users need to find
all docs that contained the words 'NOVELL NETWARE'.  I could 
enter it in and let the software go looking.  It would be ideal
to be able to setup predefined paths, etc.

Does anyone have any thoughts or experiences ?

Thanks
John  jc@i5120h.nrl.navy.mil
From: donp@novell.com (don provan)
Newsgroups: comp.sys.novell
Subject: Re: Alarming Server Stats ???
Keywords: NE2000
Date: 21 Dec 92 07:16:49 GMT
Organization: Novell, Inc., San Jose, California

In article <1992Dec20.035057.8853@ncsu.edu> ashah@eos.ncsu.edu (AJAY  SHAH) writes:
>Pkts. sent		11,384,917			11,307,471
>EnqueuedSendsCount	159,077 (!!!)			107,689 (!!!)
>
>Do I need to re-boot the server (i.e bring it down) so that the buffers
>are cleared or is ther no need for alarm at all ???

It's perfectly normal.  That statistic is counting the number of times
a send was in progress when an additional send was attempted.  The
second send needs to be queued up, but as soon as the first send
completes, the second send is removed from the queue and transmitted.
A number like yours, one percent of all the packets sent, is typical.

						don provan
						donp@novell.com
Newsgroups: comp.sys.novell
From: buhr@umanitoba.ca (Kevin Andrew Buhr)
Subject: Re: OS/2 Requester
Organization: University of Manitoba, Canada
Distribution: us
Date: Wed, 23 Dec 1992 04:25:00 GMT

In article <BzoszL.BF4@constellation.ecn.uoknor.edu>
jodsmith@essex.ecn.uoknor.edu (John Doug Smith) writes:
|
|	   I have seen some one posted a question about the OS/2 requester,
|  I think the question was "does the OS/2 requester come with Novell?".
|  Well I just received version 3.11 of this very poor network OS and yes
|  it did come with the OS/2 requester.

[ lots of shots at Novell deleted ]

Look on the bright side.  Netware is so light weight (read "brain
dead") that somebody (but not Novell) will eventually write a
completely bug-free Netware server implementation in Z-80 assembly
language that fits in 32K of memory.  Finally we'll have use for those
old TRS-80's!

Kevin Buhr <buhr@ccu.UManitoba.CA>
Newsgroups: comp.sys.novell,bit.listserv.novell
From: ccksb@trentu.ca (Ken Brown)
Subject: Re: NOT-LOGGED-IN   - Getting rid of.
Keywords: Connections Zapping not-logged-in
Organization: Trent University, Ontario
Date: Tue, 22 Dec 1992 16:18:20 GMT

I second the request for Novell to release the NLM mentioned below...

>>We have several 3.11 servers that get choked up with NOT-LOGGED-IN "users"
>>so the real people can't get in. Could some kind person please enlighten me
>>what the solution to this is and be it an NLM where to find it.
>>
>
>There is an NLM out there that comes with Runtime Netware (1 user) 3.11.  Maybe
>Novell will be kind enough to release it to the general public.  I know it comes
>with SAA for Netware (or was that SNA).  It is a program which will clear
>"NOT-LOGGED-IN" connections after a set period of time.
>
>Later,
>-- 
>John Villalovos
>Certified Netware Engineer
>villalj@xanth.cs.orst.edu
>(503) 753-7883


-- 
Ken Brown                                   internet: kbrown@trentu.ca
Trent University Computing & Telecommunications  tel: (705)748-1540
Peterborough, Ontario, Canada, K9J 7B8           fax: (705)748-1246 
Newsgroups: comp.sys.novell
From: ccksb@trentu.ca (Ken Brown)
Subject: Re: Searching documwnts for key words
Organization: Trent University, Ontario
Date: Sat, 2 Jan 1993 18:42:11 GMT

In article <Z7FkwB1w165w@actrix.co.at> paul@actrix.co.at (Paul Gillingwater) writes:
>jc@i5120h.nrl.navy.mil (J. Clark) writes:
>
>> on a LAN, looking for key words.  Suppose users need to find
>> all docs that contained the words 'NOVELL NETWARE'.  I could 
>> enter it in and let the software go looking.  It would be ideal
>> to be able to setup predefined paths, etc.
>
>Two products spring to mind: high end, expensive TOPIC or networkable
>DOS-based ISYS.  Sorry, don't know vendor addresses.
>
>--
>paul@actrix.co.at (Paul Gillingwater)
>Home Office in Vienna, Austria

What about the Norton Utilities?  The utility ts (text search) will do
this for you.  There's a variety of other great utilities with it.  I
think Norton is now produced by Symantec (spelling?).

Hope this helps...

-- 
Ken Brown                                   internet: kbrown@trentu.ca
Trent University Computing & Telecommunications  tel: (705)748-1540
Peterborough, Ontario, Canada, K9J 7B8           fax: (705)748-1246