Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have an issue with a PEEK() function: I know how it works - I have to enclose the fieldname in quotes, then comes a counter and then the tablename
=> So when I have a table named >>Temp2<< and I want the field >>ID<< from the first record, I go like
>> PEEK('ID', 0, Temp2) <<
I can also do that in a loop, I only have to use $(i) instead of that 0 (if i is my counter)
<=> That is the issue: That does not work and I cannot spot any typo or similar - in fact, I have just put an EXIT behind the creation of Temp2 and then copied the PEEK() function out of my loop and just replaced the $(i) with a hard-coded 0 - so the syntax must be exactly the same - but inside the loop, the PEEK() function does not return a value.
Can it be that there may not be a table inbetween?
The thing is, inbetween Temp2 and my loop, I create a small dummy_table which I can append to inside the loop - but that is just one record with all the fields from the original table, but every field empty. Can that be the reason for the issue?
Thanks a lot!
Best regards,
DataNibbler
Try adding single quotes around the table name as well: PEEK('ID', 0, 'Temp2')
Try adding single quotes around the table name as well: PEEK('ID', 0, 'Temp2')
Yep! That works.
I was very sure - but I know sometimes you just have to try out different solutions.
Thank you!