HDTenEightyP/NetNews huggingface dataset:
From: sandrov@vxcrna.cern.ch (VENTURA,SAND./EP)
Subject: Re: 4D Receive Record Command
News-Software: VAX/VMS VNEWS 1.41    
Organization: European Organization for Nuclear Research, CERN
Date: Tue, 29 Sep 1992 10:20:00 GMT

In article <michaelh.717718108@Xenon.Stanford.EDU>, michaelh@Xenon.Stanford.EDU (Mike Hennahane) writes...
>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.

In fact the example in the manual shows how to receive by creating a new record.
But the description of the command (I'm one of the lucky men which works
with a reference manual in french, while scripting in english :-)
states "Si vous recevez cette fiche dans une fiche existant deja, les
anciennes valeurs des rubriques seront remplacees par les valeurs recues 
(i.e. If you receive a record into an existing record, old field values
will be replaced by received ones)". Which seems to be doubtless! Moreover, in 
the multiuser section there is a warning about being sure to work on a 
non-locked current record when receiving...
> 
>>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
I'm keeping in sync a database running on non-networked machines. So I have to
receive new records, update old ones or delete some of them, which I try to do 
by the means of a file which contains the variables and records needed for this
task. Transferring new records and deleting works fine, updating existing ones
could be done by searching the record, deleting it and receiving the updated
version. But this scramble a little bit the "sequence number" function, on
which other scripts of the database rely. Ok, this can be fixed anyway, but the
sake of knowledge (or the lazyness...) made me wishing to understand why the 
receive command didn't work as described (and as wished)...

Sandro
From: unregistered@newcastle.ac.uk (Tony McDonald)
Newsgroups: comp.sys.mac.databases
Subject: Recommendations: Mac and PC DB's?
Date: 5 Oct 92 14:05:00 GMT
Followup-To: comp.sys.mac.databases
Organization: Newcastle Uni. Computing Services

Hi,
Can anyone give me some recommendations for Databases that will allow users
to access the same data from both a Mac and a PC?.

The central database file could be on a server (Novell etc) or perhaps on
one of the machines (ie PC or Mac) Hard Disks.

Thanks for any info...
Tone.

-----------------------------------------------------------------
Tony McDonald (Tone)                       Tony.McDonald@ncl.ac.uk
Computing Officer - Apple Mac Support      namm2@ncl.uk.ac
Newcastle University, NE1 7RU, UK
From: pamiri@uci.edu (Peter Amiri)
Subject: Re: 4th Dimension
Newsgroups: comp.sys.mac.databases
Organization: Dimensional Software
Date: 28 Sep 92 21:23:29 GMT

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
Xref: sparky comp.sys.mac.databases:1249 comp.sys.mac.apps:15380
From: minow@Apple.COM (Martin Minow)
Newsgroups: comp.sys.mac.databases,comp.sys.mac.apps
Subject: Re: Published 'FileMaker Pro 2.0' Reviews?
Date: 6 Oct 92 16:03:11 GMT
Organization: Apple Computer Inc., Cupertino, CA


khj@cs.appstate.edu (Kenneth H. Jacker) asks for a review of FileMaker PRO
2.0. I just upgraded last week so here are some brief first impressions:

-- it seems a bit faster and more responsive when fiddling with layouts,
but I haven't tried it on anything elaborate.

-- there is good support for AppleEvents, including some sample scripts
that let FileMaker pass data from a database to Resolve or Excel (scripts
for both spreadsheets are provided). You can also drive FileMaker from
an AppleEvent script.

-- the scripting language was completely redone. You can treat scripts as
a pseudo-programming language. (However, you "write" scripts by clicking
on menu and widget items: you don't really "type" scripts as you would
Hypercard.)

-- the dialog that defines expressions hasn't changed, but the expression
window got larger.

-- FMPro now supports half of the edition manager (I don't remember whether
it's publish or subscribe, but I'm pretty sure it's subscribe.)

-- There are lots of new sample scripts, including an incredible (consise,
yet detailed) introduction to AppleEvents and the Object Model. That, in
itself, is worth the price of admission.

-- No trouble converting my old databases, but you can't convert back.

The upgrade was, as I recall, $89. plus tax and shipping.

Hope this helps.

Martin Minow
minow@apple.com
The above does not represent the position of Apple Computer Inc.
From: mk46+@andrew.cmu.edu (Matthew E. Kowalczyk)
Newsgroups: comp.sys.mac.databases
Subject: Re: Recommendations: Mac and PC DB's?
Date: 6 Oct 92 10:17:38 GMT
Article-I.D.: andrew.QeoRV2200WBNA48oEz
Organization: Junior, Social & Decision Sciences, Carnegie Mellon, Pittsburgh, PA

In a related question how well is the compatibility between FoxPro for
IBM and FoxBase+ for the mac?

Are programs, databases, screens, easily portable from FoxBASE to FoxPro?

How much would I have to change, and what would I have to change in
order to convert from FoxBASE+ to FoxPro?

Thanks in advance,
     Matthew Kowalczyk     Carnegie Mellon University   mk46+@andrew.cmu.edu
-------------------------------------------------------------------------------
"...In a good way. 10 songs. Spontaneous. Creation. Emotion. Very
pleasing. Real Music. No analyzing. No pressure. No hype. Just music to
make music. Friends and a reason. Chemistry. Beauty. Life Rules!" -Jeff
Ament (Temple of the Dog)
-------------------------------------------------------------------------------
From: mm5l+@andrew.cmu.edu (Matthew Mashyna)
Newsgroups: comp.sys.mac.databases,cmu.comp.sys.mac
Subject: Re: 4D buttons
Date: 29 Sep 92 15:42:52 GMT
Organization: Psychology, Carnegie Mellon, Pittsburgh, PA

Dave,

Generate a layout for one of your files using the prefab, large buttons
-- you know the ones with the garbage can and the disk icons.

Then edit it. These buttons are actually invisible buttons on top of
picts. I use SuperPaint to make new button pictures, paste them into a
4D layout and put an invisable button on top.

I'm sorry that I'm not sure if they are called "invisble buttons" but
you'll figure it out from the dialog when you create a new item. You may
have to ungroup the prefab buttons to pick them apart. 


Matt
Xref: sparky comp.sys.mac.databases:1218 comp.sys.novell:7758
From: dak@boomerang.com (David A. Kearney)
Newsgroups: comp.sys.mac.databases,comp.sys.novell
Subject: Looking for Netware/SQL/DAL server
Date: Tue, 29 Sep 92 12:50:30 PST
Organization: Boomerang Information Services
Reply-To: dak@boomerang.com (David A. Kearney)
X-Mailer: uAccess - Macintosh Release: 1.5v4

Greetings,

Can someone give me the latest list of SQL database servers that run
as Netware Loadable Modules(NLM) that have a DAL interface?  I know
of 2: Netware SQL and Oracle.  Are there some new ones coming out?

thanx

Dave

-----------------------------------------------------------------
David A. Kearney, (415) 390-8515
Boomerang Information Services
Fax Broadcasts, Automated Fax Retrieval, and Fax Mailbox Services
Newsgroups: comp.sys.mac.databases
From: bronson@latech.edu (Patrick K. Bronson)
Subject: Re: 4th Dimension
Organization: Louisiana Tech University
Date: Tue, 29 Sep 1992 17:37:29 GMT

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
From: jwa@vipunen.hut.fi (Jyrki J Wahlstedt)
Newsgroups: comp.sys.mac.databases
Subject: DAL and else
Date: 30 Sep 92 00:02:20 GMT
Distribution: comp.sys.mac.databases
Organization: Helsinki University of Technology, Finland


  I just wanted to get answers to two questions I have in mind:
  1) For how many platforms do there exist DAL servers? (I summarise,
    if needed)
  2) Is there any product with which one could connect to SQLBase db's
    (you know the db server from Gupta)? Or an alternative question:
    What products are there with which you can build client-server type
    database applications? (I summarise, if at least two answers appear:-)
--
!
!	Jyrki Wahlstedt
!		Jyrki.Wahlstedt@hut.fi
!
!  Our life is no dream, but it should and will perhaps become one.
!
From: pgk@pacersoft.com (Paul Kamp)
Newsgroups: comp.sys.mac.databases
Subject: Re: Data bases for A/UX
Date: 28 Sep 92 14:39:38 GMT
Followup-To: comp.sys.mac.databases
Organization: Pacer Software, Inc.

In article <oekSO8i00iVgA1bfc4@andrew.cmu.edu>, mm5l+@andrew.cmu.edu
(Matthew Mashyna) wrote:
> 
> Can anyone recommend (or even list some) multi-user database for A/UX ?
> I need to share information between a small group. Ideally I'd like to
> use DAL to access files on a server.

Apple sells DAL Server software for A/UX.  It is listed on page 86 of the
most recent APDA catalog and costs $995.  It does not list what type of
host database you can connect to though.  Apple usually charges for the
database adapter separately.

If you are looking at Unix machines in general, not just an A/UX machine we
have a DAL Server for Unix that runs on the Sun SPARC, HP 900/800(700) and
IBM RS/6000.  That databases we support are Oracle, Ingres, Informix and
Sybase.  The network adapters we support are asynch and TCP.


Paul Kamp
Pacer Software, Inc.
Internet: pgk@pacersoft.com
AppleLink: PACER
From: hades@coos.dartmouth.edu (Hades)
Newsgroups: comp.sys.mac.databases
Subject: Re: Recommendations: Mac and PC DB's?
Date: 5 Oct 92 20:50:04 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

unregistered@newcastle.ac.uk (Tony McDonald) writes:

>Hi,
>Can anyone give me some recommendations for Databases that will allow users
>to access the same data from both a Mac and a PC?.

>The central database file could be on a server (Novell etc) or perhaps on
>one of the machines (ie PC or Mac) Hard Disks.

    If you have no need for complex relational set-ups then FileMaker
Pro 2.0 is the most cost-effective solution to a networked database that
can be accessed by both Macs and PCs running Windows. Otherwise your
only alternatives at the moment are Omnis 7 and Oracle, both of which
are quite expensive. If your feeling daring, you can always wait until
Microsoft releases the new version of FoxPro for both Mac and Windows.

--
-Hades (Brian V. Hughes) 
   "You know Television has gone to hell when, with every commercial,
	 you find yourself hoping to see the Energizer Bunny."
From: jh62+@andrew.cmu.edu (Jason Andrew Herman)
Newsgroups: comp.sys.mac.databases
Subject: 4th Dimension -- Disable Button
Date: 3 Oct 92 06:49:42 GMT
Article-I.D.: andrew.genPA6q00iUzA1VVBc
Organization: Senior, Social & Decision Sciences, Carnegie Mellon, Pittsburgh, PA

Hello Everyone,

I am having a problem disabling 4th dimension buttons.  Is there a
specific place that I have to disable the buttons (ie. Only in layout
procedure).  Currently, i am using a global procedure an saying "DISABLE
BUTTON(button)", pretty standard stuff huh.  However, my button will not
become disabled.  I am 
currently using 4th Dimension v2.2.1.


If anyone out there could help me I would greatly appreciate it.

     Thanks in advanced,


            Jason Herman
Newsgroups: comp.sys.mac.databases
Distribution: world
From: Michael_R._Schumann@bmug.org
Organization: BMUG, Inc.
Date: Thu, 01 Oct 1992 09:25:35 PDT
Subject: Re: 4D Compiler

>>>asking about compiler

>>saying compiling alone does not increase speed much.

>best performance is obtained by declaring string variables with the
minimum length
required.

It is also very important to declare the variable used in for loops as
an interger. If the variable is allowed to be the default of real, there
is a great speed hit.

A number of databases I've written aren't practical to use without being
compiled because they would be too slow (even on a IIci); compiled, some
sections run a good 20+ times faster. The speed improvement comes when
there are long scripts, working with arrays, variables etc. It does not
help with searching, sorting, loading and saving.

Best wishes,

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.
***************************************************************************
From: pascal@CAM.ORG (Pascal Gosselin)
Newsgroups: comp.sys.mac.databases
Subject: Omnis 7 - Good DAL solution or not ?
Keywords: omnis 7 DAL
Date: 2 Oct 92 15:32:56 GMT
Organization: Communications Accessibles Montreal, Quebec Canada

A while back, I read (and got emailed) a bit on information regarding
Omnis 7's DAL capabilities.  Someone here claimed that OMNIS 7 only supported
primitive SQL SELECT statements and was thus not the 'do-it-all' front
end that Bylth may have been claiming.

There is now "omnis 7 plus" (is it shipping?).  I'd like to know if has
better DAL capabilities.

-Pascal

-- 
+--------------------------+-------------------------------------------------+
    Pascal Gosselin        |     Communications Accessibles Montreal  
    pascal@CAM.ORG         |  A non-profit corporation.  Newsfeeds & More.   
  Apple Support Specialist |  For info: info@CAM.ORG or Voice (514) 923-2102 
Newsgroups: comp.sys.mac.databases
From: ST25370@VM.CC.LATECH.EDU
Subject: Re: 4D Receive Record Command
Organization: LOUISIANA TECH UNIVERSITY
Date: Tue, 29 Sep 92 08:00:11 CST

In article <29SEP199211203420@vxcrna.cern.ch>
sandrov@vxcrna.cern.ch (VENTURA,SAND./EP) writes:
 
>
>In article <michaelh.717718108@Xenon.Stanford.EDU>, michaelh@Xenon.Stanford.EDU (Mike Hennahane) writes...
>>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.
>
>In fact the example in the manual shows how to receive by creating a new record.
>But the description of the command (I'm one of the lucky men which works
>with a reference manual in french, while scripting in english :-)
>states "Si vous recevez cette fiche dans une fiche existant deja, les
>anciennes valeurs des rubriques seront remplacees par les valeurs recues
>(i.e. If you receive a record into an existing record, old field values
>will be replaced by received ones)". Which seems to be doubtless! Moreover, in
>the multiuser section there is a warning about being sure to work on a
>non-locked current record when receiving...
>>
>>>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
 
<Stuff Deleted>
 
 
With version 2.2.x (maybe 2.1, I don't remember), the recieve record no longer
requires you to create a new record to recieve into.  This is automatically
done by recieve record.  In english:  recieve record now automatically creates
a new record.  You still must execute save record to ..ahem.. save the record.
 
 
Bill
st25370@vm.cc.latech.edu
rwj@engr.latech.edu
Newsgroups: comp.sys.mac.databases,cmu.comp.sys.mac
From: bronson@latech.edu (Patrick K. Bronson)
Subject: Re: 4D buttons
Organization: Louisiana Tech University
Date: Tue, 29 Sep 1992 17:42:51 GMT

In article <Aem06s200iUxE8u10f@andrew.cmu.edu> David Tsai <dt1n+@andrew.cmu.edu> writes:
>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
>

Use a paint program to create an item that looks like the button you want.
Cut the object and paste it onto the layout you are working on.  Now create
a highlight button with a script that will perform the action you want.  Place
the highlight button over the graphic you created of a button.  Resize it 
so that it fits over the graphic.  I very rarely use the generic buttons
that are available in 4D.  I have a graphic library of standard buttons
that I keep in my scrapbook.  Works out great every time.


-- 
-----------
Pat Bronson (bronson@engr.latech.edu)
  "Are you going to come quietly or do I have to use earplugs?"
                                                    ---- From The Goon Show
From: n3x092@rick.cs.ubc.ca (Geoff Lloyd Burian)
Newsgroups: comp.sys.mac.databases
Subject: Re: Omnis 7 & XCMD's
Date: 29 Sep 1992 11:37:05 -0700
Organization: Computer Science, University of B.C., Vancouver, B.C., Canada
NNTP-Posting-Host: gambier.rick.cs.ubc.ca

In article <BvBzwA.46G@cs.vu.nl> fstiva@cs.vu.nl (Stiva F) writes:
>Hi,
>
>Does anyone know the format of Omnis 7 XCMD's?
>The Omnis 7 kit does not include any information about XCMD's
[....]
>Thanks in advance.
>
>Fulco Stiva

I believe the header file and instructions for building Omnis extensions
are included in the Omnis 7 Plus kit, but not in the regular development
kit. You might try phoning Blyth (in the U.K.) and asking them about it.
Anyone know if Blyth has an e-mail address?

Geoff Burian
From: dt1n+@andrew.cmu.edu (David Tsai)
Newsgroups: cmu.comp.sys.mac,comp.sys.mac.databases
Subject: Re: 4D buttons
Date: 29 Sep 92 18:27:43 GMT
Article-I.D.: andrew.EemF2Ta00WBO48NGQ_
	<1992Sep29.174251.5600@engr.latech.edu>
Organization: Senior, Social & Decision Sciences, Carnegie Mellon, Pittsburgh, PA

Thanks everyone.  I thought I had tried the invisible button, but what I
really did was to make a normal button white.  Everytime I was going to
click on the button, this big ugly white spot appeared over the picture.
   I didn't realize that there was actually a button that was invisible.
 I feel really stupid.  I learned my lesson to pay more attention to
detail. :}

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
From: einhorn_d@apsicc.aps.edu (E. Drew Einhorn)
Newsgroups: comp.sys.mac.databases
Subject: DAL questions
Date: 6 Oct 92 16:46:00 GMT
Organization: Albuquerque Public Schools - Career Enrichment Center
News-Software: VAX/VMS VNEWS 1.41

Can anybody provide me with a list of Mac applications which
support access to databases residing on a DAL server?  

I know 4D supports them but I was burned so badly on 4D 1.0 that I really
don't want to do business with Acius. 

Does Filemaker Pro support DAL access?

We will be experimenting with a beta version of the Deltek accounting system
with the Deltek Database Link.  The bean counters at the other end of the
building have been using a production PC LAN based Deltek system for a
couple of years now.  They are not willing to undergo the trauma of converting
to a different accounting system.

The Database Link product moves their data files into a Novell Btrieve 
environment and provides a Netware SQL data dictionary.  Novell's Netware 
SQL product includes a DAL server enabling access to this data from 
Macintosh clients.  

One of the goals of this exercise is to integrate a project control system
with the accounting system.  MacProject is one of the candidates.  How
difficult is it to get data into a MacProject system.  It would be ideal
if we could just create a data dictionary with appropriate views to support
MacProject based on the Deltek data dictionary and be done with it.  But
I suspect that someone is going to have to remember to invoke the right
incantations to export and import data at the right time.  


Thanks,
Drew Einhorn
einhorn_d@apsicc.aps.edu
From: matsj@ios.CMD.UU.SE (Mats Johnson)
Newsgroups: comp.sys.mac.databases
Subject: Re: 4th Dimension -- Disable Button
Date: 6 Oct 92 15:00:54
Organization: CMD - Center for human computer studies, Uppsala University
Reply-To: Mats.Johnson@CMD.UU.SE
NNTP-Posting-Host: ios.cmd.uu.se
In-reply-to: jh62+@andrew.cmu.edu's message of 3 Oct 92 06:49:42 GMT


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
Newsgroups: comp.sys.mac.databases
From: Shariar Jahromi <Shariar_Jahromi@mentorg.com>
Subject: Help wanted - Reporting tool
X-Useragent: Nuntius v1.1.1d7
Date: Wed, 30 Sep 1992 13:09:27 GMT
X-Xxdate: Wed, 30 Sep 92 03:10:09 GMT
Organization: Mentor Graphics (Netherlands) B.V.