Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all. I cannot figure out why my peek isn't working. The "ScopingDates" table loads with 1 row and a date value in both columns. The values and variables are coming up as Null() when I go through the debugger. I am able to pull back NoOfRows to be 1 and set that to a variable. I guess for some reason it's just coming up with a null for the value of those fields.
=========
ScopingDates:
Directory;
First 1
LOAD IA_Scope_Period_Beg_Dt,
IA_Scope_Period_End_Dt
FROM
QVD\AirDetails.QVD
(qvd);
ELSEIF NOT IsNull(FileTime('QVD\ProfitDetails.QVD')) THEN
Directory;
Concatenate
First 1
LOAD IA_Scope_Period_Beg_Dt,
IA_Scope_Period_End_Dt
FROM
QVD\ProfitDetails.QVD
(qvd);
END IF;
let ScopeBegin = peek(IA_Scope_Period_Beg_Dt,-1,'ScopingDates');
let ScopeEnd = peek(IA_Scope_Period_End_Dt,-1,'ScopingDates');
Try this
let ScopeBegin = peek('IA_Scope_Period_Beg_Dt',-1,ScopingDates);
let ScopeEnd = peek('IA_Scope_Period_End_Dt',-1,ScopingDates);
Sorry please try this one
let ScopeBegin = peek('IA_Scope_Period_Beg_Dt',-1,'ScopingDates');
let ScopeEnd = peek('IA_Scope_Period_End_Dt',-1,'ScopingDates');