show dictionary info in result grid

[Jean-Paul Finne]

How do you determine the columns to display in the grid ?

Sometimes I obtain only the primary key (not very useful), sometimes 2 columns (ok), sometimes even 3 columns.

Do you use the indexed columns ?

Jean-Paul

 

[Marco Kalter]

It uses the primary key column (not always useful, sometimes essential), and the 2 first non primary key columns. If the table also contains a "name" or "description" column, it will use that.

It currently does not look at indexes or unique key constraints.

------------------
Marco Kalter
Allround Automations

 

[Jean-Paul Finne]

Is it possible to define a list of useful column names ?

I have tables with columns "code", "shortcut".

A french collegue uses french column name like "nom" instead of "name".

Jean-Paul

 

[Marco Kalter]

I have added this to the list of enhancement requests. It's easy enough to implement, and we don't want to discriminate any language regions of course

.

------------------
Marco Kalter
Allround Automations