JoinField doesn't concatenate the date type fields from a database view

05-13-2022 12:06 PM
by Anonymous User
Not applicable

I'm using this code to make a join to a SQL Server database view., "CE", "USE_KEY_FIELDS", "SID"), in_field="id", join_table="CE", join_field="SID", fields=["SID", "ExpirationDate", "AnotherDate"])
Then I use CopyFeatures to write data back to the SQL Server but it gives me the output with "SID" but other fields "ExpirationDate", "AnotherDate" are not included in the output.
This process works if I use a table that includes the same data instead of a view. Is there any workaround for this?
0 Kudos
0 Replies