Dealing with MS SQL RowVersion

[rzarate]

I am dealing with a legacy app using MS SQL for some data tables.
If I try to insert a record in those tables I must provide a RowVersion value in the specific column.
Seems like RowVersion is a timestamp converted to binary.
Trying to feed an Number, Datetime or Text type results in an error.
How can this be handled in Appsheets?
How to convert a DateTime to binary?

[Marc_Dillon]

RowVersion should be autogenerated by the database server. You should not be putting any value into it. I think to solve this you should try to make Appsheet unaware of the column. Here's a little trick to "delete" a column. Create a new SQL view on your database with all columns except for that one. Re-point the Appsheet table to this new view and regenerate the columns. Then point the appsheet table back to the original table, but without regenerating again.

[rzarate]

Thank for you reply Marc.
Sure I'll give a try.