foundset.selectRecord case (in)sensitive

Classic Servoy
1

Hello,

If have composite keys for MySQL table and 1 of the type is VARCHAR, the selectRecord is case-sensitive;
Is there any way to configure this to be insensitive? MySQL is case insensitive by default and need to follow that principle on Servoy level

Regards

2

Imre,

That would be too specific for Servoy to support.
You can workaround this to always uppercase (or lowercase, depending on what the db returns) your pk before calling selectRecord().

Rob