PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → Search in Query
Search in Query
Débuté par Damian, 12 sep. 2008 01:03 - 4 réponses
#1
Posté le 12 septembre 2008 - 01:03
Hi,
I have created a Query, and I need to create a search to locate a certain value
My Query is:
HExecuteQuery(MyQuery,hQueryDefault,MyID)
And now I use a Hfilter
SearchKey=HFilter(MyQuery,"MyQuery.MyValue =" +ValueX)
HReadFirst(QRY_MyQuery, SearchKey)
This filter always returns the same value to me and this is not correct I have different values
somebody has some idea of how is due to correctly make the search in a Query?
Thanks in advance
Regards
/Damian
#2
Posté le 12 septembre 2008 - 01:02
I think you need to check the format of the HFilter:
= HFilter(, , [, [, ]])
We use the HFilter extensively on queries and the work fine. You seem to be missing the search key field.
Jeff
#3
Posté le 15 septembre 2008 - 01:10
Saw your post late.
Have you considered:
MyQuery.MyID=MyValue
HExecuteQuery(MyQuery,hQueryDefault,MyID)
//
HReadFirst(MyQuery)
#4
Posté le 15 septembre 2008 - 01:11
Jeff Graham, Al ,Dennis
Thank you for your answer.
Damian
#5
Posté le 15 septembre 2008 - 01:12
Hello Damian,
SearchKey=HFilter(MyQuery,"MyQuery.MyValue =" +ValueX)
HReadFirst(QRY_MyQuery, SearchKey)
The sought value must have a ' if front and a ' in the back
SearchKey=HFilter("MyQuery,MyQuery.MyValue = '12' ")
So if you are going to use a variable to search a string it should look like this:
SearchKey=HFilter(MyQuery,"PO_Number ~] "+ "'" + EDT_Quick_Search_Page1 + "'")
If you are searching on a number like an ID field
HFilter(MyQuery,ID,SoughtID) // this uses the lower bound upper bound good to find things in ranges
Dennis
→ Revenir à WINDEV 2024