Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I got a table sorted as follows:
Item_id asc, Sale_Date desc
if i preview the table in the table viewer I get first the item id 26 repeated several times depending on the number of transactions
However now I'm applying a loop as follows:
let vRecords = NoOfrows('myTable');
for i=1 to $(vRecords)
let x = FieldValue('Item_id',$(i))
next
if I debug the script I get the first item to be 3294 which is not 26 as I'm seeing it in the previewer
what could be the problem?
please Advise
FieldValue will access the internally stored compressed Field with index given by unique value in load order.
That could explain the difference.
Try using peek() function instead:
for i=0 to $(vRecords)-1
let x = Peek('item_id',$(i),'myTable')
next
Hope this helps,
Stefan
FieldValue will access the internally stored compressed Field with index given by unique value in load order.
That could explain the difference.
Try using peek() function instead:
for i=0 to $(vRecords)-1
let x = Peek('item_id',$(i),'myTable')
next
Hope this helps,
Stefan