Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Determine relative record position
Message
 
À
23/10/1998 08:36:14
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00149770
Message ID:
00149813
Vues:
18
>>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...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform