pcsoft.us.windevCopyright 2026, PC SOFT13 Jun 2017 07:50:15 Z11 May 2010 08:22:58 ZHi, I have what seems to be a simple question, but can't seem to get my head around how the retrieval of data works for query datasets in WD - maybe it's too late for me to be thinking :confused: I have a simple select query that returns a count: SELECT COUNT(*) FROM PRODUCTS; Then I use HExecuteQuery, but how do I retrieve the COUNT(*) value? I'm pretty sure it's a HRead... of some kind, but what's the syntax? Thanks in advance...30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/25589-wd12-how-access-count-from-query/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)sandra louispcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/25589-wd12-how-access-count-from-query-61286/read.awp13 Jun 2017 07:50:15 ZQueries are helpful way of extracting information from one or more tables based on a set of search condition given by you. This …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/25589-wd12-how-access-count-from-query-61286/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/25589-wd12-how-access-count-from-query-61286/read.awp[WD12] How to access COUNT(*) from a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/25589-wd12-how-access-count-from-query-25599/read.awp11 May 2010 11:52:37 ZArie, Thanks for the explaination... now I understand :spos:https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/25589-wd12-how-access-count-from-query-25599/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/25589-wd12-how-access-count-from-query-25599/read.awp[WD12] How to access COUNT(*) from a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/25589-wd12-how-access-count-from-query-25597/read.awp11 May 2010 11:03:07 ZDarren, how do you build your query? If you are using the designer the "count(*)" gets an alias like count_1 "select count(*) …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/25589-wd12-how-access-count-from-query-25597/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/25589-wd12-how-access-count-from-query-25597/read.awp[WD12] How to access COUNT(*) from a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/25589-wd12-how-access-count-from-query-25592/read.awp11 May 2010 08:23:54 ZHi Al, Thanks for the reply... Just tried it and the answer is "yes" it works! :cheers: [code] HExecuteQuery(QRY_CountActiv…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/25589-wd12-how-access-count-from-query-25592/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/25589-wd12-how-access-count-from-query-25592/read.awp[WD12] How to access COUNT(*) from a queryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/25589-wd12-how-access-count-from-query-25590/read.awp11 May 2010 08:23:19 ZHello Darren I don't use queries but I use views and I can get the number of records in a view with HnbRec() Can you use that …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/25589-wd12-how-access-count-from-query-25590/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/25589-wd12-how-access-count-from-query-25590/read.awp[WD12] How to access COUNT(*) from a query