My App has 2 tables: MATERIAIS and CONJUNTOS.
I was trying to select a group of information from MATERIAIS to CONJUNTOS based on a condition, and I got it.
SELECT (MATERIAIS [ITEM], [_THISROW].[VTR/EQ] = [VTR/EQ])
Now, I’m trying to filter this data. I need to get only data that contains the fragment “©”, like “Bolsa de SAlt ©”.
I tried to use CONTAINS() like…
CONTAINS(SELECT (MATERIAIS [ITEM], [_THISROW].[VTR/EQ] = [VTR/EQ]),“©”)
…or…
SELECT (MATERIAIS [ITEM], And([_THISROW].[VTR/EQ] = [VTR/EQ], CONTAINS(MATERIAIS [ITEM], “©”)))
… but didn’t work. (the field just don’t appears on app)
I need some help.
Tks.
Solved! Go to Solution.
Please try
SELECT (MATERIAIS [ITEM], And([_THISROW].[VTR/EQ] = [VTR/EQ], CONTAINS([ITEM], “©”)))
Please try
SELECT (MATERIAIS [ITEM], And([_THISROW].[VTR/EQ] = [VTR/EQ], CONTAINS([ITEM], “©”)))
Thanks for your help. It works perfectly.
Thanks a lot!
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |