|
| Iniciado por Fritswinkel, 20,sep. 2015 10:07 - 3 respuestas |
| |
| | | |
|
| |
Miembro registrado
9 mensajes |
|
| Publicado el 20,septiembre 2015 - 10:07 |
Hello,
It should be really simple but I cant get it done.
I have a file with a date and a time field.
The time field is used as a flag to know when the record has been handled.
I want to filter on an exact date and want a condition on the time field.
So date is x and time is later then 12:00
Anybody know how to do this? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 21,septiembre 2015 - 01:01 |
Hi
If you have a composite key on date + time, then it's just
hfilter(FileName,CompositeKey,
[DateValue,"12000000"],[DateValue,"23595999"])
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
Already there: WXShowroom.com, WXReplication (open source)
Coming soon: WXEDM (open source)
More information on http://www.fabriceharari.com
On 9/20/2015 2:07 AM, Fritsvv wrote:
Hello,
It should be really simple but I cant get it done.
I have a file with a date and a time field.
The time field is used as a flag to know when the record has been handled.
I want to filter on an exact date and want a condition on the time field.
So date is x and time is later then 12:00
Anybody know how to do this? |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
9 mensajes |
|
| Publicado el 21,septiembre 2015 - 08:06 |
Yeah dont have a composite key if I cant find a solution I wil have to make it. Means updating the data files of 17 different users really annoying.
I was hoping I could just stick to updating the executable. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 21,septiembre 2015 - 11:09 |
If you are using HF, updating the DB means just installing the new
version while having check the update option.
If you are ready for a SLOW (or at least slower) access, you can use the
hfilter "condition" syntax, where you put your conditions in a string at
the end. This is explained in the help with examples.
Of course, you can also use a query. But as you are talking about filters...
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
Already there: WXShowroom.com, WXReplication (open source)
Coming soon: WXEDM (open source)
More information on http://www.fabriceharari.com
On 9/21/2015 12:06 AM, Fritsvv wrote:
Yeah dont have a composite key if I cant find a solution I wil have to
make it. Means updating the data files of 17 different users really
annoying.
I was hoping I could just stick to updating the executable. |
| |
| |
| | | |
|
| | | | |
| | |
|