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
Did you mark the row-identifier(s) in Servoy? Without this Servoy doesn’t know what to query…
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
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.
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