pcsoft.us.windevCopyright 2026, PC SOFT3 Nov 2016 20:47:10 Z22 Oct 2016 20:04:07 ZI've been away from developing in WinDev20 for some time so maybe I've become 'stupid' but I can't figure this out. I have a Query which, if I test in the Query editor, gives me the results I expect. It looks like this: SELECT RBL_BRES.TOUR_DATE AS TOUR_DATE, RBL_BRES.TOUR_TIME AS TOUR_TIME, RBL_BRES.PASSENGERS AS PASSENGERS, RBL_BRES.BOATID AS BOATID, RBL_BRES.CANC_DATE AS CANC_DATE FROM RBL_BRES WHERE RBL_BRES.TOUR_DATE = {dpDate} AND RBL_BRES.BOATID = {spBOAT_ID} AND RBL_BRES.CANC_DATE < '19000101' ORDER BY TOUR_TIME ASC The results show 10 records with the first time at 10:00 and 55 passengers but in my program: PROCEDURE Cap_Pass() iPos is int IF HExecuteQuery(QRY_Cap_Reservation) HReadFirst(QRY_Cap_Reservation) WHILE NOT HOut(QRY_Cap_Reservation) Info(QRY_Cap_Reservation.TOUR_TIME +" " +QRY_Cap_Reservation.PASSENGERS) ...... it shows the first time as 8:00 and 1 passenger I am using the same values for dpDate and spBoat_ID that I used for testing the Query What could possibly be going on? -- Garry30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60087-strange-query-result/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)gallen.dbmcpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60087-strange-query-result-60225/read.awp3 Nov 2016 20:47:10 ZThanks for trying Fabrice. I only had one other copy of RBL_BRes on my machine and I renamed it but the problem persists. Could…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60087-strange-query-result-60225/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60087-strange-query-result-60225/read.awpStrange Query resultfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60087-strange-query-result-60173/read.awp30 Oct 2016 13:19:47 ZHi Garry, it looks like you ahve two sets of files, and are not accessing the same set in both cases... Best regards…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60087-strange-query-result-60173/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60087-strange-query-result-60173/read.awpStrange Query resultgallen.dbmcpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60087-strange-query-result-60170/read.awp29 Oct 2016 20:13:20 ZSorry to bring this up again but I have had no response and I still can't figure it out. I displayed the results of the Query i…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60087-strange-query-result-60170/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60087-strange-query-result-60170/read.awpStrange Query result