Question: In SQL window, when is cell button enabled for foreign keys?

[Claus Pedersen]

I have a table with some foreign keys. When editing data in this table, the cell button with list-of-values is shown for some of the columns but not for all.

I have a mandatory column with a foreign key to another table: the cell button is shown (but only when I manually place the cursor in the field, otherwise it does not show)

I have a optional foreign key to another table: the cell button is NOT shown

Is this a known issue?

I have tried to reproduce this situation on scott/tiger, but with no success: the cell button is shown correctly both for mandatory and non-mandatory columns

Please check that the cell button is also shown in case of foreign keys to the table itself (heirarcical structure).

 

[Marco Kalter]

There are a few requirements (restrictions):

1. The foreign key constraint must be enabled.
2. The foreign key constraint must consist of just 1 column.
3. The referenced table must contain less than 1000 rows.

Perhaps one of these requirements is not met?

 

[Claus Pedersen]

Thank you for the quick reply.

My referenced tables have far more than 1000 rows, so this is the reason.

Is it possible always to show the cell button but in case of the rules two and three, the button could be shown, but disabled? This way one could get a visual indication whether the column has foreign keys.

What about the case that the cell button only appears when I manually place the cursor in the cell? If it is a performance issue I suggest that the cell buttons are shown but disabled for all columns with foreign keys, check constraints, date formats etc. Then the user could have a visual indication that values for this column have some limitations. When the user places the cursor in that column, at that time it could be checked whether the referenced table has less than 1000 rows and in that case the cell button could be enabled, otherwise it stays disabled.

NB: Curious as always, I have performed a little test. I have a table with 8600 records, and a referenced table. It seems that the number of rows in the referenced table when the cell button is shown is not 1000 but in my case 333. Is this correct?

Best regards
Claus Pedersen

 

[Marco Kalter]

Is it possible always to show the cell button but in case of the rules two and three, the button could be shown, but disabled?

I have added this to the list of enhancement requests.

I have a table with 8600 records, and a referenced table. It seems that the number of rows in the referenced table when the cell button is shown is not 1000 but in my case 333. Is this correct?

Yes. 333 is less than 1000.

 

[Claus Pedersen]

Yes. 333 is less than 1000.

Thanks for the enlightment. My weekend is now saved

 

[Marco Kalter]

You're welcome. Math has always been one of my specialties .