Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
In negative territory...
Message
From
25/06/2006 03:49:35
 
 
To
20/06/2006 14:15:16
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01130247
Message ID:
01131485
Views:
14
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform