AnsweredAssumed Answered

Searching a calculation field

Question asked by Melinda on Nov 16, 2010
Latest reply on Nov 16, 2010 by philmodjunk


Searching a calculation field


I was just sent a new problem that I can't figure out...  a co-worker is trying to do a search in a database for all records showing a specific number in a specific field.  FM seems to freeze in the "Query in Progress" window, though I think FM is actually working, I can't figure out why it is taking so long...  I went into the database and determined that when the field was originally created it was created as a calulation field (which I have no idea why, it's not calculating anything) when it could have been a text or number field. Could this be why the search seems to run indefinitely?

If I change the field type from a calculation field to a text or number field, will I lose the data that's there, or might it be reformatted?  I can't riskk osig what's there, so if I need a work around, I'd be grateful for a point in the right direction.



I'm using FMPro 9, Mac OSX.