pcsoft.us.windevCopyright 2026, PC SOFT28 May 2015 12:44:12 Z26 May 2015 12:05:36 ZHi guys, I have a table named CITY with these fields: ID is a numeric field (unique key) Region is a string field (duplicated key) Country is a string field (duplicated key) City is a string field (duplicated key) Now I want to filter this table to find all the cities that are in a specific Region (example01) and a specific Country (example02): I use this filter: [code:wl] HFilter(CITY,Region,"Region="+example01+" AND Country="+example02) HreadFirst(CITY,Region) IF HFound(CITY) THEN // Do something ELSE // Do something else END HDeactivateFilter(CITY) [/code] It seems this filter does not work because it never finds the searched records even if they do exist in the table. What am I doing wrong? Thank you all for your care.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)antonino.neripcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52358/read.awp28 May 2015 12:44:12 ZHi Fabrice, thanks a lot for your time and help. Now everything is clear to me :) Kindest Regardshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52358/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52358/read.awpFilter tables on two string valuesfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52355/read.awp28 May 2015 11:09:32 ZHi Antonino no... I would not in that case... There is a help page somewhere where pcsoft is detailing what to use when (ge…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52355/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52355/read.awpFilter tables on two string valuesantonino.neripcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52353/read.awp28 May 2015 09:37:00 ZHi Fabrice, thanks again for the detailed explanation. I do understand that a unique answer does not exist and that every ca…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52353/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52353/read.awpFilter tables on two string valuesfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52349/read.awp27 May 2015 23:29:15 ZHi Antonino unfortunately, the answer to your question is much more complex than it seems... In theory, a query should a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52349/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52349/read.awpFilter tables on two string valuesantonino.neripcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52339/read.awp27 May 2015 18:02:45 ZHi Fabrice, thanks again for your explanations :) Just one more question: according your experience, which command is faster…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52339/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52339/read.awpFilter tables on two string valuesfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52318/read.awp26 May 2015 19:19:43 ZHi Antonino, gald I could help... as for the composite key, it's simple, really with your syntax and keys available only o…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52318/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52318/read.awpFilter tables on two string valuesantonino.neripcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52314/read.awp26 May 2015 17:45:57 ZHi Fabrice, thanks a lot for your help. You are right, I was missing the single quote around my values: [code:wl] HFilter…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52314/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52314/read.awpFilter tables on two string valuesfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52307/read.awp26 May 2015 14:57:21 ZHi Antonino, without knowing the content of your variables, it's hard to say, but it seems to me that you are missing the q…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52307/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52301-filter-tables-two-string-values-52307/read.awpFilter tables on two string values