• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: AppleWorks database
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: AppleWorks database


  • Subject: Re: AppleWorks database
  • From: T&B <email@hidden>
  • Date: Sun, 26 Nov 2000 14:38:41 +1100

> I'm trying to script AppleWorks (5) database, with great difficulty.
> I can't get the most basic operation to work: adding a new record and
> setting it's field values. (I am able to make a new record, but not to
> fill in the data.)

In AppleWorks 5, most (probably 95%) of database scripting does not work. Setting values of fields does not work. The problems are documented at:
http://www.tandb.com.au/appleworks/problems/

A probable work around would be to set the clipboard to the values needed in the new record, then paste. AppleWorks pastes text delimited by returns as records and separated by tabs as field values.

> Anyone knows how to do this? (A short example would be great.) Thanks.

Thankfully, AppleWorks 6 fixes most of the database scripting problems. So, as you'd expect from the dictionary, you can create a new record with values like this:

tell application "AppleWorks 6"
tell database of front document
make new record at front
tell last record
set value of field "name" to "Tom"
set value of field "company" to "T&B"
set value of field "web" to "http://www.tandb.com.au";
end tell
end tell
end tell

For sample scripts, see:
http://www.tandb.com.au/appleworks/scripts/
For a detailed AppleScript tutorial, see:
http://www.tandb.com.au/applescript/tutorial/
For general AppleWorks resources, esp scripting, see:
http://www.tandb.com.au/appleworks/

Please post any followup queries to the list.

Thanks,
Tom
T&B


  • Prev by Date: Re: [unplgd] Trimming " clipping" from clipping file names
  • Next by Date: [OFF] eMailer (was: Most Scriptable Apps ..)
  • Previous by thread: AppleWorks database
  • Next by thread: [ANN] New tip on AppleScript Sourcebook
  • Index(es):
    • Date
    • Thread