Unable to cast value to be String for time(7) column
Unable to cast value to be String for time(7) column
sarooptrivedi
Posts: 62Questions: 19Answers: 2
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();
This discussion has been closed.
Answers
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.