mORMot Open Source

AntonE

Member

Registered: 2012-02-03

Posts: 74

TSQLTableJSON create/add rows?

Hello.
I need to create a TSQLTableJSON on the fly with custom columns, i.e. not tied to a TSQLRecord class.
(Actually it must be created from custom fields derived from TDocVariant within a TSQLRecord variant property)
Is it possible to create the TSQLTableJSON with column types, then add rows or it it read-only?

If it is read-only, what would be the best way to create a table like this?
1) Create the whole resultset as a JSON string by using TTextWriter
2) Create TSQLTableJSON.CreateWithColumnTypes (so that TSQLTableToGrid can display nicely)?

Or is there maybe some other mORMot-magic method to get same result?

Thanks
AntonE