Re: AppleWorks database
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