Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following problem:
for P=0 to NoOfRows('Pol1')-1
LET vPOLICY_ID = chr(39)&Peek('POLICY_ID',$(P),Pol1)&chr(39);
Pol2:
Load "POLICY_ID" as POLICY_ID2,
SQL select POLICY_ID, ANNEX_ID, COVER_TYPE, INSR_TYPE
FROM "INSIS_OMN"."GEN_RISK_COVERED"
where POLICY_ID=$(vPOLICY_ID);
NEXT P
---------------------------------------------------
The problem is that at the first P=0, my peek function is working and my vPOLICY_ID variable gets the content of Peek('POLICY_ID',$(P),Pol1)
But after NEXT P statement, P takes the value 1, and my variable vPOLICY_ID becomes NULL. This happens for each P different with 0.
Note that my "Pol1" table has a lot of data inside.
I have tried not to use P for peek, and to give 0,1,2... instead of $(P) and my peek function works fine...
Can someone detects where is the problem?
Thank you,
Silviu
I have solved the problem.
The table name in function PEEK must be without ''.
Thank you,
Silviu.
Silviu,
code like you posted above worked just fine at my side (with my, different table data of course):
for P=0 to NoOfRows('Pol1')-1
LET vPOLICY_ID = chr(39)&Peek('POLICY_ID',$(P),'Pol1')&chr(39);
NEXT P
Note that I enclosed the table name in single quotes (third parameter to the peek function), not sure if that is causing the problem, but could do.
Regards,
Stefan
I have solved the problem.
The table name in function PEEK must be without ''.
Thank you,
Silviu.