calculation

[sharabi]

i made a calculation for a field and the output is text, when i try to search, it does not see the files prior to the modification of the calculation only the new records after modification,any remedy?

the attached zip file has the field Mont_year calculation, and it generates 06 (for the year) 00 for the month and 3 digits for the records newly entered.

any modification to the calculation it gets blind to the prior records when searching.

hello.zip

[Genx]

Change the calc to unstored. Or alternatively, do a replace of one of the fields referenced in the calculation (click in the field, (MENU) Record --> Replace field contents) and for the replace, choose calculated result and simply select the same field your replacing your contents in.

This replace should force a re-evaluation of all stored calculations that reference this field somewhere.

**Make a backup of your file before you attempt this.

~Genx

[LaRetta]

You can also force a reindex just by changing to unstored, exiting from Define Fields, going back in and indexing again. This is usually quicker than Replace Field Contents because you don't have to find/create a layout with the field on it. :wink2:

[-Queue-]

Auto-entered calculations only evaluate when a record is first created, unless you specify otherwise by deselecting the 'do not replace' checkbox, which in this case you would not wish to do. Nor do you want to run a Replace using the same calculation to update the field, unless you want all similar records to contain the same result (since the calculation relies on Count() and would produce 17 records with a value of 06-10017, among others). Instead, run a Replace using a calculation only involving the current contents of the field, namely

Left( CASE #, 2 ) & "-" & Right( CASE #, 5 )

[LaRetta]

Hi JT,

I admit I didn't even check the file ... I thought it was a simple reindex issue to bring fields up to snuff. But even an empty field can be turned into an indexed calc ... then changed back to a standard field - and FILL THE FIELDS!! I do it all the time and it's simpler than loop/setting the fields with data or Replace Field Contents.

Well ... nonetheless, I should have paid close attention to the post and the file before responding. I know better than that ...

LaRetta

[-Queue-]

That is true, but depending on the number of records in the file, it would seem that running a Replace could be much faster than changing the indexing on a field and then waiting for it to reindex after changing it back. Then again, I do not own 8, so it may be completely different than I envision.

By the way, I had not read either response before posting my own. So I was not attacking what anyone else wrote, merely explaining why some other options may not be suitable in this case.

[sharabi]

thx for the response,

i tried to go to (case #) in the browse mode, record from Menu replace with calculation, which is

Month_year & Right("000" & (Count(Self_On_Month_Year::Date));3)

hit replace, back to search mode and am able to retreive 2 records from 37.

in search in field case # i put 06 to get all records in 2006 as per calc.

please tellme if i am doing somthing wrong.

[-Queue-]

That is exactly what I said not to do. Now you will only have 3 unique values for the field, which is no good.

Go back to a copy of the file saved before you made the change and use the Replace calculation I posted above instead of the auto-enter one.

[sharabi]

i appreciate being patient with me because am new to this. i added a new record without calculation 0604011, now i have 36 records, then went to field in browse mode clicked it went to records from menu pulled replace field contents>>from calculation>>specify>>refered to your string so i typed Left( CASE #, 2 ) & "-" & Right( CASE #, 5 )in the field >>hit replace>>surely my 0604011 turns into 06-04011, go to search mode enter 06 to pull all files starting 06>>>>well...i get 13 from 38 starting 06-.....

[-Queue-]

Your index may be corrupt. Change it to something else (such as Unicode) in the Storage options for the field. Close the Define Database window, then open it and change the indexing back to what it was originally. Then try performing your find.

[sharabi]

you are great it worked like charm, thx alot