hi
i am trying to change the date type of an item in the framework manager from carchar to int but when i try and pull down on datatype to be changed it is grayed out...any odeas
bunker
The data type of an item is inherited from the database. Make your change there and refresh the query. It should update to the correct type.
If for whatever reason you can't make the change in the database, you could make a new query item to cast it to the correct type. The downside is the casting is an extremely costly function and will slow everything down.
Quote from: PaulM on 03 Nov 2009 10:55:03 PM
The data type of an item is inherited from the database. Make your change there and refresh the query. It should update to the correct type.
If for whatever reason you can't make the change in the database, you could make a new query item to cast it to the correct type. The downside is the casting is an extremely costly function and will slow everything down.
I will be costly if it means that you lose index based access to data, otherwise it is hardly a performance issue