mORMot Open Source

Please confirm:
If TNullable* types in TSQLRecord(ORM Record), unable to generate correct JSON.

THANKS!

const SQL_PEOPLE = 'select 1 as KeyID, firstname from People where firstname = ''YANG'''; 

Error:"GetFieldData ColumnType=Unknown".

---------------------
@ab, Still this problem. Please check, Thanks.

I do not think the SQL is wrong, consider these SQL: table t0,  2 fields: x and y, if no data(0 row in table), still raise error with the following statement.

  const SQL = 'select x*y as value from t0'; 

or this SQL:

  const SQL_PEOPLE = 'select lastname || firstname as FULLNAME, * from People';

@ab, There still has the same error with following statement, "GetFieldData ColumnType=Unknown"

select F1, F2 from Table1 where 1=2

@ab, Hi, I found another question. There's a table t0,  2 fields: x and y, if no data(0 row in table), still raise error with the following statement.

select x*y as value from t0;
//or
select 1 as ID, x, y from t0;

-----
Best regards

I have debugged the code, with SQLite3, if there was a computed field in SELECT statement, e.g.

select 1 as ID;
select F1*F2  from Tbl;

function TSQLRequest.FieldDeclaredType(Col: Integer): RawUTF8;
var P: PUTF8Char;
begin
  if cardinal(Col)>=cardinal(FieldCount) then
    raise ESQLite3Exception.Create(RequestDB,SQLITE_RANGE,'FieldDeclaredType');
  P := pointer(sqlite3.column_decltype(Request,Col));
  FastSetString(result,P,SynCommons.StrLen(P));
end;

// Result here was empty. Then ColumnTypeNativeToDB won't get the field type correctly.

How to generate the key in this case? Many thanks！

Another question: [array of const] in param, a error: "TJSONRecordRTTI.Create: error when retrieving enhanced RTTI for TVarRec", any suggestion?

Thanks.

Unable to display Unicode characters correctly and How to fix it?

Many thanks.

type
  /// comment
  ITest = interface(IInvokable)
    ['{3C7A4F39-88C2-4A10-9BC1-1B8AB0FFC5FB}']
    ///中文,こんにちは, 안녕하세요
    function Hello(aName: RawUTF8): RawUTF8;
  end;

Does anyone found this problem?