comparing two filemaker databases
comparing two filemaker databases
- Subject: comparing two filemaker databases
- From: Kelvin Aitken <email@hidden>
- Date: Fri, 09 Aug 2002 13:02:11 +1000
- Organization: Marine Themes Stock Library
I have most of this working OK but I need some help in checking two
Filemaker databases.
The databases are identical except that one has a few extra records. I
want to be able to identify the extra records. In brief here is what I
have written:
tell application "FileMaker Pro"
set combo to ""
repeat with i from 1 to count of records in document "aa"
set cell1 to cell "First Field" of record i of document "aa"
set cell2 to cell "Second Field" of record i of document "aa"
try
--this next line is obviously the problem
show (every record of database "bb" whose cell "First Field" = cell1)
and show (every record of database "bb" whose cell "Second Field" =
cell2)
set y to cell "First Field" of the current record of document "bb"
set z to cell "Second Field" of the current record of document "bb"
set combo to combo & y & " " & z & return
end repeat
end tell
From there I would put the combo variable into something like an
Appleworks or Simple Text document.
None of the information in the fields is unique however the combination
of cell "First Field" and cell "Second Field" will refer to a single
unique record.
Any suggestions?
Kelvin.
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.