Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
smoon63
Partner - Creator

Script editor error: "Unknown statement: MakeTime"

I am attempting to use the MakeTime function in my LOAD script, and I get the error "Unknown statement: MakeTime" every time the statement tries to load. I am using MakeTime to accomplish the same task in the Expression editor with no problem whatsoever. Can MakeTime not be used in a LOAD script? Following is the exact line in my script that causes the problem:

MakeTime(hour(Call_Taking_Time), minute(Call_Taking_Time), second(Call_Taking_Time)) as Call_Taking_Time_NEW

The argument (Call_Taking_Time) is calculated as follows:

num(TimeCallEnteredQueueTime) - num(TimePhonePickupTime) as Call_Taking_Time,

The arguments in the num() function are both timestamps.

I am using QV Developer v8.50.6231.5

Hope someone can explain this - seems like a possible bug unless there's something I'm missing

Thanks a lot,

Scott Moon

1 Solution

Accepted Solutions
smoon63
Partner - Creator
Author

Oops! I meant to post back the same day and report that it was simply a good old "ID 10 T" error. I had left an uncommented piece of code after the end of the script, which was a sample of the MakeTime function I had used to access the help file on that function. I killed that and the script was fine.

Thanks for the input, but it was in reality a non-issue!

Scott Moon

View solution in original post

2 Replies
Not applicable

Are you using preceding load when calling Call_Taking_Time? It works when I test the following (in 8.2). Otherwise you could comment out the Call_Taking_Time_NEW line and see what Call_Taking_Time returns.

/Michael

load

MakeTime(hour(Call_Taking_Time), minute(Call_Taking_Time), second(Call_Taking_Time)) as Call_Taking_Time_NEW;

load

num(now())-num(now(2)) as Call_Taking_Time

autogenerate(1);



smoon63
Partner - Creator
Author

Oops! I meant to post back the same day and report that it was simply a good old "ID 10 T" error. I had left an uncommented piece of code after the end of the script, which was a sample of the MakeTime function I had used to access the help file on that function. I killed that and the script was fine.

Thanks for the input, but it was in reality a non-issue!

Scott Moon