This view was provided to simplify reporting and dispaying of the undelying data structure.
First of all: I don't want to discuss the data structure AND I can't change anything in the database...
Using the view on a form and filtering the data, the form shows the correct number of records and all match the search criteria.
This is what servoy seems to do (taken from the Performance data log):
- Code: Select all
Find
select top 201 logon1 from MyView where logon1 = ? order by logon1 asc
Load foundset
select top 4 logon1, id, typ, scope, typ2, delegator_id, logon2, [Start], [Stop] from MyView where logon1 in (?, ?, ?)
But this are not the same records that you get if you issue an identical SQL SELECT in the/a SQL-editor...
In my tests I got 3 records which contained one duplicated record. The result seems to be depending on "how wrong" I'm defining the row ident columns (so that Servoy feels happy to show any data from that view).
therefore:
a) it makes me a bit "nervous" (I'm pretty new in Servoy) that Servoy seems to present just wrong data if your PK definitions are not ok
b) do I really need to issue a "manual" SQL and create the according form on the fly via solution model?
thx in advance
Jo