If GetField(101::myField) GetField(102::myfield) then SetField(Simulation::Error = GetField(101::myField)&"Will be replaced by "GetField(102::myfield) I hope this would look something like.(Assuming that I have 2 TableIDs of 101 and 102, and FieldID's of 0-500) If the database stuctures are IDENTICAL, can I not use a nested loop using FieldID.
#COMPARE 2 FILEMAKER PRO DATABASE CODE#
Now, each Database has approx 500 fields.so the script would probably approach 1000 lines of code (Note: This is not written in FMP Script.but I hope you get the drift.) I am about to commence a script that compares the two databases field by fieldĮ.g If (Simulation::Name Production::Name) then set Field(Master::Error(n)= "Name Change" Yep Ive checked out FMDiff.But it will not do exactly what I want. What is the best way to determine the differences between the two databases (Added, deleted, Modified, Moved)? Each record needs to be compared field by field?
#COMPARE 2 FILEMAKER PRO DATABASE SOFTWARE#
So, it is possible that when comparing the two databases, that the Name still exists, but the address has been moved, or the name has been changed (same address), or that a new software object has been added or deleted from either. Over the past several years the two databases have "evolved", in one database, certain fields have been updated, and the other objects have been added, Names have been changed, Addresses have been changed. Email John Mark Osborne or call John Mark. An object MUST have a unique name and a unique Address. Meta-consulting is a service Database Pros offers to help other developers over programming hurdles via GoToMeeting. The database structures are identical (approx 4000 records, and 550 fields each (one called Production, the other Simulation))Įach database contains the information for "software Objects". I work in the Oil & Gas business and Im trying to compare changes and differences between 2 systems databases.
0 kommentar(er)
