Querying calculated fields?

[soros]

When querying a calculated field over ODBC I just get a empty result.

So any data that is pulled from another database using a calculation basically comes up blank.

Right now the only method I have of resolving this is to run a script in FM which copies the calculated values and pushes them into a static field which can be read using ODBC.

Is there a way to either access the calculated field directly through ODBC, or automate the execution of said script so that it does not have to be run each time the calculated field information changes?

[angelleye]

You don't want to be using calculated fields via ODBC w/ FileMaker. It's VERY slow because it has to make that calculation each and every time.

The best way is to get the data into stored fields as you mentioned. I'm afraid I can't help you on doing it automatically. :)