PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
Inicio → WINDEV 2024 → Queries and Dates
Queries and Dates
Iniciado por Newbie, mai., 20 2004 3:50 AM - 4 respostas
#1
Publicado em maio, 20 2004 - 3:50 AM
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 em maio, 22 2004 - 1:40 PM
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 em maio, 22 2004 - 2:09 PM
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 em maio, 23 2004 - 8:38 AM
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 em maio, 24 2004 - 1:59 AM
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
→ Voltar para WINDEV 2024