pcsoft.us.windevCopyright 2026, PC SOFT12 Aug 2015 02:51:34 Z11 Aug 2015 19:39:28 ZI have a query which works when previewed, returning 125 records out of 13372 but when I run it in my program: HExecuteQuery(QRY_BurialPeriod) nCount = HNbRec(QRY_BurialPeriod) returns 13372 The Query is: SELECT RTRIM(burial.Last_Name) +', ' + RTRIM(burial.First_Name) AS cFullName, burial.Sex AS Sex, burial.Burial_Type AS Burial_Type, Burial_Date AS Burial_Date, ROUND(MONTHS_BETWEEN(burial.Death_Date, burial.Birth_Date)/12,0) AS Age FROM burial WHERE burial.Burial_Date BETWEEN {gdReport_Start} AND {gdReport_End} ORDER BY cFullName ASC30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53493-query-works-preview-but-not-program/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)gallen.dbmcpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53493-query-works-preview-but-not-program-53507/read.awp12 Aug 2015 02:51:34 ZI guess it is a mistake made by a beginner! Changing HExecuteQuery(QRY_BurialPeriod) to HExecuteQuery(QRY_BurialPeriod,hWith…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53493-query-works-preview-but-not-program-53507/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53493-query-works-preview-but-not-program-53507/read.awpQuery works in preview but not in program