HDTenEightyP/NetNews huggingface dataset:
From: hades@coos.dartmouth.edu (Brian Hughes)
Newsgroups: comp.sys.mac.databases
Subject: Re: FM XTND ?
Date: 28 Jan 93 16:12:48 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

mm5l+@andrew.cmu.edu (Matthew Mashyna) writes:

>I was looking at my old copy of FIle Maker Pro and I noticed a file
>called Claris XTND system. What is this ? Does it allow me to add
>external functions for FileMaker databases ? I'd use 4D but the printing
>is too slow for my application.

    The claris XTND system is a set of file translators that allow you
to import foreign file formats into Claris applications without needing
the application that created the foreign file. It's one of the nicer
ones around, and is also used by programs like Nisus.

-Hades
--
Newsgroups: comp.sys.mac.databases
From: michaelh@Xenon.Stanford.EDU (Mike Hennahane)
Subject: Re: 4D Field Incrementing
Organization: CS Department, Stanford University, California, USA
Distribution: usa
Date: 27 Jan 93 00:39:17 GMT

Matthew Mashyna <mm5l+@andrew.cmu.edu> writes:

>I'm not sure I fully understand what your trying to do. If you only need
>to assign a unique number to you clients starting with 1000 then why not
>use something like:

>[Clients]Client_Num:= sequence number([Clients]) + 1000

>The sequence number is always unique -- until it wraps bitwise.

but what if you are doing, say, invoice numbers and you don't want
gaps for invoices that are created but not saved?  (like a creation
loop where the last one is cancelled to end the loop).  it is a good
idea to have the flexibility to check what the next number is without
incrementing it (or to have the flexibility to reset the next number).

--mike
From: hades@coos.dartmouth.edu (Brian Hughes)
Newsgroups: comp.sys.mac.databases
Subject: Re: FM Pro 2 - Updating files from files
Date: 21 Jan 93 15:59:35 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

dremsen@mbl.edu (David Remsen) writes:

>Is there any way to automate this process? I guess the bottom line
>request is if there is any way to modify one filemaker file from within
>another?

    Well, you should be able to do it using Apple Events and have a
script in one file that opens the other file and performs a function. I
don't know how extensive you can be with the commands you want it to
process, but I do know that you could do this with Hypercard talking to
FM Pro using Apple Events. Take a look at the HC example that comes with
FM Pro 2.0.

-- 
-Brian V. Hughes 
"December 1 - What begins as a friendly transitional get-together between
 the Bushes and the Clintons ends in tragedy when Millie ralphs up what
--
-Brian V. Hughes 
"December 1 - What begins as a friendly transitional get-together between
 the Bushes and the Clintons ends in tragedy when Millie ralphs up what
 is later identified as Socks the cat." Dave Barry 1992 Year in Review
Newsgroups: comp.sys.mac.databases
From: lex@optimla.aimla.com (Lex van Sonderen)
Subject: What happened to reflex for the Mac?
Organization: Philips Interactive Media of America
Date: Tue, 26 Jan 1993 03:26:20 GMT

Does anyone know what happened to Reflex or Reflex Plus for the Mac?
Last sold by Borland.

I still like it, but the version I have Reflex Plus 1.01 is not 32-bit clean.

Thanx

Lex van Sonderen
Newsgroups: comp.sys.mac.databases
From: ebido@bio.vu.nl (Etienne Bido)
Subject: Filemaker network problems
Organization: VU Biology, Amsterdam, The Netherlands
Date: Tue, 26 Jan 1993 10:30:54 GMT

I've been having problems with Filemaker Pro 2.0x and an ethernet
network (7-8 Macs)

There is a main database on a server with several extra files
in the same folder which the main database uses for lookups.

If I go to, say Mac nr 1, and acces the main database then I have to
tell it where his lookup files are. I will tell him.

If I go to Mac nr 2, the same story, I show him where the lookup
files are and it works fine.

If I go back to Mac nr 1, it tells me again that it can't find 
the lookup files!!

What am I doing wrong?????
-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Etienne Bido			|| ebido@bio.vu.nl
Vrye Universiteit		|| bido@chem.vu.nl
Amsterdam    Holland
From: wsharif@informix.com (Wilson Sharif)
Newsgroups: comp.sys.mac.databases
Subject: Setting up print por  from a 4D application
Date: 20 Jan 93 23:28:10 GMT
Distribution: usa
Organization: Informix Software, Inc.
Originator: wsharif@conn-2


Hi,       

I have an application in 4D which requires to switch between two different.
printers. I do not want to use the chooser to set the printer; instead I 
would like to set the printer from 4D app. Is there a way I can do this?
Do I need to write an external to do this? If so, what do I need to do?


Thanks you very much,

Wilson Sharif            wsharif@informix.com
From: James.Mitchell@CoE.drexel.edu (James E. Mitchell)
Newsgroups: comp.sys.mac.databases
Subject: Re: FMPro Hints Database?
Date: 28 Jan 93 01:20:44 GMT
Organization: Drexel University
X-Xxmessage-Id: <A78CAD0FF7010CE6@n1-12-230-telecommunications-and-networking-group-development.ocs.drexel.edu>
X-Xxdate: Wed, 27 Jan 93 02:20:15 GMT
X-Useragent: Nuntius v1.1.1d13

Re: FMPro Hints Database?
In article <1993Jan26.103314.217601@bmug.org> , Dave_Burnett@bmug.org
writes:
>Do you want to know how to use FileMaker or how to create databases.  If
the
>latter, the databases Claris ships with FileMaker, if taken apart, are
pretty
>useful as examples...

I
self-referencing lookups effectively (my immediate concern) - or how to
implement a good security system when used on a network.
From: grub@bbs.draco.bison.mb.ca (Gordon Grieder)
Newsgroups: comp.sys.mac.databases
Subject: Re: Filemaker network problems
Date: Wed, 27 Jan 1993 13:44:02 GMT
Organization: The Draco Unix System [BBS]

hades@coos.dartmouth.edu (Brian Hughes) writes:

> ebido@bio.vu.nl (Etienne Bido) writes:

[stuff deleted]

> >in the same folder which the main database uses for lookups.
> >If I go to, say Mac nr 1, and acces the main database then I have to
> >tell it where his lookup files are. I will tell him.
> >If I go to Mac nr 2, the same story, I show him where the lookup
> >files are and it works fine.
> >If I go back to Mac nr 1, it tells me again that it can't find 
> >the lookup files!!
>
>     Wow. I don't think I have seen this problem before. Do you get the
> same messages when you use the files from the server itself? How are you
> accessing the database files on the server? Are you mounting it onto the
> desktop of the client mac as a fileserver or some other method?
> 

Are your lookup files non-exclusive?  I think that was the fix for a similar
problem we had.


+---------------------------+------------------------------------------------+
|grub@bbs.draco.bison.mb.ca :"...and I spake unto the prophet, 'Oh wise one, |
|          (Gordon Grieder) :show me the way that I might burden my computer |
|   in Winnipeg, MB, Canada :with the loads of twenty thousand camels!'  and |
|       (drinking his beer) :there was Windows..."          ---Grub 01:22:93 |
+---------------------------+------------------------------------------------+
From: grub@bbs.draco.bison.mb.ca (Gordon Grieder)
Newsgroups: comp.sys.mac.databases
Subject: Re: Exporting from FM Pro to other relational DBMS's
Date: Fri, 22 Jan 1993 12:23:11 GMT
Organization: The Draco Unix System [BBS]

hades@dartmouth.edu (Brian Hughes) writes:

> s914370@minyos.xx.rmit.OZ.AU (David Morrison) writes:
> 
> >The database will continue to grow to the extent of having 10,000 to
> >100,000 records stored in it. Now I'm under the impression that FM Pro will
> >not be able to search this size database very quickly (within 30 - 60 secs).
> 
>     Well, since FM Pro indexes all of its fields, including Calculation
> fields, this is probably a good impression to be under. How fast Fm Pro
> will perform the search will depend on 2 things: How fast your computer
> is, and how fast you access to the HD storing the database file is,
> obvioulsy if you are trying to do this kind of search over the network
> it will take longer. But it is important to remember that FM Pro is disk
> based.
> 

At my office, our main FM Pro db has just reached 70,000 records and 15 MB
in size.  We find that when a search includes a date field, multiple
requests, or will have a large amound of 'found' records it really bogs
the system down.  If you're lucky and your search will return a few hundred
(or just a handful) or records, FM Pro shines.

FYI-Main stuff on a IIci, being used by a handful of SEs and a dialup via
ARA.


#--------------------------------------------------------------------------#
|  grub@bbs.draco.bison.mb.ca (Gordon Grieder; Winnipeg, Manitoba, Canada) |   
              |
#------------------------------------------------------------------------- #
|  "Why do you think she is a witch?"   "Well she turned me into a newt!"  |
|  "A newt?"                            "I got better..."                  |
#--------------------------------------------------------------------------#
Newsgroups: comp.sys.mac.databases
From: schorsch@cheshire.oxy.edu (Brent William Schorsch)
Subject: CTree database engine
Organization: Occidental College, Los Angeles, CA.  USA
Date: Thu, 28 Jan 1993 20:30:01 GMT

someone mentioned before that they had problems with speed with CTree.
Can that person please give me some more information? Anyone else with
any experiences with c-tree is also requested to give me some detailed
impressions. We are considering making a desicion to go with this
product but we don't want to get stung...
The best way to reach me is by phone: 818-780-2220x115 (or give me 
your phone & I will call you.) 
otherwise try:
schorsch@oxy.edu
or
applelink: AFTERHOURS (ATTN:Brent Schorsch)
or on this group
thanks in advance!
-Brent

Newsgroups: comp.sys.mac.databases
From: aaron@noproblem.uchicago.edu (Aaron L. Bratcher)
Subject: FoxPro/Mac
Followup-To: comp.sys.mac.databases
Organization: University of Chicago
Date: Mon, 25 Jan 1993 14:13:52 GMT

Does anyone know if FoxPro/Mac is in beta yet?
Newsgroups: comp.sys.mac.databases
From: jak@panix.com (Jack Krueger)
Subject: Re: Databases from C or Pascal
Organization: PANIX Public Access Unix, NYC
Date: Sat, 23 Jan 1993 15:25:44 GMT

In <1993Jan23.000502.21026@enterprise.rdd.lmsc.lockheed.com> enterprise.rdd.lmsc.lockheed.com (Darrell Merrick) writes:

>In article <1993Jan22.141540.3712@unix.brighton.ac.uk>, pdt@unix.brighton.ac.uk (taylor) writes:
>> 
>> Does anyone know of a relational database package that can be accessed
>> from THINK C or pascal?
>> 

>You can call Oracle from Think C or Think Pascal (as well as MPW C and Pascal).
>This can be done by embedding SQL calls directly in your code.  This works
>much the same way as making regular SQL calls except you are tying Oracle 
>fields to variables in your program for the selection or insertion of data.  
>The embedded SQL calls are translated by an Oracle precompiler into a lower 
>level form which can be understood by the compiler.  Oracle for Macintosh 
>includes the precompilers and libraries for doing this.

>Oracle and 4th Dimension are the major database packages on the Mac right now.
>Oracle is the only one that is SQL-based.  4th Dimension cannot be called
>externally, but it has it's own internal language, similar to Pascal, for 
>processing. 


>Darrell Merrick
>Lockheed Artificial Intelligence Center
>merrick@titan.rdd.lmsc.lockheed.com

What about Omnis?
Newsgroups: comp.sys.mac.databases
Subject: Re: Databases from C or Pascal
From: stefan@stefan.spn.com
Date: Thu, 28 Jan 93 14:58:06 +0100
X-Mailer: rnMac Buggy, I mean Beta, Test Version


> In article <1993Jan23.000502.21026@enterprise.rdd.lmsc.lockheed.com>,
> enterprise.rdd.lmsc.lockheed.com (Darrell Merrick) wrote:
> > 
> > In article <1993Jan22.141540.3712@unix.brighton.ac.uk>, 
pdt@unix.brighton.ac.uk (taylor) writes:
> > > 
> > > Does anyone know of a relational database package that can be 
accessed
> > > from THINK C or pascal?
> > > 
> > 
> 

I missed the original Article, so maybe it's already been said:

Oracle (RDBM can be on local Mac or remote)

Stefan
From: mike_steiner@qm.claris.com (Mike Steiner)
Newsgroups: comp.sys.mac.databases
Subject: Re: Question on Lookup feature in FM Pro
Date: 25 Jan 93 22:44:38 GMT
Followup-To: comp.sys.mac.databases

In article <1jmjav$263@DIALix.oz.au>, dent@DIALix.oz.au (Andrew Dent)
wrote:
> 
> The biggest problem with lookups in FM Pro is that they are UNRELIABLE!!!!!
> 
> This (now that I've got your attention) stems from the matching of words.
> 
> eg: if file schools contains (IN ORDER)
>   St Columba's Primary School
>   St Columba's School
> 
> 
> then a lookup to schools of "St Columba's School" will return the FIRST
> of the entries.
> 
> So will a lookup like "School St".
> 
> The matching is to the first entry matching ALL the WORDS in the lookup
> field.
> 
> Be VERY careful about the implications of this one - I was hoping FM v2 would
> have a fix - it doesn't.

There really isn't anything to fix; it is a matter of interpretation.  When
you find "School St." you are looking for all records that contain "School"
and "St." in that field; you are not looking for the string "School St." in
the field.  It works as designed.

Now, whether that is the optimal design is another consideration.  One
possibility is to enhance the application by adding a metacharacter to
represent a space in a search.  I don't know whether the FileMaker team is
considering this, but I do know that some of them read this newsgroup.

+---------------------------------------------------------------------+
|                         Boycott Colorado                            |
|     These are my opinions, and not necessarily any one else's.      |
+---------------------------------------------------------------------+
From: hades@coos.dartmouth.edu (Brian Hughes)
Newsgroups: comp.sys.mac.databases
Subject: Re: Unique numbers in FMP
Date: 28 Jan 93 16:10:27 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

boz@coos.dartmouth.edu (John Boswell) writes:


>My problem is, that I would like any books in a specific category to
>go sequentially, i.e., SCI.400, SCI.401, SCI.401, etc.  As I have it
>set up, if I enter a SCI book, then a Biography, then a SCI book, I'd get:
>SCI.400, SCI.402  (since the biography would get BIO.401).  I can't set
>up separate "autoserial" number fields for each category, since they
>would ALL increment by 1 as soon as I create a NEW record.  Is there a
>way for me to do what I'd like?

    Well, I really don't think there is a way for you to get what you
want. The kind of thing that you want to do is usally accomplished, with
relational databases like 4D and Double Helix, but using a file that
contains your constants, like record numbers, which are accessed and
updated over the live relational link between the files. This is a
capability that FM Pro doesn't have. You might be able to simulate it
with Apple Events, but it would be a real nightmare.

-Hades
--
Newsgroups: comp.sys.mac.databases
From: mo@mg.stu.rpi.edu (Monish Gopinath)
Subject: Read if you work for the MIS dept.
Date: Wed, 27 Jan 1993 06:53:20 GMT

I am trying to get some information on the issue of security in a MIS  
department for a paper I'm writing.

	(1) Is security an issue?
	(2) Why or why not?
	(3) How is it addressed in the dept.?
	(4) How is it implemented?

If you can give me any other information related to security I would  
appreciate it.
P.S. Could you include the size of your MIS dept. and (if you don't mind)  
the name of the organization you work for. Thank you.

REPLY DIRECTLY TO mo@mg.stu.rpi.edu

Newsgroups: comp.sys.mac.databases
From: jeffp@netcom.com (Jeff)
Subject: 4D Auto Assign Related Value Ain't Workin!
Organization: BeHereNow
Date: Thu, 21 Jan 1993 08:16:28 GMT


Please appreciate this is almost a last resort and that I have read the
manuals and discussed this with ACI already. I'm hoping that someone can
help me with a question about automatic relations and auto assign related
values. I will keep it as simplified as I can:

I am creating a database for a Newsletter. I have two files, Clients and Ads.
Clients is the one file, Ads is the Many. Each Client can have many ads, only
one client per ad... simple.

Clients have a client number, and I use it as the relational field between the
two files.

Clients has an input layout with an included layout for Ads file. I understand 
that the auto assign features only work if you use command-tab, or Add To 
Included button. 

The Client field uses a #N to increment the field and assign an integer to it.
I have this only in the [Client]Client_Number layout field, not in the [Ads]
Client_Number field, since this value should be spawned once, then auto assign
ed to the related field in Ads;Clients, right?

So during data entry, I want to add a name and address in the client
input layout, then hit the Add to Included button and have the client 
number in the current 
record carry across to the new Ad record, but it is not being
carried across not matter how I try it. 

I have:
selected Relate One and Relate Many in the Relations dialog between the
two 
files, as well as the auto assign related value.

I have the [Ads]Client_Number Field in the Ads layout assigned to
[]Client_Number in the Field Dialog when I double click the 
[Ads]Client_Number field.

I have not used #N in the [Ads]Client_Number field, because I am
expecting this number to be auto assigned during data entry; carried
across from the [Clients]Client_Number field where the integer was
created.

This is supposed to work, but does not. Any ideas why?
I can't find an example database, tutorial, etc. that demonstrates
this!

(4d Tech sez, "well, then do it with a variable.")

If not, then how could I do this with a variable? 
If I don't do it with the correct proceedural controls, then [Ads]Client_
Number gets set to what ever the current record is, not what 
was in [Client]Client_Number when the record was created, and things 
get really hosed. I assume I would use a process varable?

Lost in CyberSpace,

Jeff-
Newsgroups: comp.sys.novell,bit.listserv.novell
From: scheidjs@mickey.informatik.uni-stuttgart.de (Johannes Scheidler)
Subject: Connecting UNIX from Novell ?
Organization: Informatik, Uni Stuttgart, Germany
Date: Thu, 28 Jan 1993 11:43:36 GMT

We need access to UNIX-Systems (SCO-UNIX, HP/UX) from Novell 3.11 .
There should be a terminal-emulation (ansi) with working Cursor-keys,
Function-keys, Num-Pad etc. . Also ther should be something like NFS, FTP,
remote printing and so on. When possible all features in both directions,
I mean from Novell to Unix as from Unix to Novell.

Does anyone have some experiences with the various Offers ?
Where are they strong or weak ?

Please mail me at

hannes%tuatara@Germany.EU.net 

Newsgroups: comp.sys.novell
From: erick@demorgan.uwaterloo.ca (Erick Engelke)
Subject: Re: LWP4.1 and XPC
Organization: University of Waterloo
Date: Thu, 28 Jan 1993 16:10:29 GMT

> dan@ortta.umn.edu (Daniel C. Cummings) writes:
>Has anyone using LWP 4.1 with the XPC program noticed that the server PC (
>the host with XPC loaded) must be at a DOS prompt for XPC to respond to an 
>incoming Telnet session?  Is there a way around this?  It would be nice to 
>be able to telnet to your office PC, start up a process (say a program 
>compile, or a large database sort), break the connection (Control-x, q) and 
>then be able to telnet in later to check on it's progress *while the program 
>is still running on the host PC*.  Or as another example, have an endless 
>loop batch file running on the host PC to always force the incoming telnet 
>session to a particular application.  But alas, when this is done, the 
>host PC acts like it's busy and won't respond.....
>
>Part of what I'm after could also be achieved if it was possible to tell 
>XPC to do some command upon a successful connection (like run a batch file) 
>or upon a broken connection (say...reboot the PC).....any Novellers out 
>there with any suggestions??

The third party product, Everywhere Access allows you to retelnet in,
or reboot on closure, or prevent future logins, and it has a user API
in case you want to execute things upon openning or closing sessions.
It works with LWP.

Contact info@snsi.com for details.


-- 
----------------------------------------------------------------------------
Erick Engelke				 	            WATTCP Architect
erick@development.uwaterloo.ca     TCP/IP was easy but i still can't work VI
Newsgroups: comp.sys.novell
From: dseeman@novell.com (Daniel Seeman)
Subject: Re: Netware UAM
Organization: Novell Inc., San Jose, Califonia
Date: Thu, 28 Jan 1993 17:24:38 GMT

In article <oconnor.1.728168185@dtmb2.dt.navy.mil> oconnor@dtmb2.dt.navy.mil (Judy A. O'Connor) writes:
>
>	Having a problem using the Netware UAM on a MAC running
>	system 7.0.1.  Using the ENCRYPT option when loading AFP.
>
>	Have only tested on 2 MACs, the first running System 7.0.
>	That works fine.  However on the 7.0.1 system, after selec-
>	ting the File Server from the Chooser, and after selecting
>	the Netware UAM method, the application at that point quits.
>
>	The regular AppleShare encrytion method works fine on both
>	MACs.  Have tried removing all inits and restarting.  Ran
>	a compatability check, which said nothing.
>
>	Any ideas?
>
>						THX in advance
>						JOC

Hi,

My guess is that you are using 32bit addressing.  If this is true, the symptom
you are seeing was a bug in the AppleShare workstation software.  That bug has
been fixed in System 7.1.  Please verify if this is the case by turning the
32bit addressing off.  If the chooser doesn't quit on you, then you have found
the problem.  In this event, please upgrade to System 7.1 (Macintosh OS).

If this is not the case, let me know and we can work on the problem more.

Think Peace...

Dan Seeman
Novell
Walnut Creek, Ca.

These suggestions and opinions are mine.  They are not necessarily Novell's.