Dear Sir,
I am using the following code to update a Row Position (POSR) in a Cursor
Select Distinct POSR From PAGETWO Order By POSR Desc Into Cursor DISTINCTPOSR
nCD=12
Scan
nPagetwoDistinctposR=POSR
Select PAGETWO
nCOMMONDIFFERENCE=m.T-nCD
Replace All POSR With nCOMMONDIFFERENCE For POSR=nPagetwoDistinctposR
Select DISTINCTPOSR
nCD=nCD+12
ENDSCAN
Using the above code at first instance my POSR is changed by Desired value say from 696 to 453.
However, In the scan loop if the value of nPagetwoDistinctposR again comes to 453 by chance, it again updates my cursor to new value.
For the above I have a solution to insert another Like Yes/NO etc but I am seeking for some simple solution and Better Code or a SQL that may work faster For the above.
Pls Guide
Regards
Harsh