mORMot Open Source

Thank you, Esteban. Very useful changes.

If you change the type RawJSON to RawUTF8?

@ab, I agree with you. I haven't read the official specification, only StackOverflow. This is a undocumented feature.

Like a TTable.RecNo?

Yes! Please make DBISAM and ElevateDB mORMot compatible

A extra step was needed. Works now:

var
  Blob: RawByteString;
  SQLRawBlob: TSQLRawBlob;
  Circumferences: TDoubleDynArray;
begin
  Blob := TreeDataset.FieldByName('Circumferences').AsString;
  SQLRawBlob := BlobToTSQLRawBlob(Blob);
  DynArrayLoad(Circumferences, Pointer(SQLRawBlob), TypeInfo(TDoubleDynArray));
end;

Esteban, Arnaud... I have this situation:

A field in a TSQLRecord descendant that is a TDoubleDynArray, which is retrieved as a blob field by TSynDBDataSet or TSynRestDataSet, or any TSynBinaryDataSet descendant.

type
  TTree = class(TSQLRecord)
  private
    FCircumferences: TDoubleDynArray;
  public
    Circumferences: TDoubleDynArray read FCircumferences write FCircumferences; 
  end;

My question is: How can I convert this TDataset blob field in a dynamic double array? Which functions I use to do this?

Thank you, Esteban. I tried TSynRestDataset yesterday, worked well.  I read your code and liked what I saw.

But I also want to use the ORM part of mORMot for some more complex reports and services, which select SQL can be up to tens of lines.

Can you tell if TSynRestDataset could handle huge, multiline SELECTs?

And some selects with expressions like

select *, Cidade||'', ''||DDD||'' ''||Telefone as CidadeTelefone from Funcionario 

At this point, the only option that I see is to create services on the server and return only the serialization of the results as JSON.

Can you help me on this, @AB?

I can create a TSynSQLTableDataSet descendent and write a special case InternalInitFieldDefs. It this the best approach?

I have examples of converting json with JSONToDataSet().

@ab, can you write a quick example using array of objects?

I can't get it.

function TSQLRest.RetrieveListObjArray() is Boolean, but you are using Result as a [absolute] TObjectDynArray in ObjArrayClear()

@ab, what is the current road-map today?

Warley, the javascript code in your example is minified, I think. Can't read.

This is weird. I tried again and it worked now.

Thank you again.

What if I post a flac audio file (or stream) for the google Speech Api? TDocVarient will handle this?

Thank you.

Before I asked this question, I have read the documentation and found ToDataSet() and ToClientDataSet(). But I don't know how to use them with my TSQLAnimal class. The examples show only with direct aProps.Execute(), not in the ORM way.

May I ask you to show a example of aTSQLRecord.FillPrepare + ToClientDataSet()?

AntonE, please put your project in a github account