PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → WD19 - Ignoring Query rows for table control
WD19 - Ignoring Query rows for table control
Débuté par Dave Summers, 01 fév. 2015 17:44 - 1 réponse
#1
Posté le 01 février 2015 - 17:44
Hi

I have a standard query that is used to populate a table control. I need to ignore certain rows returned from the query but the logic is too complicated to build into the query so is there a way within the table control to skip data based on logic.

Very similar to a code block in the report writer where you can omit records by a return value which is fantastic

The only other way i can do it if it is not possible is to read the query (hexecuteQuery) and manually populate the lines of the table where necessary but i was hoping there was a better way

any help appreciated

cheers
Dave
#2
Posté le 02 février 2015 - 14:24
Dave,

the only additional way I can think of is the 'Displaying a row of TABLE_' section of your table. There you can filter out any row you don't want to display.

Have a look at the CurrentSubscript() function: http://doc.windev.com/en-US/…

HTH
Sebastian
→ Revenir à WINDEV 2024