Unable to cast value to be String for time(7) column

sarooptrivedi

I get this error while reading data through view in editor.

How to manage Time(7) in Editor.

please check my code below.

var response = new Editor(db, "ItemTble", pkey)
.ReadTable("V_Items")
.Field(new Field("AId"))
.Field(new Field("ItemName"))
.Field(new Field("DateOn"))
.Field(new Field("TimeOn").SetFormatter(Format.DateSqlToFormat("HH:mm:ss")))
.Process(Request)
.Data();

sarooptrivedi

Hello Team,

I figure out with DateTime format.

.Field(new Field("TimeOn").GetFormatter(Format.DateTime("HH:mm:ss")).SetFormatter(Format.DateTime("HH:mm:ss")))

Thank you.