A question regarding messages table

Classic Servoy
1

Hello,

we are using the messages table in our interface for a few things. Therefore, we need to setup a relation for the reference value plus a language (locale) dependant relation.

The question is, how should the relation pointing to the reference value be constructed: using an empty global or setting the global to null.

I have noticed, that most of the reference values stored in the messages table have the language_key set to NULL. So I set my global to null. But somehow, when I partly use the Servoy i18n tools and my own, I end up having duplicate keys.

What has to be stored in a reference value’s language column: NULL or ‘’?

Thanks
Patrick

2

Internally we use both:

“message_language = ‘’ or message_language is null”

for getting the default values.

How do you get duplicate keys? Are you saying if you have a key “x” for null you can through our tool insert one with “” ?
How?

3

Thanks for coming back with this :)

I think at the time I had “duplicate” keys because the relation created records using ‘’ as language key and the Servoy tool created a NULL value. The problem is that I cannot setup the relation to do

“message_language = ‘’ or message_language is null”

It looks that 2.2.4 has fixed some issues on creating related records where such a NULL global was involved. I will verify this further and get back to you if there still is an issue.

Thanks
Patrick