topic SV:Script editor error: "Unknown statement: MakeTime" in QlikView

Script editor error: "Unknown statement: MakeTime"

smoon63 — Thu, 13 Aug 2009 22:34:41 GMT

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

SV:Script editor error: "Unknown statement: MakeTime"

Sat, 15 Aug 2009 07:04:08 GMT

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);

Script editor error: "Unknown statement: MakeTime"

smoon63 — Mon, 17 Aug 2009 21:55:35 GMT

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