New query subject

[paloalto_cognos]

Hi,

I need help in solving the problem where I have to change the datatype of a query item in query subject. I do not to change it from DB.

So I created a new query subject by merging the existing query subject in FM as I could not change the datatype from char to integer in the original query subject using edit definiton. but when I try to delete the old or original one , the new is getting invalidated.

How to delete that query subject or can I publish the package with out any relationship to that original query subject . Please advise.....

[dlafrance]

If you cannot change datatype, try to force it by using a cast of your field..