Posted: April 05 2003 at 18:13 | IP Logged

If I create a timed event 10 seconds from now with:

ph_createtimedevent( 0, "FLASH USER MESSAGE", datetime(today(),relativetime(now(),10)) )

I get a return value of 0 and everything works as expected.

if I use a different macro as:

ph_createtimedevent( 0, "A ON", datetime(today(),relativetime(now(),10)) )

where A ON does an X10 A ON

I get a return value of -1 and a timed event of mm/dd/yyyy 00:00:00

What am I doing wrong?

Posted: April 07 2003 at 17:21 | IP Logged

Pat,

Well I played with this and played with this and finally found the answer.  The problem is an undocumented bug within the PowerBuilder environment and really has nothing to do with the macro name but instead has to do with the relativetime function.

Apparently the relativetime function will return the time with 6 digits of precision (microseconds) in the fractional seconds field and the insert statement into the timedevents table really only wants to work with 3 digits of precision (milliseconds).  Sometimes it works and sometimes it doesnt.  It's very inconsistent.

Now the workaround...we'll first convert the time to a string and effectively round it to the second.  We then convert that back to a time.  Kludgy, but its the only way Ive been able to get it to work.  I'll create a new PowerHome function that will automatically do this for you for the next version.  Here is the reworked version of your statement:

ph_createtimedevent(0,"A ON",datetime(today(),time(string(relativetime(now(),10),"hh:mm:ss"))))

HTH,

Dave.