Peek function returning null after SQL statement.

Tue, 15 Mar 2011 13:06:43 GMT

When I run the following code the peek command seems to stop working after the SQL select command.

For the second row vTable,vField & vDescr are set to Null when for k = 0 to $(y) is on it's second pass.

Any ideas why this is happening?

Mark


tmp:
load * inline [
TABLE, FIELD,DESCR
'ITMMASTER','ITMREF_0','Product'
'BPCUSTOMER','BPCNUM_0','Customer'
];

Counts:
LOAD Count(FIELD ) as Y
Resident tmp;
LET y = Peek('Y', 0) - 1;
DROP Table Counts;

for k = 0 to $(y)

 LET vTable = PEEK('TABLE', $(k));
 LET vTable = 'IDIS.' & vTable ;
 LET vField = PEEK('FIELD', $(k));
 LET vDescr = PEEK('DESCR', $(k));

 LOOKUPS:
 SQL SELECT $(vField) AS LOOKUP_FIELD, '$(vTable)' AS LOOKUP_TABLE from $(vTable);

NEXT k

Peek function returning null after SQL statement.

Tue, 15 Mar 2011 13:21:49 GMT

I needed to explicitly set the table in peek, this has made it work.

LET vField = PEEK('FIELD', $(k),'TMP');

Peek function returning null after SQL statement.

Fri, 08 Apr 2011 10:32:24 GMT

Had the exact same issue, thanks for adding your solution.

topic Peek function returning null after SQL statement. in QlikView

Peek function returning null after SQL statement.

Peek function returning null after SQL statement.

Peek function returning null after SQL statement.