# Filemanager 3 and computed fields

**URL:** <https://clarionhub.com/t/filemanager-3-and-computed-fields/7388>\
**Category:** questions\
**Tags:** fm3, c10\
**Created:** [August 11, 2024, 5:33pm UTC](https://clarionhub.com/t/filemanager-3-and-computed-fields/7388 "2024-08-11T17:33:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bjarne\_Havnen](https://clarionhub.com/user_avatar/clarionhub.com/bjarne_havnen/32/1350_2.png) [@Bjarne\_Havnen](https://clarionhub.com/u/Bjarne_Havnen)\
**Post date:** [August 11, 2024, 5:33pm UTC](https://clarionhub.com/t/filemanager-3-and-computed-fields/7388/1 "2024-08-11T17:33:13Z")

</div>

I have FM3 version 5.3 using Clarion 10.  
In the previous version of a file, I added a computed field that returns the three first characters of another field. I used ForceSqlDataType = AS (substring([Plass],(1),(3))) This worked fine for adding the field.  
Now I added another field and I get FM3 error [FM3] 37000: Incorrect syntax near the keyword 'as'.  
The new field is added OK, but errormessages are anoying..  
I can drop the field before update, so the field is recreated each time, but is there a better way?