Re: Filemaker show records
Re: Filemaker show records
- Subject: Re: Filemaker show records
- From: Malcolm Fitzgerald <email@hidden>
- Date: Wed, 18 Jul 2001 22:06:47 +1000
hi all,
i have a script that takes it's input form an textfile with
serialnumbers, and searches for them in a Filemaker database, the
problem i have at this moment is with serialnumbers that are in the
textfile but not in the database. Filemaker throws up an error, that
it can't find this number.
what i want to do, is when this serial doesn't exist in the
database, skip this number and go on with the script
in that case you want to put the code into a "try" block like so
set x to "10000"
global The_Serial
repeat with i from 1 to x
set The_serial to i
try -- this is new
tell application "filemaker pro"
show every record of database "serials" whose cell
"serialnumber" is The_serial
end tell
on error
-- error checking goes here
-- test for (serial doesn't exist) and proceed
-- or show message for any other error
end try
set i to i + 1
end if
--
Malcolm Fitzgerald
ph: 02 9130 6124 email@hidden