[NOT-A-BUG] TSQLRestClientURI.ExecuteList() doesn't work with Views?

edwinsn · 2015-11-01 09:36:22

update: It turned out to be a logical bug in my program but not a problem of the mORMot framework. I'm sorry.

~~Hi Arnaud,~~

~~The code:~~

var
  tmpTable: TSQLTableJSON;
begin
  tmpTable := aDb.ExecuteList([], aSql);
end

~~I found that TSQLRestClientURI.Execute() returns zero rows for this SQL:~~

SELECT CurrentStock FROM v_Inventory WHERE (ID = 12345)

~~It returns zero row, but I use Sqlite Studio and it should return one row. What might be wrong?~~

~~Thanks.~~

Last edited by edwinsn (2015-11-03 07:02:53)

ab · 2015-11-01 22:02:05

Perhaps the connection properties are not set properly.

edwinsn · 2015-11-02 06:22:40

ab, what connection properties do you mean? The TSQLRestClientURI in question is already working with other type of 'select' statements...

ab · 2015-11-02 07:06:21

Do not use SQL statements, but ORM methods.

For security reasons, SQL statement execution may not be allowed from client side.

edwinsn · 2015-11-02 13:21:29

Hi ab,

I'm really sorry, after spent hours of checking, it turned out to be a logical bug in my program but not a problem of the mORMot frame itself. I will update the original topic above.

mORMot Open Source

#1 2015-11-01 09:36:22

[NOT-A-BUG] TSQLRestClientURI.ExecuteList() doesn't work with Views?

#2 2015-11-01 22:02:05

Re: [NOT-A-BUG] TSQLRestClientURI.ExecuteList() doesn't work with Views?

#3 2015-11-02 06:22:40

Re: [NOT-A-BUG] TSQLRestClientURI.ExecuteList() doesn't work with Views?

#4 2015-11-02 07:06:21

Re: [NOT-A-BUG] TSQLRestClientURI.ExecuteList() doesn't work with Views?

#5 2015-11-02 13:21:29

Re: [NOT-A-BUG] TSQLRestClientURI.ExecuteList() doesn't work with Views?

Board footer