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.