Hi,

To anyone that may be of service, I am in a bit of a bind. I have a table/view with a sort upon it and I am designing a way in which to copy a field value from my current record to the records below it.

I thought this would be a simple task, by using the following code:

REPLACE REST &lcField WITH lcCopyValue IN &lcAlias

Unfortunately, this only work well when there is no alternative order set to the table/view.

I was thinking of trying the above idea by selecting the remaining values to a cursor or array, but I'm not having luck with my syntax.

For Example:

SELECT REST FROM &lcAlias INTO ARRAY myArray

Doesn't do it. Is there another foxpro function I can use to get the "Rest" of my records regardless of the order set to the table?

If I can use:
SELECT &lcAlias
COUNT REST TO lnCounterMax

Why can't I SELECT REST ?

Anyone have any suggestions, I could use some direction here.

Thanks,

Steve

"Free Thinkers Are Dangerous."