Thread: [SOLVED] dataset calculated field
View Single Post
Old 01-18-2018, 10:40 PM
FreakaZoid2 FreakaZoid2 is offline
Senior Member
Join Date: Jul 2009
Posts: 352
Default dataset calculated field

I have a firedac query that returns a column C_08 but I want to add a new column not in the table but just on the fly of the query.
I am trying to figure out how to add a new column D_08 and to assign the value from C_08 to D_08.
It has to be calculated. this is related to prior timestamp/datetime fieldtype question. C_08 is timestamp and the component doesn't work on it so I need to create the new column D_08 as a datetime field type and set its value to the same as C_08
I added it as a InternalCalc and set the defaultexpression to C_08. compiles but my new column is always null
What am I missing.