PC SOFT

FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile

Inicio | Mensajes recientes | Conéctese... |  | Español FR
Inicio → WINDEV 2024 → Queries and Dates
Queries and Dates
Iniciado por Newbie, 20,may. 2004 03:50 - 4 respuestas
#1
Publicado el 20,mayo 2004 - 03:50
Hello everyone
Just starting to get into Queries with WinDev 7.5
i have created a query using the wizard to work on 2 dates
i used "Included between 2 dates" with Params
startparam and endparam
on a table using the query i have 2 edit controls
StartDate and EndDate in date format, returning yyyymmdd
and i have checked the Null box
on a button i have coded
HExecuteQuery(SortInvoice,hQueryDefault,StartDate,EndDate)
TableDisplay(SortInvoiceTable,taStart)
nbEnr is int
HReadFirst(SortInvoice)
WHILE NOT HOut()
nbEnr++
HReadNext(SortInvoice)
END
this only works if both dates are the same ?
can anyone point me in the right direction the
manuals do not seem to cover this and i cannot fine any
examples on how to do this.
thanks for an help
Newbie
#2
Publicado el 22,mayo 2004 - 13:40
Hello everyone
it seems there must be some sort of bug in what
i am trying to do, i tryed everthing
maybe hfilter is way to go ?
Tom

Hello everyone
Just starting to get into Queries with WinDev 7.5
i have created a query using the wizard to work on 2 dates
i used "Included between 2 dates" with Params
startparam and endparam
on a table using the query i have 2 edit controls
StartDate and EndDate in date format, returning yyyymmdd
and i have checked the Null box
on a button i have coded
HExecuteQuery(SortInvoice,hQueryDefault,StartDate,EndDate)
TableDisplay(SortInvoiceTable,taStart)
nbEnr is int
HReadFirst(SortInvoice)
WHILE NOT HOut()
nbEnr++
HReadNext(SortInvoice)
END
this only works if both dates are the same ?
can anyone point me in the right direction the
manuals do not seem to cover this and i cannot fine any
examples on how to do this.
thanks for an help
Newbie
#3
Publicado el 22,mayo 2004 - 14:09
Hello everyone
i got the query to work
by changing the order of my date key in
annalysis from descending to ascending
surely this must be a BUG in 7.5
Tom

Hello everyone
Just starting to get into Queries with WinDev 7.5
i have created a query using the wizard to work on 2 dates
i used "Included between 2 dates" with Params
startparam and endparam
on a table using the query i have 2 edit controls
StartDate and EndDate in date format, returning yyyymmdd
and i have checked the Null box
on a button i have coded
HExecuteQuery(SortInvoice,hQueryDefault,StartDate,EndDate)
TableDisplay(SortInvoiceTable,taStart)
nbEnr is int
HReadFirst(SortInvoice)
WHILE NOT HOut()
nbEnr++
HReadNext(SortInvoice)
END
this only works if both dates are the same ?
can anyone point me in the right direction the
manuals do not seem to cover this and i cannot fine any
examples on how to do this.
thanks for an help
Newbie
#4
Publicado el 23,mayo 2004 - 08:38
G'day Tom
You can download a reporting tool from PCSoft to let them know about it.
http://www.pcsoft.fr/us/ts/download/TechSupportRequest.htm
If you use this tool to report bugs/problems/suggestions you will get a response from PCSoft and an answer.
Regards
Al
#5
Publicado el 24,mayo 2004 - 01:59
Hello Al
thanks, took your advise and did it
Tom
G'day Tom
You can download a reporting tool from PCSoft to let them know about it.
http://www.pcsoft.fr/us/ts/download/TechSupportRequest.htm
If you use this tool to report bugs/problems/suggestions you will get a response from PCSoft and an answer.
Regards
Al
→ Volver a WINDEV 2024