mORMot Open Source

toniobido

Member

Registered: 2015-09-08

Posts: 1

Error when adding TSQLRecord with empty TRawUTF8DynArray

Hi,

With a TSQLRestServerDB, when I try to add a TSQLRecord with an empty TRawUTF8DynArray field, I've this error :

ESQLite3Exception {"ErrorCode":1,"SQLite3ErrorCode":"secERROR","Message":"Error SQLITE_ERROR (1) [INSERT INTO TABLE (ALIAS,RawUTF8DA_1) VALUES (:('VALUE'):,:():);] using 3.27.2 - unrecognized token: \":\", extended_errcode=1"} [] at 007AB842 SynSQLite3.sqlite3_check (5402)  stack trace API

best regards,
Antoine

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Error when adding TSQLRecord with empty TRawUTF8DynArray

TRawUTF8DynArray is supported, but will serialize as binary/blob...
See https://synopse.info/files/html/Synopse … ml#TITL_26
Please try https://synopse.info/fossil/info/53f0f330de

You should rather use a TRawUTF8List or a variant (TDocVariant) if you want to store some JSON content.