PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → changing query on same table control
changing query on same table control
Débuté par joe crevino, 29 mar. 2004 05:31 - 2 réponses
#1
Posté le 29 mars 2004 - 05:31
What is the code to execute a new query returning the same fields to a table control. The table control starts with query1 then a button call query2.
thank you,
joe
#2
Posté le 30 mars 2004 - 10:41
To change the contents of a table with another query use the following:
HExecuteQuery({QueryName},hQueryDefault,{parameters})
{TableName}..BrowsedFile={QueryName}
between the signs {} you have to replace the descriptionwith your values.
greetings,
Joop
Member of the dutch speaking WinDev Developer Group (WDG)

What is the code to execute a new query returning the same fields to a table control. The table control starts with query1 then a button call query2.
thank you,
joe



New-Way Automation b.v.
#3
Posté le 30 mars 2004 - 12:27
Hi Joe,
Better to use the same query, but with more params, then fill those params with the info your require and hexecute the query once again.
Works well as you can fill with Null values those parmas you don't want to consider, or sit down and work out the order in which params will be used and fill them in order, so the unfilled automatically return Null.
I use this system all the time, you only have to rer-run the query and redisplay the table to get the new result.
Gill

What is the code to execute a new query returning the same fields to a table control. The table control starts with query1 then a button call query2.
thank you,
joe
→ Revenir à WINDEV 2024