HDTenEightyP/NetNews huggingface dataset:
From: bronson@latech.edu (Patrick K. Bronson)
Subject: Re: 4th Dimension
Organization: Louisiana Tech University
Date: Thu, 1 Oct 1992 15:36:48 GMT

In article <2AC9F757.10648@news.service.uci.edu> pamiri@uci.edu (Peter Amiri) writes:
>In article <1992Sep29.173729.5267@engr.latech.edu>, bronson@latech.edu (Patrick K. Bronson) writes:
>> 
>> In article <2AC777D1.25942@news.service.uci.edu> pamiri@uci.edu (Peter Amiri) writes:
>> >In article <welVaA_00WBKI38VQ9@andrew.cmu.edu>, jh62+@andrew.cmu.edu (Jason Andrew Herman) writes:

>> >In the current version there is no way of deleting fields and files but you 
>> >should be able to delete layouts, and golbal procedures. In the desing 
>> >environment select layouts (command-L) and click on the layout you wish to
>> >delete, then click on the delete button. The same holds tru for procedures. 
>> >
>> >Peter Amiri
>> 
>> The exception to this is when the layout is either the default input or 
>> output.  You can't delete it until it is no longer  one of the defaults.
>> 
>> -- 
>> -----------
>> Pat Bronson (bronson@engr.latech.edu)
>>   "Are you going to come quietly or do I have to use earplugs?"
>>                                                     ---- From The Goon Show
>> 
>> 
>This is very true Pat, thanks for pointing it out. Its the little things that 
>become second nature to you after a few years and you forget that you are
>actually doing them.
>
>Peter Amiri

So very true.  Sadly, 4D has so MANY little things that sometimes it's
a wonder things run the same way from day to day! :-)

-- 
-----------
Pat Bronson (bronson@engr.latech.edu)
  "Are you going to come quietly or do I have to use earplugs?"
                                                    ---- From The Goon Show
Newsgroups: comp.sys.mac.databases
From: fstiva@cs.vu.nl (Stiva F)
Subject: Omnis 7 & XCMD's
Organization: Fac. Wiskunde & Informatica, VU, Amsterdam
Date: Tue, 29 Sep 1992 08:36:09 GMT

Hi,

Does anyone know the format of Omnis 7 XCMD's?
The Omnis 7 kit does not include any information about XCMD's
What header file do I use, preferably for MPW?
Is there an example with source?

Thanks in advance.

Fulco Stiva

---------------------------------------------------------------------
Fulco Stiva (fstiva@cs.vu.nl)
Paedologisch Instituut Amsterdam
Rijkstraatweg 145
1115 ZG  Duivendrecht
The Netherlands
----------------------------------------------------------------------
Newsgroups: comp.sys.mac.databases
Distribution: world
From: Michael_R._Schumann@bmug.org
Organization: BMUG, Inc.
Date: Thu, 01 Oct 1992 09:39:59 PDT
Subject: Re: Minimum hardware for 4D???

> The main problem we're trying to solve is SPEED.  It takes forever to
get into
> the database  (> 10 minutes) since everything is being run across the
network 
> and changing files within the database is also incredibly slow (> 3 minutes).
 
>
> Here's my current suggestions:
>
> 1.) more memory in every machine (4MB in each?)
> 2.) hard drives for the two machines that don't have them (40MB
enough?)
> 3.) different development shell (Easy4D?)
> 4.) different network software?
> 5.) faster CPU's (can't afford)
> 6.) ethernet (can't afford)
> 7.) 4D Compiler (can't afford)
> 8.) 4D Server (can't afford)

First thing to do would be hard drives. You can then put the structures
onto each machine, reducing much of the network traffic. Memory will
also help if the structure is large; also try playing with customizer
and the partitions within 4D.

Don't rule out 4D Server. With the expected upgrade policy, the Server
will cost about $750 :(. A lot of money, but really the easiest solution
to multiuser woes.

There is also a lot that can be done with the database design to help
with multiuser. Avoid automatic relations, so related files aren't searched
and transfered across the network, except when needed. Try copying data
into arrays and using the third party product AreaList to display them
as if they were an output layout.

Good luck,

Michael Schumann

***************************************************************************
             From Planet BMUG, the FirstClass BBS of BMUG, Inc.
              The above message was gatewayed via PostalUnion
***************************************************************************
The message contained in this posting is entirely the poster's personal
opinion.  Any possible, real or perceived, (dis)similarities with the
views held by BMUG, are purely coincidental.
***************************************************************************
Newsgroups: comp.sys.mac.databases
From: daniel@lamont.ldgo.columbia.edu (Dan Quoidbach)
Subject: FileMaker Pro & Word mail merge?
Followup-To: comp.sys.mac.databases
Organization: Ocean Drilling Program/LDGO
Date: Thu, 1 Oct 1992 13:55:09 GMT

Can FileMaker Pro export files in a format that can be used by Word 5
as a mail merge file? If someone is doing this, could you please let
me know the proper technique? Thanks!


Dan Quoidbach                               daniel@lamont.ldgo.columbia.edu
Ocean Drilling Program
Lamont-Doherty Geological
Observatory
Palisades, NY 10964
Newsgroups: comp.sys.mac.databases
From: davids@gardener.lanl.gov (David G. Simmons)
Subject: Re: FileMaker Pro & Word mail merge?
Originator: davids@feynman.lanl.gov
Organization: Los Alamos National Laboratory
Date: Thu, 1 Oct 1992 21:08:40 GMT


In article <1992Oct1.173527.25664@dartvax.dartmouth.edu>, hades@coos.dartmouth.edu (Hades) writes:
|> daniel@lamont.ldgo.columbia.edu (Dan Quoidbach) writes:
|> 
|> >Can FileMaker Pro export files in a format that can be used by Word 5
|> >as a mail merge file? If someone is doing this, could you please let
|> >me know the proper technique? Thanks!
|> 
|>     When you perform an expost in FM Pro, it asks you what format to
|> use, and gives you a pop-up menu. One of the formats on that menu is the
|> Merge type, which is exactly the format that Word uses for print merge.
|> 
|> --
|> -Hades (Brian V. Hughes) 
|>    "You know Television has gone to hell when, with every commercial,
|> 	 you find yourself hoping to see the Energizer Bunny."

Just don't get bitten by the bug.  Remember that, upon opening the "Export"
dialog, you have < 2 seconds to select from the pop-up menu before it
freezes and won't let you play.  Very frustrating until some KIND soul
posted here about it.  I thought I only had the choice of "Tab Delimited Text"
for the longest time ;-)
-- 

David G. Simmons
	
	"Pollution is not the problem with our environment. 
	It is the impurities in our air and water." 
		--Dan "Vice-President-Rain-Man" Quayl(e)

If I said it, LANL didn't... 

-- 

David G. Simmons
	
	"Pollution is not the problem with our environment. 
Newsgroups: comp.sys.mac.databases
From: Simon_Kok@mindlink.bc.ca (Simon Kok)
Newsgroups: comp.sys.mac.databases
Subject: InsideOut Database Routines
Date: 28 Sep 92 03:12:55 GMT
Organization: MIND LINK! - British Columbia, Canada
Distribution: world

Can somebody please tell me how well these database routines work?  I have an
opportunity to upgrade an old version of InsideOut by Sierra Innovations.

Thanks in advance!

Cheers!
From: rajiv@athena.mit.edu (Rajiv A Manglani)
Newsgroups: comp.sys.mac.databases
Subject: FileMaker Exports
Keywords: FileMaker Macintosh
Date: 30 Sep 92 21:26:39 GMT
Article-I.D.: athena.1992Sep30.212639.15080
Organization: Massachusetts Institute of Technology

I have a database of names and Email address. Is there an easy way to get
something like this from FileMaker 2.0:

user@host                       # first_name last_name
user@host                       # first_name last_name
user@host                       # first_name last_name
user@host                       # first_name last_name
user@host                       # first_name last_name
user@host                       # first_name last_name
user@host                       # first_name last_name


any ideas? i need it to put in the spaces, or tab, and the "#".

Please email the response...

Thanks,
Rajiv
From: pamiri@uci.edu (Peter Amiri)
Newsgroups: comp.sys.mac.databases
Subject: Re: Quicktime with 4D ??
Date: 28 Sep 92 21:18:40 GMT
Organization: Dimensional Software

In article <25SEP199213290737@rosie.uh.edu>, englhq@rosie.uh.edu (Franklet, Duane L.) writes:
> 
> Has anyone had experience using QuickTime with 4D? What externals
> do I need to do this, and where can I get them?
> 
> Thanks,
> 
> Duane Franklet
> englhq@jetson.uh.edu
> 
> 
I beleive ACIUS has the quicktime externals and from what I have heard it
is actually very nice. You should be able to find out from them if they
don't have it who actually does. 408/252-4444.

Peter Amiri
From: pamiri@uci.edu (Peter Amiri)
Subject: Re: 4th Dimension
Newsgroups: comp.sys.mac.databases
Organization: Dimensional Software
Date: 30 Sep 92 18:52:08 GMT

In article <1992Sep29.173729.5267@engr.latech.edu>, bronson@latech.edu (Patrick K. Bronson) writes:
> 
> In article <2AC777D1.25942@news.service.uci.edu> pamiri@uci.edu (Peter Amiri) writes:
> >In article <welVaA_00WBKI38VQ9@andrew.cmu.edu>, jh62+@andrew.cmu.edu (Jason Andrew Herman) writes:
> >> 
> >> Hello Everyone,
> >> 
> >> I am new to this b-board so please bear with me.
> >> I am currently using 4th Dimension.  The main problem I am experiencing
> >> is deleting my mistakes (namely tables, fields, layouts, etc).
> >> Does anyone know how to accomplish this as I certainly do not.
> >> 
> >>                 Thanks in advanced,
> >> 
> >>                     Jason Herman
> >> 
> >> 
> >In the current version there is no way of deleting fields and files but you 
> >should be able to delete layouts, and golbal procedures. In the desing 
> >environment select layouts (command-L) and click on the layout you wish to
> >delete, then click on the delete button. The same holds tru for procedures. 
> >
> >Peter Amiri
> 
> The exception to this is when the layout is either the default input or 
> output.  You can't delete it until it is no longer  one of the defaults.
> 
> -- 
> -----------
> Pat Bronson (bronson@engr.latech.edu)
>   "Are you going to come quietly or do I have to use earplugs?"
>                                                     ---- From The Goon Show
> 
> 
This is very true Pat, thanks for pointing it out. Its the little things that 
become second nature to you after a few years and you forget that you are
actually doing them.

Peter Amiri
From: MARKROSE@MSU
Newsgroups: comp.sys.mac.databases
Subject: FMPro v2.0 & Report Card Example ?
Date: 3 Oct 92 15:10:03 GMT
Organization: Michigan State University


  Is anyone else having problems with the apple events example file
  AE-Report Card file and corresponding hypercard stack. After messing
  aound with the stack's script, it seems that the function MakeAppAddr
  creates a path "*::Filemaker Pro" to be used as the Target in AE calls
  but this results in an error, however when I hard code in "Filemaker
  Pro" for the var theAddress it works okay.  Any clues about  what is
  going on ?  Also what is The Address function return in hypercard ?

    Mark Rosenberg
    Michigan State University
Newsgroups: comp.sys.mac.databases
From: gnat@stein.u.washington.edu (L Boyd)
Subject: Re: 4D Reports
Organization: University of Washington
Date: Fri, 2 Oct 1992 22:55:30 GMT



David -

[You're going to hate me!] Look at your code first -- if there is a
problem, it's usually with the code,*especially* when trying to write
a report (because it's so confusing).

One technique that I use is to import into a file that is reserved for
imports -- all the fields are strings of 80 (unless you've got strings
that are larger, then I throw in a text field or two).  From there, I
am able to format data (strip characters, convert to upper/lower case,etc.)

THEN I put the data into its appropriate field.  Call me paranoid, but
it works well, and I make sure that the data gets in the right place.

Lauren

Organization: Senior, Social & Decision Sciences, Carnegie Mellon, Pittsburgh, PA
Newsgroups: comp.sys.mac.databases,cmu.comp.sys.mac
Date: Tue, 29 Sep 1992 03:11:52 -0400 
From: David Tsai <dt1n+@andrew.cmu.edu>
Subject: 4D buttons

Hello,
    Does anyone know how to make the buttons [active objects] look like
a real object.  [ie., toolbox, computer, etc.]  I hate having a plain
oval button.  I 
want to make the buttons look like something like Hypercard or FileMaker 
Pro.  Is this possible?  I was told that anything could be done with 4d.
I'm even willing to try Resedit.

Dave

Newsgroups: comp.sys.mac.databases
From: ST25370@VM.CC.LATECH.EDU
Subject: Re: 4D Reports
Organization: LOUISIANA TECH UNIVERSITY
Date: Mon, 05 Oct 92 07:55:56 CST

In article <gen9fEi00WBOE4dYlw@andrew.cmu.edu>
David Tsai <dt1n+@andrew.cmu.edu> writes:
 
>
>   Oh Boy!  I've got another problem.  I imported that data from FM Pro.
>I've checked to make sure that the right fields are recieving the correct
>data.  After all my careful work, I believe that I have all the data that
>I want in the 4d database.
>    BUT, when I generate a report with all the data, IT IS MISSING the data
>from many of the fields!!!!  I look at the tables and they are
>there but when I generate a report to the screen or print it out, the data
>is missing [randomly...not set pattern].
>
>What's going on here?  Is this an incompatiblity of 2.0.1 with system 7?
>Or is it that this version of 4d is buggy?
>I can't give this system to my client.
>It's no good if she gets some of the data that she wants some of the
>time.  Help????
>
>Dave
 
Can you okease be more specific?  How are you looking at the tables to
verify that the data exist?  How are you generating the reports (s) that
are not functioning properly?  How familiar are you with 4d, and what have
you tried to do to remedy this?
 
Are the missing data in the detail area of the layout?  Are you generating
a report with break processing activated?  Are you having trouble with a
subfile?
 
I've had horrible experiences with 4d when importing data...  Most related
to 4d not importing fields containing null strings properly.
 
More specific information would really help us help you.  Examples of the
relevant code and description of the relevant structure and layout(s) might
be a good start, as well as how you imported the data, and how you exported
it from FM.
 
 
Bill
st25370@vm.cc.latech.edu
rwj@engr.latech.edu
.
From: S_HARASTA@V1.BARTS.LON.AC.UK
Newsgroups: comp.sys.mac.databases
Subject: hunting for MELBOURNE
Date: 6 Oct 1992 20:06:08 -0500
Organization: UTexas Mail-to-News Gateway
NNTP-Posting-Host: cs.utexas.edu

We are desperately looking for a font called MELBOURNE and would
greatly appreciate any information about where and how to get it.
Please write directly to me to s_harasta@v1.barts.lon.ac.uk 
Since I might have occasional difficulties in accessing my mails,
I would ask you to be so kind to repeat your message to
peter@psy.oxford.ac.uk if you would not get an acknowledgement
reply from me. 
Thank you very much, sandor
Newsgroups: comp.sys.mac.databases
From: michaelh@Xenon.Stanford.EDU (Mike Hennahane)
Subject: Re: 4D Receive Record Command
Organization: CS Department, Stanford University, California, USA
Date: 28 Sep 92 22:08:28 GMT

sandrov@vxcrna.cern.ch (VENTURA,SAND./EP) writes:

>I'm experiencing some troubles with the Receive Record command:
>I can't avoid it to create a new record each time it executes, despite what
>stated on the manual which says that a record can be received in the current
>record.

the manual says that you must create a *new* record for the file
before you do a 'receive record.' i don't think that you can receive a
record into the current record.

>What am I missing? Any help or more general suggestions on how to transfer
>records between separate databases?

are you transferring new records, updating existing records, or both?

--mike
From: jh62+@andrew.cmu.edu (Jason Andrew Herman)
Newsgroups: comp.sys.mac.databases
Subject: 4th Dimension
Date: 27 Sep 92 12:29:00 GMT
Article-I.D.: andrew.welVaA_00WBKI38VQ9
Organization: Senior, Social & Decision Sciences, Carnegie Mellon, Pittsburgh, PA

Hello Everyone,

I am new to this b-board so please bear with me.
I am currently using 4th Dimension.  The main problem I am experiencing
is deleting my mistakes (namely tables, fields, layouts, etc).
Does anyone know how to accomplish this as I certainly do not.

                Thanks in advanced,

                    Jason Herman
Newsgroups: comp.sys.mac.databases,cmu.comp.sys.mac
From: bronson@latech.edu (Patrick K. Bronson)
Subject: Re: FAQ?
Keywords: 4D
Organization: Louisiana Tech University
Date: Mon, 28 Sep 1992 19:34:46 GMT

In article <IekfBXu00Uh7Q_EEdp@andrew.cmu.edu> dt1n+@andrew.cmu.edu (David Tsai) writes:
>Hi again,
>    I'm sorry to ask another question [I'm hogging up bandwidth :} ].
>
>I am converting a FileMaker Pro 1.0 database into a 4D relational database.
>The version of 4th DIMENSION I am using is 2.0.10.  The "About 4th
>DIMENSION" in the apple menu says that is a single-user configuration.  
>    My boss wants me to set the new database up so that people can login
>and access the information from any MAC on our network.  The MAC with
>the database will be located in her room, but the information needs to
>be accessed at various locations.  Since this is a single-user
>configuration will I be able to do this?

First of all you will need a copy of the 4D runtime (or the full version of
4D) on each machine that you are going to run your database clients.  Second
you will need a way of letting others log onto the Mac where the database is
going to reside.  To switch to multiuser, hold down the mouse button after
you launch 4D and wait for a dialoge to come up that has some options on it.
One of the options is to use multiuser or single user mode.  Change it to
multiuser.  Anyone who attempts access the database in singleuser mode AFTER
others connect will get an error -54 message (very confusing if you don't
happen to know the error codes right off).  

>I don't think our version of 4D can do this. If I can't, how can I get around
>this?

The most recent version of 4D (not counting 3.0) is 2.2.3.  You really ought to
get yourself upgraded to that version.  We have encountered far fewer problems
using it (as opposed to a few earlier releases).

>    If someone has the time, could they explain to me the difference between
>single-user, multi-user, client, server, driver and engines?  [They
>never taught this to me in class and I don't know where else I am going
>to find info on this.]  All information will be greatly appreciatedd. 
>Thanks everyone.
>
>Dave
Single-user: one person access the database at a time.  Faster than multi-user
	     under 2.x.x.
Multi-user : Multiple people can access the same database (from a server
	     or someone sharing his/her volume via file sharing).  Can be
	     really slow depending on the application.  Calls for really
	     well written code.
Client     : An application that connects to a database engine to access
	     the data.
Server     : A program that controls the information sent to and from a data-
	     base. (Finally available in 3.0)

-- 
-----------
Pat Bronson (bronson@engr.latech.edu)
  "Are you going to come quietly or do I have to use earplugs?"
                                                    ---- From The Goon Show
Newsgroups: cmu.comp.sys.mac,comp.sys.mac.databases
From: ST25370@VM.CC.LATECH.EDU
Subject: Re: 4D buttons
Organization: LOUISIANA TECH UNIVERSITY
Date: Wed, 30 Sep 92 08:11:38 CST

In article <EemF2Ta00WBO48NGQ_@andrew.cmu.edu>
dt1n+@andrew.cmu.edu (David Tsai) writes:
 
>
>But, there is this weird bug I get when I make a variable to display the page
>using a active object.
>
>The script was: vPage:="Page"+String(Printing page). [<--Something like this]
>The output on the footer of the report looks like: pa,ge1.
>Where in the world did that comma come from?  I looked at it and retyped it,
>but the crazy comma is still there?  I took this code straight out of
>the book too.  The vDate for the current date worked fine.
>
>Dave
 
 
Have you checked the "Format" area of the object description dialog?  Whatever
is in there affects your output.
 
 
Bill
rwj@engr.latech.edu
st25370@vm.cc.latech.edu
Newsgroups: comp.sys.mac.databases
Subject: Re: Filemaker exporting summarised data
From: bobjen@darwin.ntu.edu.au (Bob Jenner)
Date: 30 Sep 92 08:19:37 +0900
Followup-To: comp.sys.mac.databases
Distribution: world
Organization: NTU

In article <1992Sep29.123441.150@vulcan.resmel.bhp.com.au>,
paulm@steelmel.bhp.com.au wrote:
> 
> I have a Macintosh running Filemaker (1.0v2) under system 6.0.7.  
> 
> I would like to export Filemaker data in a summarised format.  E.g. if I have a
> (simple) database that looks like this: 
> 
>  Product        Tonnes
>  Cold Rolled	71
>  Hot Rolled		25
>  Hot Rolled  	10
> 
> 
> I would like to be able to produce a *file* (cf a report) that looks like this:
> 
> Product			Tonnes
> Cold Rolled		71
> Hot Rolled		35
> 
> 
> My understanding is that Filemaker (1.0v2) will only export individual records.
>  One suggestion made by an IBM person is that I find out if there is a
> Macintosh print driver which will print an ascii file to disk, then print a
> copy of a layout in the appropriate format.  Is this possible, or is there an
> alternative?
This can be done using an app. (commercial) called SuperGlue II.
> Paul.


Cheers
Bob Jenner
Northern Territory University
Darwin, Australia
Newsgroups: comp.sys.mac.databases
From: sandrov@vxcrna.cern.ch (VENTURA,SAND./EP)
Subject: 4D Receive Record Command
News-Software: VAX/VMS VNEWS 1.41    
Organization: European Organization for Nuclear Research, CERN
Date: Mon, 28 Sep 1992 19:18:00 GMT

I'm experiencing some troubles with the Receive Record command:
I can't avoid it to create a new record each time it executes, despite what
stated on the manual which says that a record can be received in the current
record.
What am I missing? Any help or more general suggestions on how to transfer
records between separate databases?

Thanks
Sandro 
Newsgroups: comp.sys.mac.databases