HDTenEightyP/NetNews huggingface dataset:
From: drg@biomath.mda.uth.tmc.edu (David Gutierrez)
Newsgroups: comp.sys.mac.databases
Subject: Re: Borland's new Mac offering
Date: 10 Apr 1992 19:08:03 GMT
Organization: Univ. Texas M.D. Anderson Cancer Center

In article <1992Apr7.001414.23201@nuscc.nus.sg> taihou@iss.nus.sg (Tng Tai Hou)
writes:
>Sorry if this is old news. Borland has hired ex Ashton-Tate
>Mac people to port Quattro Pro to the Mac. I dunno if
>they have anything else for the Mac. But that's the latest
>I have heard.

They don't know if they have enything else for the Mac, either. Considering
Borland's past record in the Mac market, I wouldn't touch a new Borland product
until I was convinced the company had made a commitment to support their Mac
products.

David Gutierrez
drg@biomath.mda.uth.tmc.edu

"Only fools are positive." - Moe Howard
From: rhessjr@darkside.com (Robert Hess)
Newsgroups: comp.sys.mac.databases
Subject: Re: Question about the Quicktime External for 4D
Date: 13 Apr 92 22:45:46 GMT
Organization: Independent Consultant

In article <1992Apr1.161203.3476@iscsvax.uni.edu>, hahm@iscsvax.uni.edu (Ronald Hahm) writes:
> 
> Does the new Quicktime external allow one to store still video images that are
> 200K in size, in a 4D record?  Or, does the 4D field size limit come into play
> here?

4D QuickTime externals simply hold a "pointer" to a file on disk, not the
QuickTime movie itself. Therefore, the size of the movie is (virtually)
limitless (you might have a problem around seventeen or eighteen terabytes ;).

Robert Hess
From: djwiebe@ccu.umanitoba.ca (Darren J. Wiebe)
Newsgroups: comp.sys.mac.databases
Subject: Re: FM Pro Import into repeating fields??
Date: 7 Apr 92 00:17:18 GMT
Organization: University of Manitoba, Winnipeg, Canada

In <92097.125511HLM6@psuvm.psu.edu> HLM6@psuvm.psu.edu writes:

>If you have a FM layout that looks like this:

> ========== ========== ==========
> | Field1 | | Field2 | | Field3 |
> ========== ========== ==========
>            |        |
>            ==========
>            |        |
>            ==========

>Where Field1 and Field3 are normal fields, and Field2 is a repeating field,
>your text file must look like this:

>Data1<tab>Data2a<gs>Data2b<gs>Data2c<tab>Data3

><gs> is called a "group separator.  It's ascii value (decimal) is 29.  I don't
>know how you can create this format from Excel.

Microsoft Word can cut and paste this <gs> character with no problem.  I've
done several imports into repeating fields using this.

I didn't read the original article, but if you're trying to go from Excel to 
Filemaker.  I'd create a column between each column which is to repeat, then
fill this column with a special character or series of characters '@#$'.  Then
export as a tab delimited file and load into Word.  You can then do a 
find/replace using ^t@#$^t replaced with <gs> (the special character).

I believe there is a special character option in Word to create a character 
based on it's ASCII code.  If you have problems with this, you can make a little
Filemaker db with a repeating field and export it into Word.  You will then see
this <gs> character and be able to cut and paste it...

I'd be happy to give you a further hand through E-mail...

(<=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=>)
Darren J. Wiebe                         | Internet:  djwiebe@ccu.umanitoba.ca
Box 141, Station L                      | AppleLink: CDA0010T
Winnipeg, Manitoba, Canada  R3H 0Z4     | Quote: 'scuse me,
Disclaimer:  Disclaimer!  I don't need  |            while I puke and die!
              no stinkin' disclaimer!   |                   -The Dead Milkmen
(<=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=>)
Newsgroups: comp.sys.mac.databases
From: bob@iastate.edu (Robert P Kuehne)
Subject: foxbase/mac
Organization: Iowa State University, Ames IA
Date: Sat, 11 Apr 1992 20:08:17 GMT

Hi there.  I'm a novice Foxbase/Mac user.  I like it, but the program is
more complext than I imagined.  Still...have a simple problem:  it seems
that field entries are case sensitive, so that searching requires
knowlege of case.  Is there a way to de-case-sensitize a search, so that
whether I spell with upper or lower, the search will find the
appropriate items.  If you know how to do this, please adivse.  I can't
find the right switch.

Thanks again.
-- 
 -----------------------------------------------------------------------------
|   |)  |		"Oh, it's _you_, Bob!"		     Robert P. Kuehne |
|   |)()|)		  - That Commmercial		     bob@iastate.edu  |
 -----------------------------------------------------------------------------
Newsgroups: comp.sys.mac.databases
From: nettles@software.org (David Nettles)
Subject: database
Keywords: request database help
Organization: Software Productivity Consortium, Herndon, Virginia
Date: Tue, 7 Apr 1992 13:54:50 GMT


-- 

I would like to request some help from the readers of this newsgroup.

We are going to do a project in which we need a database that runs on a
Mac(specifically, Mac IIcx, 8/105, color).  I am quite familiar with the Mac
but know almost nothing about database offerings on Mac and am
soliciting you help in identifying a suitable package.

As far as databases go, I also have quite a bit of experience there, having
been a DBA and data administrator for a multi-gigabyte IBM mainframe DBMS.
Additionally, managed implementation of a CASE tool fitted over a UN*X 
relational database (client-server).

What am I looking for?  A database with a good graphical interface and a
C/C++ programmatic interface. We plan to use it to enter information and
then run a set of programs over the database to determine if the information
is consistent and complete.  The database will not be very large but we
need to have good data entry capability.  To be more specific:

MUST

  relational with SQL or SQL like data definition and manipulation language
   with the capability to do selects and joins of tables

  graphical user interface

  report writer

  C/C++ programmatic interface

  scripting capability

  ability to do complex data validation on entry of data (i.e. database or
    user interface "trigger" that does that data validation)

  handle 40 tables

  handle approximately 10 meg database (small)

  largest table will have approx 500-700 rows

  NO COPY PROTECTION (never seen one that wasn't a pain.  We will buy all 
    copies we use)

DESIRED (but not required)

  hypercard interface

  single package (i.e. all features in one vendors package)

  portable to UN*X platforms

  multi-user

  cost < $500 per user

Please send any recommendations to me at 

  nettles@software.org

If the replies merit, I will summarize and post.

Thanks,

David Nettles

---

David W. Nettles
Software Productivity Consortium, Inc.
2214 Rock Hill Road
Herndon, VA 22070    

703-742-7255 (voice)
nettles@software.org
Newsgroups: comp.sys.mac.databases
From: taihou@iss.nus.sg (Tng Tai Hou)
Subject: Borland's new Mac offering
Originator: taihou@shankar
Organization: Institute of Systems Science, NUS, Singapore
Date: Tue, 7 Apr 1992 00:14:14 GMT

Sorry if this is old news. Borland has hired ex Ashton-Tate
Mac people to port Quattro Pro to the Mac. I dunno if
they have anything else for the Mac. But that's the latest
I have heard.
From: cory@enigami.mv.com (Cory Kempf)
Newsgroups: comp.sys.mac.databases
Subject: Re: Borland's new Mac offering
Date: Sun, 12 Apr 92 13:10:49 EST
Organization: EnigamI, Inc., Nashua, NH
Reply-To: cory@enigami.mv.com
X-Mailer: uAccess - Macintosh Release: 1.5v5


In article <1992Apr7.001414.23201@nuscc.nus.sg> (comp.sys.mac.databases), taihou@iss.nus.sg (Tng Tai Hou) writes:
>Sorry if this is old news. Borland has hired ex Ashton-Tate
>Mac people to port Quattro Pro to the Mac. I dunno if
>they have anything else for the Mac. But that's the latest
>I have heard.

I think that Borland will have a very hard time selling into the Mac
market again.  Borland produced several fairly nice Mac products (Reflex
Plus comes to mind, as does SideKick, and Turbo Pascal), and then dumped
them, leaving the users without any support, without any upgrade path.

I don't think that I would be willing trust a Borland Mac product.
I certainly would not recommend that anyone else take such a risk
either.

+C


-------------------------------------------------------------
Cory Kempf                    EnigamI, Inc.
cory@enigami.mv.com           ...!decvax!enigami!cory
Microsoft Free and Proud Of It!... 
                           ...Microsoft Products: Just Say no.
From: macfitz+@pitt.edu (Mark D Fitzsimmos)
Newsgroups: comp.sys.mac.databases
Subject: 4D questions
Date: 13 Apr 92 21:57:47 GMT
Organization: University of Pittsburgh



I have a few questions on using 4th Dimension; I'm using 2.1.1.

1) Double clicking in an empty region of an included file brings up a 
programmer-definable input layout for entering a new record.  This is a 
useful interface property.  Unfortunately, 4D stays in an infinite record 
input loop until the user selects "Cancel".  I have found that users are 
confused by this, particularly since they get no acknowledgment that 
their record was entered (except that the fields in the layout are 
cleared).  I want the program to return to the original layout in 
response to either a save or a cancel (i.e., add only one record in the 
included file).  Is there any way to do this?

2)  I understand that the scripting language does not include message 
passing capabilities (such as Hypercard objects have).  Nevertheless, I 
have encountered several cases where it would be useful to execute 
object scripts from procedures.  Can this be done?

3)  I would like to integrate bar code printing and reading into a 4D 
database used for inventory and shipping control.  Does anyone have 
experience with bar codes and 4D?  Since the data is for internal use 
only, no special codes (e.g., UPC) are required.  I presume I just need to 
add a font in order to do the printing part.  Are there any freeware bar 
code fonts?  The input side might be a little tougher.  Can a bar code 
device (presumably attached via the ADB) be easily interfaced with 4D?  
Can anyone recommend a particular vendor?  

4)  Has anyone used the 4D front end available from Natural 
Intelligence?  I think it got pretty good reviews in one of the popular 
trades, but some independent verification would be reassuring.


Thanks.


Mark Fitzsimmons
From: rhessjr@darkside.com (Robert Hess)
Newsgroups: comp.sys.mac.databases
Subject: RE: 4D QuickTime Externals
Date: 13 Apr 92 23:00:27 GMT
Organization: Independent Consultant

ACIUS' QuickTime Externals for 4D do not store MooVs inside of 4D data files.
Instead, the fields of a data file maintain "pointers" to the actual MooVs on
disk; therefore, no additional restriction is placed on the use of QuickTime.

Robert Hess
From: rhessjr@darkside.com (Robert Hess)
Newsgroups: comp.sys.mac.databases
Subject: Re: 4th Dimension Server
Date: 8 Apr 92 21:58:48 GMT
Organization: Independent Consultant

In article <1992Apr1.234805.13224@digtype.rochester.ny.us>, jeff@digtype.rochester.ny.us (Jeff Wasilko) writes:
> 
> Can the server run more than one database at a time, or are you
> limited to one database/cpu?

Each server can only run one structure; however, one Mac can run multiple
copies of the Server. Licensing (whether or not you'll be able to run multiple
copies of the SAME Server on the same Mac) is being discussed.

> Has Acius made any official remarks about the server other than the PR
> stuff that was in MacWeek a while ago? With something this major
> coming down the pike it'd be nice to plan for it...

ACIUS DevCon was the place to be for news. Several people (including me) wrote
articles about it and put them on CompuServe in the ACIUS Forum. I'll be more
than happy to discuss what I can if you ask the questions; don't be surprised,
though, if I am unable to discuss specific points.

Robert Hess
From: pgk@pacersoft.com (Paul Kamp)
Newsgroups: comp.sys.mac.databases
Subject: Foxbase & DAL
Date: 14 Apr 92 12:48:59 GMT
Organization: Pacer Software, Inc.

Does anybody know whether Foxbase for the Mac support DAL?  Fox is listed in
Apples list of vendors who support the DAL client within their application.
I stopped by their booth at DB/Expo but know one there seemed to know for sure.
To be fair they were quite distracted by the news that they had been bought by
Microsoft so there was alot of activity in their booth.

e-mail responses would be fine.  Thanks in advance.

Paul Kamp
Pacer Software, Inc.
pgk@pacersoft.com
Xref: sparky comp.sys.mac.databases:458 comp.sys.mac.apps:7973 comp.sys.mac.misc:9168
From: geoff@loki.une.edu.au (Geoff Hill)
Newsgroups: comp.sys.mac.databases,comp.sys.mac.apps,comp.sys.mac.misc
Subject: Re: wanted: info on "Church Management" software for Macs
Date: 15 Apr 92 09:03:11 GMT
Followup-To: comp.sys.mac.databases
Organization: University of New England - Northern Rivers, (Lismore)

From article <1992Apr11.181129.22693@cs.rochester.edu>, by bukys@cs.rochester.edu (Liudvikas Bukys):

1.	DISCLAIMER: I am not affiliated with any church and/or religious order.
	I guess I'm an agnostic.

I read an article in AUSTRALIAN MACWORLD (March 1992).
The Rev. Paul Harrison
Senior Pastor, City Tabernacle
Baptist Church, Brisbane.
Enquiries to: 42 Birra ST. West Chermside Q4032.

Has created a Hypercard stack which he claims does the following;
Tracks members and adherants, baptisms, weddings, funerals, home visits,
occupations, church duties, financial pledges etc, etc, etc.

I hope this helps.
-- 
 Geoff Hill					Phone : 066 - 203824          
 University of New England - Northern Rivers.	Fax   : 066 - 221724          
 Lismore Australia.				E-mail:geoff@loki.une.edu.au  
 " Paradise is exactly like where you are right now, only much much better "
Newsgroups: comp.sys.mac.databases
From: rhessjr@darkside.com (Robert Hess)
Newsgroups: comp.sys.mac.databases
Subject: RE: 4D QuickTime Externals
Date: 13 Apr 92 23:00:58 GMT
Organization: Independent Consultant

ACIUS' QuickTime Externals for 4D do not store MooVs inside of 4D data files.
Instead, the fields of a data file maintain "pointers" to the actual MooVs on
disk; therefore, no additional restriction is placed on the use of QuickTime.

Robert Hess
From: rhessjr@darkside.com (Robert Hess)
Newsgroups: comp.sys.mac.databases
Subject: Re: 4th Dimension Server
Date: 13 Apr 92 22:58:15 GMT
Organization: Independent Consultant

In article <1992Apr9.173127.25540@dartvax.dartmouth.edu>, hades@coos.dartmouth.edu (Hades) writes:
> 
>     Nope, although I remember reading that they did a demo at one of the
> major conventions (CeBit I think) and the reviewer thought that it was a
> vast improvement.

ACIUS is doing a demo for the Seattle DBUG tonight. I would STRONGLY advise
that those who can go, do.

Robert Hess
From: steve@work.berkeley.edu (Steve Goldfield)
Newsgroups: comp.sys.mac.databases
Subject: Re: foxbase/mac
Date: 15 Apr 92 17:36:36 GMT
Article-I.D.: agate.shpj4INNpv8
Organization: /etc/organizaton
NNTP-Posting-Host: work.berkeley.edu

In article <1992Apr13.140116.16963@midway.uchicago.edu> ejw1@midway.uchicago.edu writes:
#>In article <bob.703022897@vincent1.iastate.edu> bob@iastate.edu (Robert P Kuehne) writes:
#>>Hi there.  I'm a novice Foxbase/Mac user.  I like it, but the program is
#>>more complext than I imagined.  Still...have a simple problem:  it seems
#>>that field entries are case sensitive, so that searching requires
#>>knowlege of case.  Is there a way to de-case-sensitize a search, so that
#>>whether I spell with upper or lower, the search will find the
#>>appropriate items.  If you know how to do this, please adivse.  I can't
#>>find the right switch.
#>
#>Sorry, Bob, there is no 'switch' which you can set to turn case-sensitivity on 
#>or off.  No, you have to do everything manually.  You need to use the UPPER() 
#>or LOWER() functions to force the strings to either case and then search on 
#>them.  For example:

An additional suggestion: I also index on UPPER(key) for the
same reason and then SEEK (or FIND) also on an UPPER(expression).
It makes life a bit easier if you choose a convention at the
start and stick to it.

Steve Goldfield
Newsgroups: comp.sys.mac.databases
From: macman@bernina.ethz.ch (Danny Schwendener)
Subject: Re: db_VISTA, Ajalon Corp
Organization: Peppermint Software Inc.
Distribution: comp
Date: Fri, 10 Apr 1992 23:29:26 GMT

marc@qcc-hal.UUCP (Marc St-Jean) writes:

>I've heard that db_Vista is one of the fastest DB Engines.
>Could someone that has some experience with it please comment.

DB-Vista is based on the network model. This means very
high speed. The drawback is that you need to rebuild your
database each time you change the record structure. When developing
vertical applications, you can live with that easily.

The product is C-based. 


>Also, I tried reaching their phone & fax numbers with no luck.
>Even the local information don't have a listing for Ajalon Corp.

Ajalon was the distributor. They went burp, I think. You should contact
directly Raima Corp. who developed the product. They're somewhere up in
the state of Washington, but I don't have the address off hand. If you
have an Applelink account, check the TechInfo Library for "Raima". 
They're in there. They can also be reached on CompuServe, AOL and
AppleLink, btw.


-- Danny
From: steve@work.berkeley.edu (Steve Goldfield)
Newsgroups: comp.sys.mac.databases
Subject: Re: Foxbase & DAL
Date: 15 Apr 92 17:44:54 GMT
Article-I.D.: agate.shq2mINNq1l
Organization: /etc/organizaton
NNTP-Posting-Host: work.berkeley.edu

In article <646@pacvax.UUCP> pgk@pacersoft.com (Paul Kamp) writes:
#>Does anybody know whether Foxbase for the Mac support DAL?  Fox is listed in
#>Apples list of vendors who support the DAL client within their application.
#>I stopped by their booth at DB/Expo but know one there seemed to know for sure.
#>To be fair they were quite distracted by the news that they had been bought by
#>Microsoft so there was alot of activity in their booth.
#>
#>e-mail responses would be fine.  Thanks in advance.
#>
#>Paul Kamp
#>Pacer Software, Inc.
#>pgk@pacersoft.com

I was told at the Fox booth at DB Expo that FoxPro for the
Mac will support DAL, whenever it is released. (It's been
expected for a long time.) However, I saw a DAL server
called Butler from Everyware (416/819-1173), which purports
to act as a DAL server for any Mac software. They didn't
have a FoxBase demo running but claimed that the product
would work with FoxBase. Their literature, however, lists
Excel, HyperCard, 4th Dimension and other programs but not
FoxBase.

I'm still pursuing this issue, but my emphasis has been on
the other end, how to get DAL to access an Ingres database
running on a VAX running Ultrix. My understanding is that Pacer
will eventually supply such a server. Apple tells me that
Ingres can also create one if they wish (Ingres told me they
are). Also, there are apparently non-DAL servers, such as
GQL, which may fill the gap.

Steve Goldfield
College of Engineering
UC Berkeley
Newsgroups: comp.sys.databases,comp.sys.mac.databases
From: ec333way@sail.uwaterloo.ca ()
Subject: Info on FoxBase/Mac
Originator: ec333way@sail.uwaterloo.ca
Organization: University of Waterloo
Date: Mon, 6 Apr 1992 04:27:22 GMT

I need to find out some info about foxbase+/mac..
I have a need to generate a spreadsheet like window/screen and put data
values in these fields. I don't need to do any calculations or anything of that sort on the values, I just need to know which one the user clicked on, and to
be able to match that up to the value contained/displayed in that cell... 
My question is NOT how to do this, but is is possible? Ie. can I at least get
screen coordinates for mouse clicks, or better, assign a value to each cell and
get that value returned when the user selects it? As long as it _CAN_ be done,
that's all I need to know.

Thanks,
-- 
Mattias Hembruch
mghembruch@electrical.watstar.uwaterloo.ca
or ec333way@sail.uwaterloo.ca
Newsgroups: comp.sys.mac.databases
From: ejw1@kimbark.uchicago.edu (Eric Weidl)
Subject: Re: FAQ on database
Reply-To: ejw1@midway.uchicago.edu
Organization: Academic and Public Computing
Date: Wed, 8 Apr 1992 13:50:43 GMT

In article <1992Apr6.172613.22537@microunity.com> tomho@microunity.com (Tom Ho) writes:
>Hi
>I don't usually have a chance to read this news group often enough but I am 
>very interested in the subject.  Is there a FAQ file/news for this group?  

Unfortunately, not.  Maybe we should create one.

>Espcially if someone has a summary of pro's and con's for different Mac 
>databases.

Since that question is the most frequently asked, I think it would be on top
of the list.

>Also, anybody knows of a good graphic/visual application sofware to do data 
>analysis (toward the scientific statistical end ...)?

DeltaGraph is a nice data-graphing package from DeltaPoint Software.  If you 
want to do some statistical analyses, there are a number of packages
available.  One which looks very nice on paper is Statistica/Mac.  Also, 
there's DataDesk, Systat, JMP, SAS, SPSS, StatView.  There should be reviews 
of most of these products in recent issues of the big magazines.
 
>I will summarize if sufficient responses are received.
>--
>     Tom Ho       tomho@microunity.com       (408) 734-8100

Eric

-- 
===================================================================
               Eric Weidl    e-weidl@uchicago.edu
      University of Chicago -- Academic and Public Computing
===================================================================
Xref: sparky comp.sys.mac.databases:434 comp.sys.mac.apps:7830 comp.sys.mac.misc:8997
From: bukys@cs.rochester.edu (Liudvikas Bukys)
Newsgroups: comp.sys.mac.databases,comp.sys.mac.apps,comp.sys.mac.misc
Subject: wanted: info on "Church Management" software for Macs
Date: 11 Apr 92 18:11:29 GMT
Organization: Computer Science Department University of Rochester

My church is contemplating a conversion to Macs (from PCs).
We currently have a "church management" program which keeps track of three areas:

1. accounting, financial reporting
2. member/contributor database
3. interactions between the two

We're looking for something similar on the Mac.

I've thought about using some general purpose packages, but it seems hard
because most accounting programs do databases poorly (or not at all), and
most databases would be excruciating for use as accounting programs.  On
the other hand, it is very desirable to be able to export information to
other programs.

Any suggestions/experience/ideas would be appreciated.


Liudvikas Bukys
bukys@cs.rochester.edu
From: desavouret@fnalb.fnal.gov (Gene Desavouret 4402, 3700)
Newsgroups: comp.sys.mac.databases
Subject: CMMS
Date: 8 Apr 92 15:04:40 GMT
Reply-To: desavouret@fnalb.fnal.gov
Organization: Fermi National Accelerator Laboratory
News-Software: VAX/VMS VNEWS 1.4-a4

We are looking for Computerized Maintenance Management Systems software
to aid us in physical plant/building maintenance.  There are hundreds of
CMMS applications available for the Intel 80x86 machines, but we need one
that runs on a Macintosh.  The application language isn't restricted, but
we have several people with Double Helix programming experience.

---------------------------------------------------------------------------
Gene Desavouret, Fermilab Technical Support/Magnet Test Facility
                 P.O. Box 500, M.S. 344,  Batavia, IL, 60510
---------------------------------------------------------------------------