Hi,
I’m working on converting a few scripts (written by somebody else) from OS 9, Quark 3.4, and FileMaker 5 to OS X, InDesign CS, and Filemaker 8.5. I’m having a problem getting the syntax for a record search down. I need to find all the records that meet 2 conditions, one is a date variable (runningdate)and the other is a variable for what page the info is to be placed on (pagetoBuild). Here’s the code I have (that doesn’t work).
tell application "FileMaker Pro"
activate
open alias (hammerPath & "Coldwell home database")
-- opens the database file
-- change file path accordingly
tell database "Coldwell home database"
tell layout 1
try
show (every record whose cellValue of cell "Running in issue" = runningDate and cell value of cell "Page" = pagetoBuild)
--create new request
-- initiates a find
on error
display dialog "The database encountered an error. " & ¬
"Please check the date in the database and make sure the publication data you enter matches exactly." buttons "Cancel"
return
end try
end tell
end tell
tell document 1
set databaseCount to count of records
-- count of found, not all
end tell
end tell
Also, is there a way to mount volums with getting the dialog box asking for the password. I have used both of the following lines of code but neither one gets past the dialog box.
mount volume "afp://mac01:@xxx.xx.xx.xxx/Images_1"
mount volume "afp://xxx.xx.xx.xxx/Images_1" with user name "mac01" and password ""
Any help will be appreciated.