pcsoft.us.windevCopyright 2026, PC SOFT30 Aug 2016 12:28:00 Z27 Aug 2016 12:39:00 ZHello, How to pass a set of parameter to query which is filtered with 'in..' Select * From [TableName] Where [ColumnName] in [(param1)] I need to pass value to this param1 from windev. Usually I assign values like this query.param1 = 'A' Couldn't find out how to pass array of values. Happiness Always BKR Sivaprakash30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59340/read.awp30 Aug 2016 12:28:00 ZThanks Peter Holemans, it's working now.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59340/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59340/read.awp[WD20] [HFSQL20] Passing parameterguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59338/read.awp30 Aug 2016 11:50:00 ZHaven't read the thread completely, but this should do the trick: MyQuery.MyInListParameter = Arraystostring(YourStringArrayV…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59338/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59338/read.awp[WD20] [HFSQL20] Passing parameterguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59336/read.awp30 Aug 2016 08:48:00 ZThanks Alexandre Leclerc, Yogi Yang. Now this works fine. It's my mistake, in assigning the values. The way mentioned by Fabr…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59336/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59336/read.awp[WD20] [HFSQL20] Passing parameterguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59323/read.awp29 Aug 2016 16:29:00 ZHi Yogi, In fact it depends of the type and how you pass the parameters. Except I'm mistaken, it goes as follow: If this i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59323/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59323/read.awp[WD20] [HFSQL20] Passing parameterguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59322/read.awp29 Aug 2016 16:18:00 ZHello, I believe you will have to build the query parameter list by separating each value by comma (,) and not semi colons. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59322/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59322/read.awp[WD20] [HFSQL20] Passing parameterfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59318/read.awp29 Aug 2016 16:14:54 ZHi the firts thing would be to test the return of hexecutequery AND to display the detailed error Best regards -- F…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59318/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59318/read.awp[WD20] [HFSQL20] Passing parameterguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59327/read.awp29 Aug 2016 16:14:00 ZHi Sivaprakash, What is the name of your actual query? Is it a query you made with the query editor or is it a query you made…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59327/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59327/read.awp[WD20] [HFSQL20] Passing parameterguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59321/read.awp29 Aug 2016 16:03:00 ZSorry, I missed to quote here. But in my code, it's there.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59321/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59321/read.awp[WD20] [HFSQL20] Passing parameterguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59314/read.awp29 Aug 2016 16:00:00 ZHave you tried table1.browsedfile = "qry" with quotes around?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59314/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59314/read.awp[WD20] [HFSQL20] Passing parameterguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59313/read.awp29 Aug 2016 15:56:00 ZHello, Trying to display the query result in a table. Query is Select * From [TableName] Where [ColumnName] in [(param1)…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59313/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59313/read.awp[WD20] [HFSQL20] Passing parameterguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59285/read.awp27 Aug 2016 13:22:00 ZHi from the top of my head, it's something like: Query.paramIN = "A;B;C" Best regardshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59285/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/59277-wd20-hfsql20-passing-parameter-59285/read.awp[WD20] [HFSQL20] Passing parameter