mORMot Open Source

lagodny

Member

Registered: 2015-01-28

Posts: 50

TSQLTable.ToDocVariant(Row: integer; out doc: variant)

I'm trying to get data from multiple tables RestModel.RetrieveDocVariantArray. The result of the query, some fields do not contain any of the values on which it would be possible to determine their type. So

ValueVarToVariant

raise ESQLTableException because

fFieldType[f].ContentType = sftUnknown

Is it right?
Can we fix it?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 15,312

Website

Re: TSQLTable.ToDocVariant(Row: integer; out doc: variant)

ValueVarToVariant() would now set a varEmpty (Unassigned) value for sftUnknown.

See http://synopse.info/fossil/info/15040e0a63

lagodny

Member

Registered: 2015-01-28

Posts: 50

Re: TSQLTable.ToDocVariant(Row: integer; out doc: variant)

Incredibly fast. Thanks.