HDTenEightyP/NetNews huggingface dataset:
From: dt1n+@andrew.cmu.edu (David Tsai)
Newsgroups: comp.sys.mac.databases
Subject: Using 4D menus
Date: 9 Nov 92 21:45:36 GMT
Article-I.D.: andrew.kezqWU600iV00AWnU5
Organization: Senior, Social & Decision Sciences, Carnegie Mellon, Pittsburgh, PA

In case it wasn't clear, I'd like to thank EVERYONE who has replied to
my messages.  You people have saved my day!

How in the world do you get the menus working in 4D when you leave the
first menu bar?

My menu bar #1 works fine, but when I select an option [say add
purchase] and bring up another menu bar and try to select an option on
it [show help for add purchase or print purchase]...none of the options
work.  Somewhere in the book it says to use negative numbers for
runtime...I tried that everywhere I could thing of but that did not work.

The problem I see is that the menu item does not perform the procedure
assigned to it.

I did some more looking around and I have also found a couple of
commands which I do not understand: "Check Item" and "Menu selected" 
The thing is I don't know if these options are of any use to my problem.
 Help...?

Thanks Again!

Dave Tsai
Newsgroups: comp.sys.mac.databases
From: pejacoby@mmm.serc.3m.com (Paul E. Jacoby)
Subject: Re: 4D 2.2.3 multi-user
Organization: 3M Company
Date: Mon, 9 Nov 92 14:15:35 GMT

In article <1992Nov07.010408.95067@bmug.org> Robert_S._Fukuda@bmug.org writes:
>[4D 2.2.3 single-user app in multi-user]

>1. Will the application run using system 7's file sharing capabilities? Does a
>mac have to essentially become a file server for 4D to work  or can the mac
>which has the application run the application simultaneously with another user
>on the network?

You can run with the database file on another machine using System 7's
FileSharing.  Works basically the same as having a dedicated AppleShare
fileserver (with the inherent user-limits built into FileSharing).

>2. How much of a performance drop will occur using the network? How much of a
>difference would using ethernet make?

You will probably be suprised at how much things slow down.  It can be
pretty horrid.  If you end up changing any code, it will probably be to
improve performance!  Ethernet helps some, but the 4D Server is really
going to be the most help.

>3. Will I have to re-write sections of code to make things work in multi-user?

No, not specifically.  You may need to tweak heavily for performance
enhancements, and may find yourself changing code which uses automatic
relations as a result.  You also might want to take a look at any code
you have which deletes records or updates items like a sequence number.
These are places that the LOCKED() command can come in handy.  Take a
wander through the language guide, paying attention to the multi-user
notes found on commands which behave differently in multi-user mode.

>4. Any other problems that you can tell me about?

Just performance...it is loads of fun working around the inherent
slowness of a fileserver database running over LocalTalk :-)

-- 
| Paul E. Jacoby, Consultant  | pejacoby@mmm.com      CIS:70404,2507 |
| David Mitchell & Associates |                                      |
| 3M Center, Bldg 235-3F-27   |--------------------------------------|
| Maplewood, MN   55144-1000  | (612) 737-3211 [w]      731-6392 [h] |
Newsgroups: comp.sys.mac.databases
Distribution: world
From: Darren_E._Tong@fourd.com
Organization: 4th Dimension BBS
Date: Sat, 07 Nov 1992 15:43:38 EST
Subject: Re: FM pro 'stupid' question

I'm quite new with FileMaker pro (1.0*) so maybe this is a very
stupid question but anyway.

Is there a way to have FM go to the next field (when entering data)
with a normal return instead of those tab's?

No, not that I know of

- BulkRate... and worth every penny!-darren_tong@fourd.com

********************************************************************
System: fourd.com                                Phone: 617-494-0565
Cute quote:  Being a computer means never having to say you're sorry
********************************************************************

Newsgroups: comp.sys.mac.databases,rec.arts.books
From: hayward@biblio.ucs.sfu.ca (Michael Hayward)
Subject: FileMaker format for bibliophiles?
Keywords: books database
Reply-To: hayward@sfu.ca
Organization: Simon Fraser University, Burnaby, B.C., Canada
Date: Tue, 10 Nov 1992 23:57:03 GMT

I was about to sit down and design a FileMaker database record and  
layout(s) to track my book collection with, but thought that it might have  
already been done by some other bibliophile out there.

Is there anyone who has gone through this exercise that would be willing  
to share the results with me? (Or who would be willing to suggest other  
successful approaches) Thanks!

..Michael Hayward         hayward@sfu.ca
Newsgroups: comp.sys.mac.databases
Distribution: world
From: Darren_E._Tong@fourd.com
Organization: 4th Dimension BBS
Date: Sat, 07 Nov 1992 15:43:48 EST
Subject: Licensing inffo

I'm in the process of designing a database in FM pro 2.0- does anyone have any
info on licensing, pricing, marketing strategies etc.

Thanks in advance!

- BulkRate, the offline reader for FirstClass-darren_tong@fourd.com

********************************************************************
System: fourd.com                                Phone: 617-494-0565
Cute quote:  Being a computer means never having to say you're sorry
********************************************************************

Newsgroups: comp.sys.mac.databases
From: rgaros@bio.vu.nl (Rene G.A. Ros)
Subject: Re: 4D XRef info wanted please
Organization: VU Biology, Amsterdam, The Netherlands
Date: Wed, 11 Nov 1992 17:28:54 GMT

pejacoby@mmm.serc.3m.com (Paul E. Jacoby) writes:
: Rene',
: 
:   4D Xref (I have version 2.0) is basically a REPORTING tool only.  It
:   will let you print out just about any part of your database, but you
:   can't make global changes or anything useful like that :-)
There is no tool available which can do these usefull things, or can XRef
'print' to a document and use a wordprocessor to search!!??

:   In terms of what you can print out (or browse interactively), you have
:   the option to print a Cross-reference of Commands, Global Procedures,
:   Variables, Externals, Layouts, and the Structure.  You can also print
:   all layouts and layout procedures, global procedures, menu bars, and lists.
Can be usefull for some, but I'am looking for something else. Suppose I have
a large database (#files) and delete a global procedure. It gives the same
problems when you would be able to delete files and fields. So ACIUS, why
not giving the possibility to delete files and fields? (Not the other option
:-)  )

:   XRef does a nice job digesting a ream of paper.  On a mildly involved
:   database, it is not unusual to get 200+ pages of output if you choose
:   all options.  I team XRef up with the excellent "N-up Laserwriter"
:   functionality from "DMM Laserwriter Stuff 1.3.1" in order to save my
:   small chunk of forest.
I don't see what difference XRef makes: you still can't find anything. Not
in the data-base nor on paper...

:   Now if we could just figure out why ACIUS thinks XRef needs it's own
:   color pallette....
I do hope it uses the password settings from the structure file..

: | Paul E. Jacoby, Consultant  | pejacoby@mmm.com      CIS:70404,2507 |
: | David Mitchell & Associates |                                      |
: | 3M Center, Bldg 235-3F-27   |--------------------------------------|
: | Maplewood, MN   55144-1000  | (612) 737-3211 [w]      731-6392 [h] |

--
Thanks for your response,

Rene'

************************************************************
Rene G.A. Ros                         Amsterdam, Netherlands
rgaros@bio.vu.nl                    rgaros@nikhefk.nikhef.nl
************************************************************
My English is niet very well en ook nog not so snel,
but that comes later wel.
************************************************************
From: hades@coos.dartmouth.edu (Hades)
Newsgroups: comp.sys.mac.databases
Subject: Re: a FM Pro question
Date: 5 Nov 92 16:13:37 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

charlesa@niwot.scd.ucar.edu (Charles Albrecht) writes:

>It's possible to access individual elements from other files with lookup...
>This isn't what you're looking for, though.  It can't be done in 
>version 1.x of FM Pro.  How about it, verison 2 owners?  Has Claris
>decided to give us a way to access repeating fields like we would an 
>array?

    Nope. This is not the purpose of repeating fields. The only function
that I have been able to acertain for the use of these fields is for
summing up a column of numbers that doesn't need to be searched, sorted,
or anything other then summed. Since this almost never happens, I
usually recommend that you stay away from repeating fields.

--
-Hades (Brian V. Hughes) 
		      "No sir, I didn't like it."
From: pamiri@uci.edu (Peter Amiri)
Subject: Re: 4D: Layout ???s
Newsgroups: comp.sys.mac.databases
Organization: University of California, Irvine
Date: 6 Nov 92 18:07:02 GMT

In article <QeyNFVq00UhW85rJ5K@andrew.cmu.edu>, William Matthew Beaver <wb1o+@andrew.cmu.edu> writes:
> 
> I am trying to take a list of records, display them in a column format,
> and create a new record in another table given whatever the user
> selects.  For example:
> 
> Customer Table
> Name            ID Number
> --------------------------
> Smith            9457
> Jones            0982
> Murphy           3920
>    .               .
>    .               .
> etc               etc
> 
> 
> When the user selects "Jones" that record is selected.  Then I want to
> create a record in a table [Projects] related by ID number. I want the
> input layout for [Projects] to come up immediately after the user double
> clicks in the [Customer] table layout. With the ID number inserted (as
> it sometimes does with the relation)
> 
> I think the problem lies in the fact that I'm trying to switch between
> files. I've tried selecting all the names and ID numbers into arrays
> with: 
> 
> selection into array([Customer]Cust_Name;AreaA;[Customer]Cust_ID;AreaB)
> 
> And then displaying the arrray with:  modify selection([Customer])
> 
> This is getting pretty ugly. Does anyone have any ideas as to how I can
> do this? Either with the file switching or with the arrays? Another
> (easier?) way.
> 
> ANY ideas would be greatly appreciated.
> 
> Thanks in advance,
> William M. Beaver
> Carnegie Mellon University
> 
Wiliam,
	When you use modify selection it is displaying the selection of records
directly from the file and not the arrays. Create a layout with the array
areas on it and use the dialog command to display it. 

Peter Amiri
From: jas@ISI.EDU (Jeff Sullivan)
Newsgroups: comp.sys.mac.databases
Subject: Helix users, sound off!
Date: 12 Nov 92 18:26:26 GMT
Distribution: comp
Organization: USC-ISI


I'm writing an article on Helix express, and I'd like to have any
concerns, kudos or comments about the product that you'd like to get
off your chest.

Post here or email me at jas@isi.edu

Thanks,

jas
--
--------------------------------------------------------------------------
Jeffrey A. Sullivan             | Research Scientist et al.
jas@isi.edu (Internet)          | Information Sciences Institute
72511,402    (Compuserve)       | University of Southern California
Newsgroups: comp.sys.mac.databases
From: bmartin@uhunix.uhcc.Hawaii.Edu (Brian Martin)
Subject: Re: 4d "report" command
Organization: University of Hawaii
Date: Sat, 7 Nov 1992 10:03:49 GMT

In article <gexhtUO00iV1E4hmQ0@andrew.cmu.edu> David Tsai <dt1n+@andrew.cmu.edu> writes:

Dave,

>Has anyone tried to use the "report" command on page 162 language refernce?
>report ([CPU];""} is supposed to allow the user to generate their own...
>Unless someone can prove otherwise, I think that this command doesn't do
>anything...let alone what it is supposed to!
>Does anyone know what I can do to get it working?  Or should I just give it up?

To open the Quick Report editor, pass an invalid filename to
the report command, e.g.,
   REPORT ([MyFile];"This is not a valid name")

One of 4D's many "features" ;-)

Best regards,

    Brian K. Martin, M.D.
    Martin Information Systems, Ltd.
    1103 9th Avenue, Suite 203
    Honolulu, Hawai`i 96816-2403 USA
    Voice (808) 733-2003
    Fax (808) 733-2011

INTERNET: bmartin@uhunix.uhcc.hawaii.edu
CompuServe: 76535,250
From: wb1o+@andrew.cmu.edu (William Matthew Beaver)
Newsgroups: comp.sys.mac.databases
Subject: 4D: Layout ???s
Date: 5 Nov 92 21:38:41 GMT
Organization: Senior, Social & Decision Sciences, Carnegie Mellon, Pittsburgh, PA

I am trying to take a list of records, display them in a column format,
and create a new record in another table given whatever the user
selects.  For example:

Customer Table
Name            ID Number
--------------------------
Smith            9457
Jones            0982
Murphy           3920
   .               .
   .               .
etc               etc


When the user selects "Jones" that record is selected.  Then I want to
create a record in a table [Projects] related by ID number. I want the
input layout for [Projects] to come up immediately after the user double
clicks in the [Customer] table layout. With the ID number inserted (as
it sometimes does with the relation)

I think the problem lies in the fact that I'm trying to switch between
files. I've tried selecting all the names and ID numbers into arrays
with: 

selection into array([Customer]Cust_Name;AreaA;[Customer]Cust_ID;AreaB)

And then displaying the arrray with:  modify selection([Customer])

This is getting pretty ugly. Does anyone have any ideas as to how I can
do this? Either with the file switching or with the arrays? Another
(easier?) way.

ANY ideas would be greatly appreciated.

Thanks in advance,
William M. Beaver
Carnegie Mellon University
Newsgroups: comp.sys.mac.databases
From: michaelh@Xenon.Stanford.EDU (Mike Hennahane)
Subject: Re: 4D: Assigning Unique Integers
Organization: CS Department, Stanford University, California, USA
Date:  6 Nov 92 00:50:36 GMT

William Matthew Beaver <wb1o+@andrew.cmu.edu> writes:

>Is there a way to assign a unique integer to a field outside of the #N
>comand in the layout editor?  

the "standard" :-) way to do this is to have an extra file in your
database called Constants or Sequences. your sequence file has 2
fields: sequence name, and next number.  to get the next number all
you have to do is search for the correct sequence by name (or you can
number them if you prefer) and then use the contents of the next
number field;  before you unlock the record, you should increment the
next number for the next time you want one. the next number is always
unique for that sequence as long as you increment it each time it is
used. you may have different sequences for each file in your database,
and multiuser issues are not a problem (if you can't load the record,
you know someone else is using it. just wait until it becomes availale
again to get the next number).

--mike
Newsgroups: comp.sys.mac.databases
From: rajiv@athena.mit.edu (Rajiv A Manglani)
Subject: Re: FMP Index Question
Keywords: FileMaker Pro
Organization: Massachusetts Institute of Technology
Date: Sun, 8 Nov 1992 18:03:28 GMT

Okay, I can separate the word with option spaces instead of regular spaces,
but what if I use the underscore character? I cannot use non-breaking spaces
because the text in the field will eventually be used in exporting lists to
unix... which doesn't like spaces in file names.

Rajiv
Newsgroups: comp.sys.mac.databases
From: pejacoby@mmm.serc.3m.com (Paul E. Jacoby)
Subject: Re: 4D XRef info wanted please
Organization: 3M Company
Date: Wed, 11 Nov 92 15:33:56 GMT

In article <1992Nov11.093530.5321@bio.vu.nl> rgaros@bio.vu.nl (Rene G.A. Ros) writes:
>: >Can someone tell me what 4D XRef exacly does? Does it 'produce'
> 
>Do you mean the paper it produces can be useful, or are there any other
>functions it can do???

Rene',

  4D Xref (I have version 2.0) is basically a REPORTING tool only.  It
  will let you print out just about any part of your database, but you
  can't make global changes or anything useful like that :-)

  In terms of what you can print out (or browse interactively), you have
  the option to print a Cross-reference of Commands, Global Procedures,
  Variables, Externals, Layouts, and the Structure.  You can also print
  all layouts and layout procedures, global procedures, menu bars, and lists.

  XRef does a nice job digesting a ream of paper.  On a mildly involved
  database, it is not unusual to get 200+ pages of output if you choose
  all options.  I team XRef up with the excellent "N-up Laserwriter"
  functionality from "DMM Laserwriter Stuff 1.3.1" in order to save my
  small chunk of forest.

  Now if we could just figure out why ACIUS thinks XRef needs it's own
  color pallette....
-- 
| Paul E. Jacoby, Consultant  | pejacoby@mmm.com      CIS:70404,2507 |
| David Mitchell & Associates |                                      |
| 3M Center, Bldg 235-3F-27   |--------------------------------------|
| Maplewood, MN   55144-1000  | (612) 737-3211 [w]      731-6392 [h] |
Newsgroups: comp.sys.mac.databases
From: cicone@uieea.ece.uiuc.edu
Subject: working with FMP blank fields
Organization: University of Illinois 
Date: Fri, 13 Nov 1992 22:25:43 GMT

 Hello,	
	Has anyone out there come up with a work around for FileMakerPro (1.0v2) that
would allow the use of the 'If' function in a calculation field that references
a date field that does not yet contain a value?  The actual calculation I would
have liked to use:

If (Length (paper accepted) >0 ,"Accepted",If (Length (paper rejected) >0 ,
"Rejected" , "In Progress"))

	where 'paper accepted' and 'paper rejected' are both date fields.  As the FMP
manual states if a field doesn't contain a value the 'If' function is skipped
altogether and returns an empty result. If either of the date fields has a
value entered into it the calculation works fine; if both fields are blank I
get no result.  
	I attempted a few ways around this but it seems that none of the functions
available in a calculation field will work with a blank field....
Thanks in advance...
--Bob--
**********************
Bob Cicone (cicone@uieea.ece.uiuc.edu)
Sys Admin
Bioacoustics Research Lab
University of Illinois at Urbana-Champaign
Newsgroups: comp.sys.mac.databases
From: rgaros@bio.vu.nl (Rene G.A. Ros)
Subject: Re: 4D question
Organization: VU Biology, Amsterdam, The Netherlands
Date: Fri, 6 Nov 1992 13:56:09 GMT

jjwright@gandalf.rutgers.edu (     Jay) writes:
: 
: greetings,
: 
: i just created a 4d application, my very first one :) and i wanted to
: change the background screen from the 4d emblem to something that i
: create in paint (perhaps) or some other graphics file..  or even a
: blank back drop would be fine.  anything but the 4d emblem.
: 
: is there a way to do this, i figure there must be, but i couldnt find
: anything about it in the manuals.
: 
: any help is appreciated..
: 
: thank you
: 
: jay
: 
: jjwright@remus.rutgers.edu

You can put a picture with every menu-bar you create.
Go to the menu-bar editor in the Design Env. and choose a menubar.
The there is menu item (don't recall exact name and position, but it is
in most right one menu by the name 'Show menu'. This command displays your
custom made menubar and when you paste a picture here it will replace the
impossible four from ACI/ACIUS. If you chose cut or clear this will be
restored.

Hope this is correct information,

Rene' Ros

************************************************************
Rene G.A. Ros                         Amsterdam, Netherlands
rgaros@bio.vu.nl                    rgaros@nikhefk.nikhef.nl
************************************************************
My English is niet very well en ook nog not so snel,
but that comes later wel.
************************************************************
Newsgroups: comp.sys.mac.databases
From: ajiang@lonestar.utsa.edu (Alexander X. Jiang)
Subject: Re: Helix users, sound off!
Organization: University of Texas at San Antonio
Distribution: comp
Date: Thu, 12 Nov 1992 22:48:06 GMT

In article <22882@venera.isi.edu> jas@ISI.EDU (Jeff Sullivan) writes:
>
>I'm writing an article on Helix express, and I'd like to have any
>concerns, kudos or comments about the product that you'd like to get
>off your chest.
>
>Post here or email me at jas@isi.edu

I honestly hate Helix's template editor.  I would be real proud of Helix
if they can put more drawing tool into it, (at least, a line tool.)

and, it'd be terrific if they can make the tiles smaller, having a 13 inch
monitor, some time it's still pretty annoying to scroll all directions to
get a complete view of a calculation.  wonder how the SE'er doing with that?

Newsgroups: comp.sys.mac.databases
From: ebido@bio.vu.nl (Etienne Bido)
Subject: FM pro 'stupid' question
Organization: VU Biology, Amsterdam, The Netherlands
Date: Sat, 7 Nov 1992 12:30:37 GMT

I'm quite new with FileMaker pro (1.0*) so maybe this is a very
stupid question but anyway.

Is there a way to have FM go to the next field (when entering data)
with a normal return instead of those tab's?

thanx
etienne

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Etienne Bido			|| ebido@bio.vu.nl
Vrye Universiteit		|| bido@chem.vu.nl
Amsterdam    Holland
Organization: Senior, Social & Decision Sciences, Carnegie Mellon, Pittsburgh, PA
Newsgroups: comp.sys.mac.databases
Date: Tue, 10 Nov 1992 02:32:06 -0500 
From: David Tsai <dt1n+@andrew.cmu.edu>
Subject: 4d sorted printouts

Since sorting takes so long with 4D, when should it be done?

I'd like to have the data in my reports to be sorted already, but it takes way
too long for it to sort before it actually prints...this makes printing
a pain.  Any ideas as to making it fast and easy for users to print out
sorted data?

Thanks in advance.

Dave Tsai
Newsgroups: comp.sys.mac.databases
From: rgaros@bio.vu.nl (Rene G.A. Ros)
Subject: Re: 4D XRef info wanted please
Organization: VU Biology, Amsterdam, The Netherlands
Date: Wed, 11 Nov 1992 09:35:30 GMT

michaelh@Xenon.Stanford.EDU (Mike Hennahane) writes:
: rgaros@bio.vu.nl (Rene G.A. Ros) writes:
: 
: >Can someone tell me what 4D XRef exacly does? Does it 'produce'
: >only a lot of paper or can I, for example, find and replace
: >in all procedures and scripts???
: 
: it produces a lot of paper.  it can be very useful, though.  i have
: the initial version;  i don't know if it has been changed since then.
: 
: --mike
: 
Do you mean the paper it produces can be useful, or are there any other
functions it can do???

Rene'

************************************************************
Rene G.A. Ros                         Amsterdam, Netherlands
rgaros@bio.vu.nl                    rgaros@nikhefk.nikhef.nl
************************************************************
My English is niet very well en ook nog not so snel,
but that comes later wel.
************************************************************
Newsgroups: comp.sys.mac.databases