PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
WINDEV 2024
→
Gantt column end date?
Gantt column end date?
Started by marin, Apr., 12 2021 10:02 AM - 3 replies
Connect yourself…
marin
#1
Registered member
27 messages
Posted on April, 12 2021 - 10:02 AM
Hi,
Gantt column only show chart for 2011 - 2013, even there are dates up to 2021. What could it be?
Here is code for display data in table.
citaj is Record of QRY_PrikazPodataka
IF HExecuteQuery(QRY_PrikazPodataka,hQueryDefault) = True THEN
FOR EACH QRY_PrikazPodataka
HReadNext(QRY_PrikazPodataka)
IF NOT HOut() THEN
citaj = QRY_PrikazPodataka
gsNStrojevi = citaj.PmNr
datum is Date = citaj.StartTerm
gdPocetak = StringToDate(datum,"YYYYMMDDHHmmSS")
gnTrajanje = citaj.Zeit
postotak is int = 0
gnPostotak = postotak
// info(gsNStrojevi)
// info(gdPocetak)
// info(gnTrajanje)
AddTask()
END
END
END
I could not find any option of limiting end date showed in chart.
Report
0
0
Andrea Chiadò Piat
#2
Registered member
54 messages
Popularité : +2 (2 votes)
Posted on April, 12 2021 - 11:05 AM
Hello Marin,
I dont know if this resolve your problem, but if you cicle with FOR EACH QRY why you HReadNext(QRY)?
It seems to me you dont read all records in your query...
FOR EACH record you jump to the next record
It should be
citaj is Record of QRY_PrikazPodataka
IF HExecuteQuery(QRY_PrikazPodataka,hQueryDefault) = True THEN
FOR EACH QRY_PrikazPodataka
citaj = QRY_PrikazPodataka
gsNStrojevi = citaj.PmNr
datum is Date = citaj.StartTerm
gdPocetak = StringToDate(datum,"YYYYMMDDHHmmSS")
gnTrajanje = citaj.Zeit
postotak is int = 0
gnPostotak = postotak
// info(gsNStrojevi)
// info(gdPocetak)
// info(gnTrajanje)
AddTask()
END
END
or
citaj is Record of QRY_PrikazPodataka
IF HExecuteQuery(QRY_PrikazPodataka,hQueryDefault) = True THEN
WHILE HFound(QRY_PrikazPodataka)
citaj = QRY_PrikazPodataka
gsNStrojevi = citaj.PmNr
datum is Date = citaj.StartTerm
gdPocetak = StringToDate(datum,"YYYYMMDDHHmmSS")
gnTrajanje = citaj.Zeit
postotak is int = 0
gnPostotak = postotak
// info(gsNStrojevi)
// info(gdPocetak)
// info(gnTrajanje)
AddTask()
HReadNext(QRY_PrikazPodataka)
END
END
I'm wrong?
Andrea
Report
0
0
marin
#3
Registered member
27 messages
Posted on April, 12 2021 - 12:51 PM
Thank you, you are right, without HreadNext line it reads a lot more data.
Report
0
0
marin
#4
Registered member
27 messages
Posted on April, 12 2021 - 1:24 PM
If somebody is wondering, I solved the problem by ignoring data from older years (from 2011) and made query for the last few years which is more important, and it works. It is showing gantt column up to date.
Report
0
0
→ Go back to WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text