#1 2015-08-27 20:41:42

esmondb
Member
From: London
Registered: 2010-07-20
Posts: 299

TSQLRest.UpdateField with TIntegerArray

I'm trying to update a TintegerArray field with TSQLRest.UpdateField but get this error: 'ESynException with message "TJSONSerializer.AddVariant(VType=8195)".'

TSQLRest.Update with the whole record works fine. (using SQLite)

What's wrong?

Offline

#2 2015-08-28 06:49:51

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,182
Website

Re: TSQLRest.UpdateField with TIntegerArray

What is a TIntegerArray?
Do you mean TIntegerDynArray?

Then remember that a dynamic array is encoded as binary, so you should just try to use BinToBase64WithMagic(DynArraySave( )) for TSQLRest.UpdateField.

Offline

Board footer

Powered by FluxBB