Relation based on view

[tizzo]

I'm trying to create a relation between a table and (on the right side) a view.
It seems to me it's possible since Servoy lets me design such a kind of relation...
but I still get an empty foundset.
am I doing right or there's something wrong in the relation's design?

thx in advance

[mboegem]

Did you mark the row-identifier(s) in Servoy? Without this Servoy doesn't know what to query...

[tizzo]

yes I did.
i've tried many ways, simplifying to only one constant value field, making some simple calculation, etc...
but i still can't get it work

[mboegem]

Did you try to query this view directly through an SQL-admin tool?

Also be aware that the data in a view is always altered from outside Servoy. So: once a result is cached in Servoy, you won't see changes in this result unless you completely refresh the foundset from database. As Servoy is only aware of db-changed done through a Servoy-client.

Depending on the 'cost' of your view, this might be anot do ideal solution to show your data.

[tizzo]

you were right. I've redone it all from a blank situation and now it's ok.
It was probably a type mistake or my vision is getting worse, i don't know
thx