|
FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile |
| | | | | |
| Iniciado por gallen.dbmc, 22,oct. 2016 20:04 - 3 respuestas |
| |
| | | |
|
| |
Miembro registrado
31 mensajes |
|
| Publicado el 22,octubre 2016 - 20:04 |
I'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?
--
Garry |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
31 mensajes |
|
| Publicado el 29,octubre 2016 - 20:13 |
Sorry 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 in a table and they look as expected but if I try to process the records I get weird results.
i.e
IF HExecuteQuery(QRY_Cap_Reservation)
FOR EACH QRY_Cap_Reservation
Info(QRY_Cap_Reservation.TOUR_TIME +" " +QRY_Cap_Reservation.PASSENGERS)
shows 8:00 1
but there are no results of the Query that look like that.
--
Garry |
| |
| |
| | | |
|
| | |
| |
| Publicado el 30,octubre 2016 - 13:19 |
Hi Garry,
it looks like you ahve two sets of files, and are not accessing the same
set in both cases...
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
Ready for you: WXShowroom.com, WXReplication (open source) and now WXEDM
(open source)
More information on http://www.fabriceharari.com
Le 10/29/2016 à 12:13 PM, Garry a écrit :
Sorry 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 in a table and they look as
expected but if I try to process the records I get weird results.
i.e IF HExecuteQuery(QRY_Cap_Reservation)
FOR EACH QRY_Cap_Reservation
Info(QRY_Cap_Reservation.TOUR_TIME +" " +QRY_Cap_Reservation.PASSENGERS)
shows 8:00 1
but there are no results of the Query that look like that.
--
Garry |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
31 mensajes |
|
| Publicado el 03,noviembre 2016 - 20:47 |
Thanks for trying Fabrice. I only had one other copy of RBL_BRes on my machine and I renamed it but the problem persists.
Could it be caused by some foobar configuration issue of the project or WinDev20?
--
Garry |
| |
| |
| | | |
|
| | | | |
| | |
| | |
| |
|
|
|