Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Limit viewed records in curs without losing original cur
Message
De
22/10/2001 09:40:56
 
 
À
22/10/2001 00:12:06
Peter Brama
West Pointe Enterprises
Detroit, Michigan, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00571259
Message ID:
00571608
Vues:
31
In such case I think you can be better served by saving a unique key value to the array instead of the recno(). It could be the primary key or a composite key value, and you can create an index on a read-only cursor if need be.

>I am creating the cursor in a method on the form so technically it isn't in the DE I don't think. The recno() issue involves a link to an array for a couple fields that need changing by the user. Being how I am using VFP6 and had problems with creating READ/WRITE cursors (even with help from here)... the array option works well. The link is the RECNO() from the cursor/grid. If I REFRESH my cursor, the RECNO()s of the cursor can change (found that out the hardway) so that is why I hope that filtering the cursor won't mess with those recno()... otherwise I have a problem with the link to additional data.
>
>
>>>I have a cursor I use through out an app. At times, I would like to narrow the rows displayed (in my grid) to records in the cursor that meet a specific qualification and ideally, I don't want to lose the original rows in the cursor (due to some recno() references etc)... just not see them. Is there a way to do that without reselecting the cursor?
>>
>>If you have the cursor in the data environment of the form, you can filter the cursor using the Filter property:
>>
Thisform.DataEnvironment.myAlias.Filter = "myFilterExpression"
>>Although I'm not sure what you mean about the recno() references.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform