urgent issue

[Hans Nieuwenhuis]

Hi,

I have an issue that I never had before :

I have a solution which uses a number of views (and a lot of tables)
Each of these views has a row identifier.

When i export the solution and import it in our test or production servoy-server, one of the views doen not have a row identifier.
The others do.

I even removed all solutions from a development servoy server and imported the solution, but same issue.

What could be the problem ??

I am using 5.2.15 and oracle 10g

Regards,

[Hans Nieuwenhuis]

Think I found it.

The view that has the problem was never used within the solution, only in a getDataSetByQuery.

So it's dbi was not exported , and therefore also not imported at the server.

I now created a (dummy) relation based on this view and then it gets exported.

Will test the importing tomorrow and let You now.

Regards,

[mboegem]

Hi Hans,

on exporting the solution there's also a checkbox to make Servoy export every table from the referenced servers.

[Harjo]

Yes, this is always tricky with Servoy! In older version of Servoy this was really never a problem, because you had to create form, for working with records.
In new versions of Servoy, we more & more, use on the fly foundsets in code, and these tables will not be referenced by Servoy.
So we always create a dummy form, for every table, we use in a solution, to prevent this...

[Harjo]

Hi Hans,

on exporting the solution there's also a checkbox to make Servoy export every table from the referenced servers.

Look closely, that is says: referenced, so if you use a server, which you only use in code, and never referenced in form or relation, this also will break...

[Hans Nieuwenhuis]

Hello Marc,

I also thougt of that, but that only works for tables not for views

The only workaround is to create dummy usage ( like a relation ) and the servoy will export it.
I tested and it also imports on servoy server, so my issue is solved.

I am also looking into to creating a primary key on the view, that is possible in Oracle.

Thanks,