June 6, 200817 yr Dear FM DB Meisters, A DB i am working with has a file reference which points to a file (eg "olddb") that is usually not there since the file reference is to deal with upgrading the file. There are 3 table occurances that use the file reference. In the upgrade script there is a test if a table exists in the file reference (using isvalid(table_occurance::somefield)) to see if the upgrade should import any records found, otherwise "olddb" doesn't have it to import. Totally unrelated (pun intended) if the "olddb" file is not there, when a sort by the user is performed, one gets the message: "olddb could not be opened. (Not Found)". If the "olddb" file is there, no message is displayed. I searched the forums for "could not be opened. (Not Found)" and did not get any help that addressed this situation. Does anyone have a clue as to why FM is giving this message? There are NO calculation fields which use these tables nor any other references to these tables through the 3 table occurances other than testing if isvalid() in the upgrade script. I would think that this should keep FM from testing table occurance is pointing to an actual file or not. But maybe i am wrong. Is there another way to test if a table exists in a DB file that will not trigger this message from FM if the DB file is not there? Peace, Dan
Create an account or sign in to comment