Good guys,
In the Id_predepositado field of the dep_envio table,
Find the Id_predepositado in the dep_predepositos table, from the dep_envio table
But the result is in an enumlist field brings me the field completely and I just want the ID.
Hugs,
Pablo
Solved! Go to Solution.
The issue may be that your CONTAINS expression references the entire column of values rather than only the current row's values in the indicated column. Consider:
SELECT(dep_predepositos[Id_predepositado], CONTAINS([id_envioP],[_THISROW].[id]))
It works perfect
SELECT(dep_predepositos[Id_predeposito], CONTAINS([id_envioP],[_THISROW].[id]))
because adding the name of the table causes that error dep_predepositos[Id_envioP]
muchas gracias, por tu enorme ayuda.
thank you very much for your great help
Pablo
same result, samples 2 Id_predepositado
Thank you
The issue may be that your CONTAINS expression references the entire column of values rather than only the current row's values in the indicated column. Consider:
SELECT(dep_predepositos[Id_predepositado], CONTAINS([id_envioP],[_THISROW].[id]))
It works perfect
SELECT(dep_predepositos[Id_predeposito], CONTAINS([id_envioP],[_THISROW].[id]))
because adding the name of the table causes that error dep_predepositos[Id_envioP]
muchas gracias, por tu enorme ayuda.
thank you very much for your great help
Pablo
De nada.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |