Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
In negative territory...
Message
De
25/06/2006 03:49:35
 
 
À
20/06/2006 14:15:16
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01130247
Message ID:
01131485
Vues:
16
>Naomi:
>
>Status bar reports correct table/view and actual record pointer position.
>Come to think of it, I don't recall seeing a negative number in the status bar. Anyway...
>Cursorgetprop("buffering")=5
>
>Here's the code.
>
>local lnrec
>
>store 0 to lnrec
>select v_view
>if reccount()>0
> if !eof() .and. !deleted()
> lnrec=recno()
> else
> go bottom
> lnrec=recno()
> endif
> go top
> scan while !eof() .and. !deleted()
> replace ...
> endscan
> locate for recno()=lnrec
> if !found()
> go top
> endif
>endif
>
>return
>
>I suspect it's the 'locate for' but 'go' doesn't return the user to the same line/record they were on.
>
>Thanks for your help,
>Luke

order() is empty ?

use
locate RECORD m.lnrec
it work with negative ( buffered ) records and absolute ( phisical ) record.
Example:
* if RECCOUNT()=33 and buffering = 5-tablebuffer
APPEND BLANK
GO TOP
LOCATE RECORD 34 && locate the -1 record
LOCATE RECORD -1 && locate the -1 record
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform