HDTenEightyP/NetNews huggingface dataset:
Newsgroups: comp.sys.mac.databases
Subject: FileMaker Pro 2.0 warning
Date: Tue, 06 Oct 1992 19:59:53 -0500

I spoke with Claris Tech Support yesterday about a problem I was having with
several FileMaker Pro databases after receiving the 2.0 upgrade.  Turns out
there's a potential big-time problem when converting files unless you do the
right things first.

The problem involves any FileMaker Pro file that was created or used under 
1.0v1.  Seems 1.0v1 had a problem with its indexes, and doing a RECOVER
under 1.0v2 or 1.0v3 would fix it.  If the problem remains, however, and
you simply convert the file to 2.0 format, you'll lose data, and according
the person I spoke to at Claris there is NO way to recover it.

The key to avoiding this is to RECOVER the file first - don't just open &
convert it with FM Pro 2.0.  I don't know whether doing a recover of a 1.0vx 
file in 2.0 also converts it, since I had already converted the files by the
time I learned this.

There's supposed to be an insert in the package that explains this, but mine
must have been one of the first shipped, because it didn't have one.  

Be warned - this cost me a lot of grief, since I didn't understand what had
happened and then put in many hours adding data to one of my most important
files & couldn't simply go back to the pre-2.0 backup.  It's amazing that they
didn't discover this during development and test of 2.0 - it's also a little
bothersome that a corrupted index can permanently damage a FileMaker file with
no way to recover the data (it's still there - you just can't get at it), but
according to Claris tech support, that's the way it is.

Newsgroups: comp.sys.mac.databases
From: Dave J <djensen@claven.idbsu.edu>
Subject: Helix let me down, other options?
Organization: Morrison Center for the Performing Arts
Distribution: usa
Date: Sat, 10 Oct 1992 02:47:02 GMT

I have been using Double Helix for 3 years now. One of the main reasons for
choosing it was the ability to run a client and the server on the same machine
(no dedicated server for the network). Well, Helix Express (new owners-new
name) decided to eliminate that capability... without mentioning the fact in
their upgrade offer. So, after generating a university purchase order,
receiving the upgrade, and spending the better part of a day updating the
existing database, trying to figure out why the client on the same machine as
the server wouldn't function, calling their tech support, I find out the next
day from a sympathetic tech guy... I can no longer get there from here! 

Kim at Helix Express, on the receiving end of my indignation and upon hearing
that I might have to look into other brands, promised "you can try them, but
you'll come back because all the others are a bitch to program."

Well, I realize we can continue as before without the upgrade, but I am,
nevertheless, looking. Ours is a small database and network. We do not want the
expense of a dedicated server. Are there any other relational databases that
work without a dedicated server machine?

Thanks in advance.  

Dave
djensen@claven.idbsu.edu
From: tal691@huxley.anu.edu.au (Tonio Loewald)
Newsgroups: comp.sys.mac.databases
Subject: Re: FileMaker Pro 2.0 warning
Date: 15 Oct 92 06:39:59 GMT
Organization: Australian National University
NNTP-Posting-Host: 150.203.2.12

Paul.Heller@p391.f70.n109.z1.fidonet.org (Paul Heller) writes:

>I spoke with Claris Tech Support yesterday about a problem I was having with
>several FileMaker Pro databases after receiving the 2.0 upgrade.  Turns out
>there's a potential big-time problem when converting files unless you do the
>right things first.

>The problem involves any FileMaker Pro file that was created or used under 
>1.0v1.  Seems 1.0v1 had a problem with its indexes, and doing a RECOVER
>under 1.0v2 or 1.0v3 would fix it.  If the problem remains, however, and
>you simply convert the file to 2.0 format, you'll lose data, and according
>the person I spoke to at Claris there is NO way to recover it.

>The key to avoiding this is to RECOVER the file first - don't just open &
>convert it with FM Pro 2.0.  I don't know whether doing a recover of a 1.0vx 
>file in 2.0 also converts it, since I had already converted the files by the
>time I learned this.

>There's supposed to be an insert in the package that explains this, but mine
>must have been one of the first shipped, because it didn't have one.  

>Be warned - this cost me a lot of grief, since I didn't understand what had
>happened and then put in many hours adding data to one of my most important
>files & couldn't simply go back to the pre-2.0 backup.  It's amazing that they
>didn't discover this during development and test of 2.0 - it's also a little
>bothersome that a corrupted index can permanently damage a FileMaker file with
>no way to recover the data (it's still there - you just can't get at it), but
>according to Claris tech support, that's the way it is.

I know this doesn't make up for the bug you've mentioned, but such problems
in general (eg. you update the wrong version of a database file) can be
avoided by time-stamping (creation/modification date) on records automatically,
allowing all records created/modified during a given period to be separated out
and exported to the correct version of a file.

There's no reason why such a timestamp shouldn't be added to records (or
for that matter, be made part of any record automatically -- anyone at
Claris listening ? :)  ).

Just a thought.

Tonio Loewald

-- 
Tonio Loewald            | Ph  06 290 1594 | PO Box 101 O'Connor
tal691@huxley.anu.edu.au | Fax 06 290 1595 | ACT 2601   AUSTRALIA
From: hades@coos.dartmouth.edu (Hades)
Newsgroups: comp.sys.mac.databases
Subject: Re: FILEMAKER PRO AND ZIPCODE
Date: 16 Oct 92 14:45:16 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

Billy.Krahl@f421.n109.z1.fidonet.org (Billy Krahl) writes:

>For every instance of zipcode 20850 in Filemaker Pro database, the count
>would be incremented.  Is there any way I can do it other than creating
>a new field for each unique zipcode and put in calculatin...?

    Yup they are called Summary fields. What you do is create a field
called Zip Count or something, and designate it as a summary field that
performs a count. Then you sort by zipcode and put in a sub summary part
in a layout with this field in it, and it will count up the records in
each zipcode breakdown.

--
-Hades (Brian V. Hughes) 
  "I'm sorry, I didn't have my hearing aid on. Could you repeat that?"
			  -Admiral Stockdale-
From: pamiri@uci.edu
Subject: Re: Unix solutions for 4D?
Newsgroups: comp.sys.mac.databases
Organization: University of California, Irvine
Date: 16 Oct 92 15:19:29 GMT

In article <1992Oct15.184959.2343@ncar.ucar.edu> charlesa@niwot.scd.ucar.edu
(Charles Albrecht) writes:
>I'm looking for options to interact with 4D databases from unix machines.
>I've heard that the new 4D externals kit will include C libraries for
>extracting information from v.3.0/Server databases.  What will be/is
>involved in building such programs for unix and X?  Are there widget sets
>available for this?  What sort of information is passed, and how is this
>handled on the 4D side of the connection?
>
>I'm not only interested in version 3.0 solutions, but also in those that
>may have been developed for version 2.x.x.
>
>Thanks,
>
>-Charles
>---
>Charles Albrecht             charlesa@ncar.ucar.edu            303/497-8524   


Charles,
	I think you are refering to the 3.0 API which will let you get to a 4D server
and extract data as well as update it. Its important to understand that the new
4D server relies on ADSP to sent data accross the network. This means that any
application written with the API to access the server will have to be running
on a machine that is ADSP capable. I think Farallon is working on ADSP for
Windows and until that is available you won't be able to get at the server
using the API. I'm not sure if there is an ADSP implementation for unix boxes.
Hope this helps.

Peter

_____________________________________________________________________________
Peter Amiri                                  University of California, Irvine
pamiri@uci.edu                                     Office of Academic Affairs
_____________________________________________________________________________
From: chuq@Apple.COM (Chuq Von Rospach)
Newsgroups: comp.sys.mac.databases
Subject: Re: DAL questions
Date: 7 Oct 92 16:30:28 GMT
Organization: Apple Computer Inc., Cupertino, CA

einhorn_d@apsicc.aps.edu (E. Drew Einhorn) writes:

>Does Filemaker Pro support DAL access?

FM Pro 2.0 is supposed to. I just got my copy yesterday, and haven't had a
chance to check. So does Resolve and Excel. 
-- 
Chuq "IMHO" Von Rospach, ESD Support & Training (DAL/AUX) =+= Member, SFWA
  chuq@apple.com | GEnie: MAC.BIGOT | ALink:CHUQ =+= Editor, OtherRealms


Newsgroups: comp.sys.mac.databases
From: ags@seaman.cc.purdue.edu (Dave Seaman)
Subject: Re: FoxBase/Mac Error Message
Organization: Purdue University
Date: Fri, 9 Oct 1992 15:44:29 GMT

In article <92282.160546JFL4@psuvm.psu.edu> <JFL4@psuvm.psu.edu> writes:
> A user of mine is using a program on a System 6.0.8 Mac that I wrote
> on a System 7 Mac.  He's getting the message "Not enough memory to open
> a screen of that size" when opening certain query screens.  I don't get
> the message on my Mac (with System 7).

It has nothing to do with System 7. The amount of memory needed is related  
to the sizes of the open windows (presumably unchanged) and also the  
number of colors. If his machine is using 24-bit color, say, he might try  
switching to 8-bit color, or increasing the partition size for  
FoxBASE+/Mac (assuming he's using MultiFinder), or adding more memory.

--
Dave Seaman
ags@seaman.cc.purdue.edu
Newsgroups: comp.sys.mac.databases
From: bmartin@uhunix.uhcc.Hawaii.Edu (Brian Martin)
Subject: Re: Help wanted - reporting tool
Organization: University of Hawaii
Date: Mon, 12 Oct 1992 12:47:26 GMT

In article <1992Sep30.181617.24932@news.mentorg.com> Shariar Jahromi <Shariar_Jahromi@mentorg.com> writes:
>
>1- The question is, how can I achieve my objective????
>
>I do realise that we, within our organisation, need to have an in-depth
>knowledge of the product tables and the way they are linked together. But
>hopefully that does not mean programming.

You will need a printout of the 4D Structure. You will also need to
know if the vendor has coded any equijoin operators; otherwise,
your equijoin operations will be limited to the one-file/many-file
links. You will also have to learn how to use the Quick Report Editor,
The QR editor is a very powerful management reporting tool. With
it you can create ad-hoc reports and send the reports to a printer or
to a disk file for import into excel or resolve.

>2- How should I negotiate with the software (what should I ask for)????
Ask for access to the quick report editor, and also ask
that the vendor install the 4D Calc and Graph 4D Modules.

>Is the structure of the database (the way tables are linked) enough???
Usually. See above.

>3- Very important...what management tool should I consider ???
See above. You also may want to learn how to use the 4D Modules--
4D Calc and Graph 3D; they can turn 4D into an analysis and reporting
tool unmatched by anything else in the industry.

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
Newsgroups: comp.sys.mac.databases
From: mlbarrow@mit.edu (Michael L Barrow)
Subject: Re: Can't post to 4D@MIT
Followup-To: comp.sys.mac.databases
Organization: MIT Information Systems/CSSC
Date: Wed, 14 Oct 1992 22:45:27 GMT

In article <a-kraus-131092111720@pesa.physics.uiuc.edu>, a-kraus@uiuc.edu
(Albert L. Kraus) wrote:
> 
> I'm receiving user group mail from the 4D group but I can't post anything
> to 
> 4D@MIT.edu. My mail always comes back. What is the problem.
> Do I need the numeric ethernet address?
> 
> Thanks!
> Have a nice day!

I am the maintainer of the 4D mailing list at MIT and in order to help you,
I would need to know the error messages from the mailer. MIT is very well
configured on the network, so if your host can't find MIT.EDU, then there
is some local (on your end) problem with name resolution. 

By the way, if anyone wants to join, just drop a note to
4d-request@mit.edu.

-- Michael L Barrow, Consultant
   Computing Support Services Consulting Group
   MIT Information Systems
Newsgroups: comp.sys.mac.databases
From: day_kevran@tandem.com (Kevran Day )
Subject: Re: DAL questions
Followup-To: comp.sys.mac.databases
Organization: Tandem Computers, Inc.
Date: Wed, 7 Oct 1992 20:47:06 GMT

In article <6OCT199209465867@apsicc.aps.edu>, einhorn_d@apsicc.aps.edu (E.
Drew Einhorn) wrote:
> 
> Can anybody provide me with a list of Mac applications which
> support access to databases residing on a DAL server?  

DataPrism - Brio Technology, Inc.
GQL - Andyne Computing Ltd.
ClearAccess - Fairfield Software
Lotus 1-2-3 for Macintosh - Lotus Development Corp.
Microsoft Excel  - Microsoft Corp.
Wingz - Informix Software, INc.
Full Impact - Borland Int'l.
GeoQuery - GeoQuery Corp.
Atlas Pro - Strategic Mapping, Inc,
Tactician - Tactics Int'l, Inc.
HyperCard - CLaris
SuperCard - Aldus Corp.
4D - ACIUS
Omnis 7 - Blythe Softwrae
FoxBASE+/Mac - Fox Software
Prograph = TGS Systems
MPW C - Apple
MPW Object Pascal - Apple
Think C - Symantec
Nexpert Object - Neuron Data, Inc.
HyperX - Millenium Software

This is from an Apple/DAL brochure I have.  I've no idea if this is
complete.

Kevran  Day, Apple Products Development Group, Tandem Computers, Inc.
day_kevran@tandem.com
Newsgroups: comp.sys.mac.databases
From: Joshua D. Wachs <joshua@natural.com>
Subject: 4D Developer Wanted!
X-Xxdate: Tue, 13 Oct 92 21: 44:09 GMT
Organization: Natural Intelligence, Inc.
X-Useragent: Nuntius v1.1.1d7
Date: Tue, 13 Oct 1992 20:44:11 GMT


<=================================NI=================================>
 Joshua D. Wachs                  |   Internet: joshua@natural.com
 President                        |   Phone: 617-876-4876
 Natural Intelligence, Inc        |   FAX:   617-492-7425
 2067 Massachusetts Avenue        |   AppleLink: NATURAL
 Cambridge MA  02140              |   CompuServe: 72427,177
From: pamiri@uci.edu
Subject: Re: 4D External source
Newsgroups: comp.sys.mac.databases
Organization: University of California, Irvine
Date: 14 Oct 92 21:35:52 GMT

In article <edestes-141092150153@machacker.dcrt.nih.gov> edestes@pop.nih.gov
(Ed Estes) writes:
>
>Greetings!
>
>I've been programming the Macintosh since 1985 and need to write some 
>externals for 4th Dimension.  I've read the 4D External package cover
>to cover and have come to the conclusion that the documentation suxs!
>
>Does anyone know if there is additional external SOURCE somewhere that I
>can 
>get my hands on?  In one of my externals, I need to stuff a string array
>with
>data and it's not working.  I'm not sure if it's the way I'm compiling my
>code or what...  I'll probably figure most of this stuff out, but I'm under
>a deadline and needed to get something out yesterday!  ;-)
>
>I'm using Think C 5.0.3 and 4th Dimension 2.2.3.   Thanks in advance.
>
>
>--Ed
>
Ed,
	Have you tried compuserve. In library 3 there was an example or shell posted a
few weeks ago. I down loaded it but found is useless for me since I use Think
Pascal. The shel is in Think C so it might be more valuable to you. If you
can't get access to library 3 (only registered External kit owners do have
access) let me know and I'll down load it for you.

_____________________________________________________________________________
Peter Amiri                                  University of California, Irvine
pamiri@uci.edu                                     Office of Academic Affairs
_____________________________________________________________________________

Newsgroups: comp.sys.mac.databases
From: ST25370@VM.CC.LATECH.EDU
Subject: Re: 4th Dimension -- Disable Button
Organization: LOUISIANA TECH UNIVERSITY
Date: Fri, 09 Oct 92 15:14:41 CST

In article <MATSJ.92Oct6150054@ios.CMD.UU.SE>
matsj@ios.CMD.UU.SE (Mats Johnson) writes:
 
>
>
>I've tried disabling buttons from the startup script (since I didn't
>find a way to set the button disabled by default). That didn't work
>however, it seems that the layout must be displayed before the buttons
>can be disabled. I don't think it should matter what kind of procedure
>is doing the disabling, but then, you never know with 4D...
>
>A related question, I guess there is no way to disable a popup menu?
>--
>Mats Johnson, CMD, Uppsala University, Laegerhyddsvaegen 18, S-752 37 UPPSALA
>Mats.Johnson@CMD.UU.SE
 
The earliest point available for disabling a button is during the 'before'
state of the layout execution cycle.  You can test for this using 'IF (BEFORE)'
of placing ':(BEFORE)' in a case of.  'BEFORE' is a function that returns
true during the before part of the execution cycle and false otherwise.
 
Example:
 
if (before)
 
  disable button (<button name>)
 
end if
 
 
 
Bill Jamison
rwj@engr.latech.edu
st25370@vm.cc.latech.edu
Newsgroups: comp.sys.mac.databases
From: bmartin@uhunix.uhcc.Hawaii.Edu (Brian Martin)
Subject: Re: Question on 4D to Oracle
Keywords: 4D, Oracle
Organization: University of Hawaii
Date: Mon, 12 Oct 1992 13:00:35 GMT

In article <1992Oct9.153218.144@nhqvax.hq.nasa.gov> l_vu@oaetqm.hq.nasa.gov (Liem Vu) writes:
>I am currently developing systems in 4th Dimension using Apple's DAL to query 
>our Ingres database on a VAX.  I have recently found out that we will be 
>developing future database applications in Oracle on a box that is yet to be 
>determined.

Why would anyone switch from Ingres to Oracle??

>1) is 
>there still a 4D to Oracle product? and 2) Is this a better solution than 
>using 4D to DAL to Oracle?

Acius announced a 4D/Oracle interface, similar to their 4D SQL Server
product for linking 4D to Sybase. Give them a call.

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
Newsgroups: comp.sys.mac.databases
From: bmartin@uhunix.uhcc.Hawaii.Edu (Brian Martin)
Subject: Re: 4D Receive Record Command
Organization: University of Hawaii
Date: Mon, 12 Oct 1992 12:32:02 GMT

In article <28SEP199220181481@vxcrna.cern.ch> 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.
>What am I missing? Any help or more general suggestions on how to transfer
>records between separate databases?
>
>Thanks
>Sandro 

The following code should work:

default file([ImportFile])
set channel (10; "file to import")
create record

While (ok=1)
  save record
  create record
  receive record
end while

set channel (11)


Hope this works for you,

    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: mike_steiner@qm.claris.com (Mike Steiner)
Newsgroups: comp.sys.mac.databases
Subject: Re: Helix let me down, other options?
Date: 12 Oct 92 19:21:28 GMT
Followup-To: comp.sys.mac.databases
Distribution: usa

In article <1992Oct10.024702.20303@guinness.idbsu.edu>,
djensen@claven.idbsu.edu (Dave J) wrote:
> 
> I have been using Double Helix for 3 years now. One of the main reasons for
> choosing it was the ability to run a client and the server on the same machine
> (no dedicated server for the network). Well, Helix Express (new owners-new
> name) decided to eliminate that capability... without mentioning the fact in
> their upgrade offer. So, after generating a university purchase order,
> receiving the upgrade, and spending the better part of a day updating the
> existing database, trying to figure out why the client on the same machine as
> the server wouldn't function, calling their tech support, I find out the next
> day from a sympathetic tech guy... I can no longer get there from here! 
> 
> Kim at Helix Express, on the receiving end of my indignation and upon hearing
> that I might have to look into other brands, promised "you can try them, but
> you'll come back because all the others are a bitch to program."
> 
> Well, I realize we can continue as before without the upgrade, but I am,
> nevertheless, looking. Ours is a small database and network. We do not want the
> expense of a dedicated server. Are there any other relational databases that
> work without a dedicated server machine?

PMFJI, but why do you need to run a client on the same computer as the
server?  You can access the data base from the server software.  I must be
missing something here.

+---------------------------------------------------------------------+
|Now that I have a reader that can do .sigs, I can't think of a witty |
|one to put here, so I won't.  All normal disclaimers apply.          |
+---------------------------------------------------------------------+
Newsgroups: comp.sys.mac.databases
From: ajiang@lonestar.utsa.edu (Alexander X. Jiang)
Subject: Double Helix / Helix Express Opinion
Organization: University of Texas at San Antonio
Distribution: universe
Date: Sat, 17 Oct 1992 00:55:43 GMT


I've been using double helix for a while, although didn't paid much of
attention to the manuals, i'm getting some thing done quite ok (with hours of
trials and error, of course).  I'm to design a invoice system with keep track
of inventory stuff, back orders, etc.  Now Helix Tech has an offer of upgrade
to Helix Express, which has ready-to-go solutions (what they called) to these
problems, I just need some opinions about this.  Anyone?  Thanks in advance.

P.S. All I need is something that works well, not something that is fancy.
basically, a file each for clients, inventory, and invoices, and pull the
client and i  If Helix Express has ready made examples for this, i'll be
happy to take it rather than program myself.  (sales guys at Helix Tech was
telling me about their new launching features when i ask them about all this..)


inventories.

Newsgroups: comp.sys.mac.databases
From: a-kraus@uiuc.edu (Albert L. Kraus)
Newsgroups: comp.sys.mac.databases
Subject: Can't post to 4D@MIT
Date: 13 Oct 92 16:15:47 GMT
Article-I.D.: pesa.a-kraus-131092111720
Followup-To: comp.sys.mac.databases
Organization: PES

I'm receiving user group mail from the 4D group but I can't post anything
to 
4D@MIT.edu. My mail always comes back. What is the problem.
Do I need the numeric ethernet address?

Thanks!
Have a nice day!
Newsgroups: comp.sys.mac.databases