Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Views and recno()
Message
 
 
À
05/08/2002 14:58:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00686281
Message ID:
00686283
Vues:
34
>Hi!

>Something kind of weird Have been happening to me using Views.
Here is the scenario: I began playing with a view, every time
I got new records for display I wanted the pointer remained in
the same record after adding the new ones, So I used a little
routine applying recno() and it worked well. Then I decided to
apply the same code in a more complex view (conformed by a cursor
and another view), but unfortunately the code didn't work, now
it turns out that the record number changes dynamically as I Add
new records to the view, that is to say, that the record that once
was number 1 now could be 3 and so on, with this problem is im-
possible to remain in a determined record after updating a view,
I even could go to an unexisting record in case the number of
records of the view get reduced.

>What am I doing wrong?

>Could be that the complexity of the view makes the record number
changes dynamically?

>Could this problem be related with the keyfield property of the
view?

I think you should seek an Primary Key not the recno().
Apoya a Visual FoxPro usandolo legalmente
--
¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º
Espartaco Palma Martínez
SysOp PortalFox
http://www.portalfox.com
esparta@portalfox.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform