Renauld,
I'd recommend an alternate solution. Use a queue of future events where you simply store the datetime of when something is supposed to happen. Then your query code can simply check to see if there are any rows with a value less than the current datetime they need to be processed.
>somebody clear my mind. I'm doing an application with timed event. This is pre-configure and saved in a *.mem file.
>I have a spinner control for inputting the time, so if the user set this to 12:45AM im saving it as 45(N) in a memory variable.
>The code for the timer scenario will be at everyday at this hour with an allowance time for checking like 10 minutes after the default time.
>My code should be look like this
> IF between(datetime(), nDefaultTime, (nDefaultTime + 10))
> .. do some processing
> ELSE
> .. do nothing
> ENDIF
>
>My real problem here is to how to convert the nDefaultTime to a datetime format so I can compare it to the datetime(). Please enlighten me.
>How can I convert my 45(N) to a datetime field, any ideas? TIA!