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 |