|
| Iniciado por guest, 15,ene. 2018 09:39 - 1 respuesta |
| |
| | | |
|
| |
| Publicado el 15,enero 2018 - 09:39 |
|Hi
I have a for all loop with a condition. I want to add a condition.
The condition nees to be a search
exampl
for all people where people.existing = true
looperaddline(...
end
exampl
for all people where "people.existing = true AND people.name LIKe edt_search"
looperaddline(...
end
But the like does not work. I donnot get the help it states to use a [ but that doesnot work
Please help
Regards
Allard |
| |
| |
| | | |
|
| | |
| |
| Publicado el 15,enero 2018 - 12:18 |
Hi Allard,
Use HExecuteSQLQuery: more easier and more faster:
MyQuery is Data Source
// Initializes the query
IF NOT HExecuteSQLQuery(MyQuery, ...
"SELECT * from people where existing='"+"true"+"' AND name LIKE '"+EDT_SEARCH+"'") THEN
Error("Error while initializing the query" + CR + HErrorInfo())
RETURN
END
// Read the first record of the query
HReadFirst(MyQuery)
WHILE NOT HOut()
LOOPERADDLINE....
HReadNext()
END |
| |
| |
| | | |
|
| | | | |
| | |
|