mORMot Open Source

PlumeWis

Member

Registered: 2020-10-05

Posts: 1

How to call firebird stored procedure? by SynRestDataset or interface

Hello!

I am a newbie of mORMot and Delphi, and I have a problem with calling firebird stored procedures.
I asked a question on stackoverflow as the link below and Arnaud Bouchez was so kind to answer.

https://stackoverflow.com/questions/641 … -on-mormot

but I followed his answer and tried the database legacy example but couldn't really make it work.
https://tamingthemormot.wordpress.com/2 … databases/
Maybe because I really don't understand how to use interface service.

I also tried EMartin's SynRestDataset and used it to call the procedure but no lucks, it worked only when I selected tables.

In server side, I use TSQLDBZEOSConnectionProperties  with TSQLRestServerDB.  I did make classes for all tables in the database.
Do I need to make classes for stored procedures too so it could work?  or what else do I need to do?

Could you please give any samples project files of code so I could see how to do it correctly?
I've been struggling with this problem for so many days. Thank you in advance.

Best Regards.

Last edited by PlumeWis (2020-10-08 17:48:34)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: How to call firebird stored procedure? by SynRestDataset or interface

I don't think I could add anything to my answer in https://stackoverflow.com/a/64124692/458259

Start from the first point:
"Create a first layer of reusable "business/model" services using several interfaces - your own "logic toolbox"

Those interfaces will be implemented by a class which will call the stored procedures.