Hi,

Can you please check whether the F1 property SQL Column has a value attached to your column? 

If you dragged and dropped the column from the Dataset toolbox, the SQL column property should already have a value by default. See below: 

If you created the column from the toolbox, you must add the SQL column manually. 

Hi KasunBalasooriya

First of all, thank you for your response.

SQL column is full and it is not reason.

Hi@savasciftci,

Is the attribute you’re using an Aggregate or an Array attribute? Because, for Aggregate and Array attributes, Queryable property will always return false.

Also, if you go to the designer.cs file, you should see something like this for your table column,

NamedProperties.Put("FieldFlags", "294");

This is where the flags are set. The number represents text as a series of Unicode characters. You can try to set the Queryable to false and check if this number gets changed.

Himasha

Hi @Himasha Kapugeekiyanage  

Thanks for ur help. It is the answer i am lookin’ for.

Hi,

What’s the cTableWindow you are trying this on?  Are you trying to add a filed from the Dataset toolbox or are you adding a cColumn from the toolbox? 

Hi Mr @KasunBalasooriya 

The reason in my column i used an aggragated function. I turned it to a function and it solved my problem. Thank you for your help. 

Is there a way to save views with different column views?  Example, I am trying to save a view in Sales orders and only one 3 table views in one save and 9 in another. Seems like all my saves have to have the same columns that the user selects.