>>>I'm selecting two records in a table so I can copy or delete all the records between each of the selected record. My problem comes when the table is indexed. Is there a way to do this? I'm having a problem determining if the second record is before or after the first record. I'm using 5.0a. TIA
>>
lcKey = key()
>>* On one of recs
>>luValue1 = eval(lcKey)
>>go nOtherRec
>>luValue2 = eval(lcKey)
>>select * from mytabel ;
>> where &lcKey between ;
>> min(luValue1,luValue2) ;
>> and max(luValue1,luValue2)
Cetin
>
>Worked like a charm Cetin. I also needed to update a field using the condition so I replaced the SELECT statement with a REPLACE statement and it does just what I needed. Thanks again...
Glad to be helpfull :) As a reminder, while "select" part could be replaced by endless :) solutions of FP, select also supports a "set field1 = newvalue..." as an alternative to "replace".
Cetin