mORMot Open Source

bravecobra

Member

Registered: 2013-05-15

Posts: 9

Re: Demo application + some question / remarks.

Could this example be updated please to the latest mORMot version, as it isn't working anymore
Tnx!

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Demo application + some question / remarks.

Could this example be updated please to the latest mORMot version, as it isn't working anymore
Tnx!

You will have to ask the one how wrote this demo.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Demo application + some question / remarks.

I've added Migajek third party samples - as retrieved from https://code.google.com/p/synopse-sqlite-demo - and updated to latest 1.18 revision of the framework.
See http://synopse.info/fossil/info/fa1d04c0c7

Hope it helps.

tdanop

Member

Registered: 2015-01-16

Posts: 27

Re: Demo application + some question / remarks.

I am trying to run on XE5 but it comes with error on ACustomer.Tasks.DestGet(globalClient, ACustomer.ID, fIds)
[dcc32 Error] Unit1.pas(184): E2250 There is no overloaded version of 'DestGet' that can be called with these arguments
I am trying to fix but as I can see DestGet method does not use anymore TSQLRecord as a param type but TSQLRest, I am lost because when the demo was construct propably was with a different framework.

marius maximus

Member

From: Olsztyn

Registered: 2015-06-11

Posts: 30

Re: Demo application + some question / remarks.

Parametr fIds  is wrong type , please change
fIds: TIntegerDynArray;
to
fIds: TIDDynArray;

---

Lazarus x64 Linux

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: Demo application + some question / remarks.

Indeed.

Please check http://synopse.info/fossil/info/f9a879b45a

tdanop

Member

Registered: 2015-01-16

Posts: 27

Re: Demo application + some question / remarks.

Tnx ab it is working now.

marius maximus

Member

From: Olsztyn

Registered: 2015-06-11

Posts: 30

Re: Demo application + some question / remarks.

My patch for lazarus version "synopse-sqlite-demo"
this project works identical in Delphi XE5 , and lazarus 32bit [this same code] (it is good news)
http://pastebin.com/9mj70KqE

bad news:
"synopse-sqlite-demo" use mORMotUI , but this unit have few problems in lazarus , I must create other patch

Other problem to comments in "mORMoti18n.pas"
In mORMoti18n.pas in comment block is "(* . msg)" , and this "completely smashes the code"

---

Lazarus x64 Linux

nmadani

Member

Registered: 2021-03-14

Posts: 2

Re: Demo application + some question / remarks.

Hi:

I am new to mORMot. Looking at the samples and reading the documentation, I noticed a potential problem in this demo:
... \mORMot\SQLite3\Samples\ThirdPartyDemos\Migajek\synopse-sqlite-demo

In uCustomer.pas, there is a forward declaration on line 10:
  TSQLTasks = class;

Although it is included in:
  TSQLCustomer = class(TSQLPerson)
  private
    fTasks: TSQLTasks;
  published
    property Tasks: TSQLTasks read fTasks;
  end;

The corresponding Customer table in the generated database does not include the forward declared Tasks field. Is this by design?

Thank you in advance,

Navid

nmadani

Member

Registered: 2021-03-14

Posts: 2

Re: Demo application + some question / remarks.

Alright, I got it: TSQLTasks equates a pivot table descending from TSQLRecordMany, and many-to-many relations are handled by the ORM instead of DBMS constraints.