Pages: 1

#1 Re: mORMot 1 » Suggestion - Add BatchAddRawSql() to the batch update mechanism :) » 2016-01-06 17:32:54

ed

I second this proposal.

I my opinion not all sql must be seen as one problem to solve.

From the top of my head:
Functional sql: This is what the orm's implementation hides.
Technical sql: Sometimes needed in more complex cases, dialect e.g. could be handled at resource level.

#2 Re: mORMot 1 » Use stored procedures in direct acces layer with the synDB.pas unit » 2014-11-23 10:55:28

ed

No luck, so far.
I can call the stored procedure fine. The resulting dataset just isn't returned.
It seems stored procedures in mssql don't return datasets the way queries do.
I'll look into the way TStoredProc does it on delphi, see if i can figure something out.

#3 Re: mORMot 1 » Use stored procedures in direct acces layer with the synDB.pas unit » 2014-11-19 13:36:02

ed

I'll see if i can run some tests tonight.

#4 mORMot 1 » Use stored procedures in direct acces layer with the synDB.pas unit » 2014-11-19 10:12:10

ed
Replies: 4

We have an sql server we usually access with OLEDB. It is filled with business logic stored procedures returning datasets and return values. We would like to call this logic using synDB.pas direct access layer.
Is is possible to use parametrized stored procedures with returning datasets and return values using OLEDB and the synDB.pas unit?

Pages: 1

Board footer

Powered by FluxBB