Does Repository.Execute return a result?

[Paolo F Cantoni]

My Work Experience Student is too shy to ask here himself... 

Does anyone know?

TIA,
Paolo

[Geert Bellekens]

I've never tried to catch it, but I don't think so.

Enough to test though.

Geert

[qwerty]

No. It does not return anything. What would he expect/want to be returned?

q.

[Geert Bellekens]

No. It does not return anything. What would he expect/want to be returned?

q.

Something like affected rows would be useful.

Geert

[qwerty]

Seems like you need to run a WHERE query beforehand if you are interested in that number. I never cared about the number of affected rows since I just want it to do the change for whatever had been relevant. But maybe I just did not come across an appropriate use case.

q.

[Geert Bellekens]

Often I find that I want to give feedback to the user indicating what has been changed
(e.g. unlocked 236 elements)
If I want to do that now I need to make a select query first, execute that, get the result from it, and then execute the update query and hope that the result is the same.
I will never be really sure (has the database changed between my select and my update query, did I make a mistake in the select query,...)

If the operation would simply return the affected rows I wouldn't need all of the above, and I would be sure the feedback to the user is correct.

Geert

[MaXyM]

I will never be really sure (has the database changed between my select and my update query, did I make a mistake in the select query,...)

If done in transaction with proper Transiaction Isolation Level (Repeatable Read at least) then you can be sure. But probably not achievable in EA this way.
However EA offers Repository.SQLQuery (string SQL). From reference manual:

Returns an XML formatted string value of the resulting record set.

BTW mentioned reference doesn't mention Repository.Execute. Maybe it's derived from somewhere else.

[Geert Bellekens]

I will never be really sure (has the database changed between my select and my update query, did I make a mistake in the select query,...)


If done in transaction with proper Transiaction Isolation Level (Repeatable Read at least) then you can be sure. But probably not achievable in EA this way.
However EA offers Repository.SQLQuery (string SQL). From reference manual:

Returns an XML formatted string value of the resulting record set.

Sure, that is the workaround we discussed.

BTW mentioned reference doesn't mention Repository.Execute. Maybe it's derived from somewhere else.

That is on purpose. The Repository.Execute is not documented and not supported by Sparx.
In other words, use at your own risk, and if you get into trouble, you are on your own

Geert