PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → HFilter
HFilter
Débuté par Glenn Rathke, 15 juin 2005 17:41 - 3 réponses
Posté le 15 juin 2005 - 17:41
Clearly I don't understand HFilter.

I can get HFilter to work on a File Table as below:
// All Tab
HFilter(Boat_WorkOrder,Boat_FK,Boat_PK,Boat_PK)
TableDisplay(Table_Boat_WorkOrder,taStart)

But I can't get HFilter to work on a Query, below is the code.
// Open Tab
HFilter(Billing_WorkOrder_Open_Query,Table_Billing_WorkOrder_Open.Boat_FK,Boat_PK,Boat_PK)
TableDisplay(Table_Billing_WorkOrder_Open,taStart)
Surely I'm doing something wrong, but what ?
Thanks GLenn
Posté le 15 juin 2005 - 18:36
Clearly I don't understand HFilter.

I can get HFilter to work on a File Table as below:
// All Tab
HFilter(Boat_WorkOrder,Boat_FK,Boat_PK,Boat_PK)
TableDisplay(Table_Boat_WorkOrder,taStart)

But I can't get HFilter to work on a Query, below is the code.
// Open Tab
HFilter(Billing_WorkOrder_Open_Query,Table_Billing_WorkOrder_Open.Boat_FK,Boat_PK,Boat_PK)
TableDisplay(Table_Billing_WorkOrder_Open,taStart)
Surely I'm doing something wrong, but what ?
Thanks GLenn

Hi,
Your file names etc are impressive, I'd get lost all the time...
Table_Billing_WorkOrder_Open.Boat_FK in your query filter should be the name of the item to filter. Something wrong with the "." and extension name...
Regards
mat
Posté le 15 juin 2005 - 18:40
...
the item to filter. Something wrong with the "." and extension name...
...
... sorry, wrong way round... the problem is the file name and "."
Regards
mat
Posté le 22 juin 2005 - 16:05
Try to format it like this;

HReadFirst(Billing_WorkOrder_Open_Query,HFilter(Billing_WorkOrder_Open_Query,Table_Billing_WorkOrder_Open.Boat_FK,Boat_PK,Boat_PK)

Sven.