What does this error mean??

[lemonjuice]

Does anyone know what this means?

"prefilterMouseExitBefore

Do you want to replace :tables: tableName in the data model?"

We keep getting this error in Paradox9 and I do not believe that it is in the code, mostly when we already have a form open in our application and then open another one.

 

[footpad]

lemonjuice,

The "prefilterMouseExitBefore" bit is not a Paradox string.

I suspect you have a general error handler in your application designed to show where errors occur, in an attempt to make them easier to troubleshoot. Look for an error() event something along those lines.

Now, "Do you want to replace :tables: tableName in the data model?" does look line it might be a message generated by Paradox. It usually appears when Paradox cannot locate a table in the data model. In this case, the :tables: directory doesn't contain whatever value tablename is set to.

I've seen this for a variety of reasons. Here are a few:

1) When the table is stored in an aliased directory, it's possible the alias is either undefined or it's pointing to the wrong location.

To check this, wuse Tools | Alias Manager to verify the definition of the :tables: alias.

2) Most of the time, it appears when you create a data model referring to either an :ANSWER: table or some query result table (possibly even a .QBE or .SQL file) *and* open the document before running the query.

This is a commonly used feature. Unfortunately, you need to remember to actually run the quer(y|ies) before opening the document in Design mode.

A better approach is to save a copy the structure of the ANSWER table in the main data directory, bind the data model to that copy, and then change the document's MasterTable after running the query in code. (For an example of changing the documents MasterTable in code, please see

http://techtricks.com/paradox/printone.php).

3) I've also seen this appear when the table cannot be opened, e.g. it's damaged or one of its family files are damaged/missing. (Family files are the supporting files for the .DB file, e.g. the .MB file, .PX, .X??, .Y??, .VAL, and so on.)

To detect this condition, use File | Open | Table to directly open the table being reported. If you get an error, that's why the table cannot be opened for the document's data model.

Generally, there's a specific (and quickly fixed) reason why Paradox cannot open tables in data models. It's unfortunate that you don't get more specific information when this happens. However, it's pretty easy to determine what's going on after a bit of investigation.

Hope this helps...

-- Lance