PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → wd8 : sort order in query not done in the table with tableaddline
wd8 : sort order in query not done in the table with tableaddline
Débuté par Christine, 30 mai 2005 11:33 - 1 réponse
#1
Posté le 30 mai 2005 - 11:33
Hello,
I have a table based on programmed code.
The table is build with TABLEADDLINE.
I execute a query and loop the records of the query and do a tableaddline.
My problem is that the records are not in the correct sortorder in my table.
It concerns about 288 records And the query is build with the queryBuilder of windev and a sortOrder is given to a field "Foutmelding".
When i execute the query in the builder it is NOT sorted on this field.
And in the execution of the while loop ...
WHILE NOT HOut(QCollisPerOrder_form_TColli)
.... it starts with a records which is not sorted on "foutmelding"..
What can i do wrong.
Chrsitine
#2
Posté le 30 mai 2005 - 12:19
What i did :
I put the fields to be sorted on the top of my query builder description.
I Recompiled the project.
Then in the interface the query is build correct.
In my code i did :
HReadFirst(QCollisPerOrder_form_TColli,QCollisPerOrder_form_TColli.coColliRefsID)
where i added another key to read.... Not the correct one..
→ Revenir à WINDEV 2024