MvEVAL previous db row (using xbase3)

[Southlander]

Hello all,

So lets say I have this <MvEVAL expr = "{thisdb.d.somefield}"> and it's currently on row 500 of the xbase3 table. But then I want to MvEVAL the same field using row 499 data?

That is I do NOT want to move the pointer, I just want to eval field values for rows that are different from where the pointer is. Is there a way? A way to do so directly without reading the DB rows all into another structure, etc.?

Thanks --

[Bruce - PhosphorMedia]

Its been awhile since I've worked with dbase, but what about <mvskip>? just set the rows="" count to -1 *(or whatever).

Also, if looking for the 'previous' record as you are looping through , you could always just save it to a variable before you move to the next record.

[Southlander]

Thanks Bruce,

Yeah can't use mvskip since that moves the pointer, and in fact there is a skip that comes in the loop right where I am doing this and I need that to be the only movement of the record pointer. The second idea you mentioned is more what I am doing -- working on it now. Thanks for the input.

[Scot - ScotsScripts.com]

You can't do that. You have to MvSKIP to the row you want to read. Another way would be to pre-load the data into an array and then simply read values from that however way y ou want.