- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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