query on one table without primary key

Classic Servoy
1

In company we use much software of third parts that they use DB servers like oracle, msqlserver etc. For this reason the database cannot be modified in their structure.

I have the necessity to use from Servoy form a table that does not have defined primary key.

It can in some way to use a work-around with Servoy 2.2.7?

Thanks

2

Hi Giovanni,

Depending on your need (only displaying or also editing) you can use pure SQL and HTML for displaying.
No if you also want to edit than that is more work.

Hope this helps.

3

Hello and thanks for the fast answer.

You have understood well. Only displaying data is my necessity and the solution that you propose goes very well.

Many Thanks

4

In 3.5, you can specify which column or columns identfy a unique row, even on exsiting tables.

Paul

5

Many Thanks for the suggestion.

We have planned the upgrade to september.