PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEV, WEBDEV and WINDEV Mobile

Home | Recent messages | Connect |  | English US
Home → WINDEV 2024 → changing query on same table control
changing query on same table control
Started by joe crevino, Mar., 29 2004 5:31 AM - 2 replies
#1
Posted on March, 29 2004 - 5:31 AM
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
Posted on March, 30 2004 - 10:41 AM
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
Posted on March, 30 2004 - 12:27 PM
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
→ Go back to WINDEV 2024