Trouble with version 9.9.0.14?

Hello…
When in a field check “Use of lookup to show the description of the field.” and loaded the select (for example,“Select Nombre_Cliente From Clientes where Cod_Cliente = {Cod_Cliente}”), loading a data in the field does not return the value (in this case, the client’s name)
In 9.9.0.13 work fine… but in the new versión, fail in all apps…
Some solution?
Thanks!!!

Hi,
in grid? form? chart?

For grids I recommend use sql joins instead lookups, more effective.

workaround, use a second field {cod_cliente} with alias, with no lookup

Hello… Is in a form.

Whats the lookup in field {cod_cliente} ?

it should be something like this select cod_cliente, nombre_clientee from clientes

or simply the cod_cliente ?

The field Cod_Cliente is the field in edit. Nombre_Cliente depends from him.
This select work fine to the last update of SC.

Hello @asantarelli

What return do you get from the lookup?

Are any errors displayed?

Regards

Hello… i want show the client name, when the user input this code (by example…)