I've just uploaded the corresponding source code to our repository.
See sample 19 - AJAX ExtJS FishFacts at http://synopse.info/fossil/dir?name=SQL … +FishFacts
You need to download the DB from http://synopse.info/files/samples/Project19Server.zip
Enjoy!
]]>May we ask you to share the code
OK. I'll send the project by email.
]]>May we ask you to share the code, if possible, so that we may add it to the source code repository as official sample?
It may help a lot other users!
Please note that you can force the automatic transmission of all BLOB fields from a Delphi client directly, by setting TSQLRestClientURI.ForceBlobTransfert property to TRUE (that is, by default "Lazy loading" is enabled, but can be disabled on purpose).
Or you can use a TByteDynArray kind of property to let the content be transmitted (after BIN64 encoding) together with the main AJAX GET request, and returned within the JSON object.
But your AJAX client need to decode the Bin64 content, of course.
Thanks a lot!
Now, I’m using mORMot, with a background HTTP REST server, together with its SQLite3 database engine, I’ve implemented a thin client, Ajax-ready, open and lightweight javascript client using jQuery, that shows how to display style memo and graphic fields. This app has been compiled with Delphi 7, but you can recompile it with Delphi 2009/2010/XE.
Click here to watch my 3-minute video
http://youtu.be/eqzJQftv89s