PEEK FUNCTION

[edg_baltazar]

Hi ! , i have some trouble using Peek Function ... it's possible to use a variable or field instead of a constant in de row parameter?... Something like this:

Peek(Date,RowNO()+1) ...or  Peek(Date,Index)    i need to get the next record of date in the script , but it doesn't work ... any idea? , Thanks in advance!

[rwunderlich · Accepted solution]

Yes, you can use expressions, variables and fields in the row parameter.

The most frequent error with peek is not putting quotes around the field or table names. ie

Peek('Date', RowNo()+1)

-Rob

[edg_baltazar]

If i use Peek('Date', RowNo()+1) it doesn't work , but with Peek('Date', RowNo()+1,'Table_Name') it works! , thank you!