Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
In negative territory...
Message
 
 
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:
01130332
Views:
17
Lucien,

I think the problem is with
locate for recno()=lnrec
I never used such syntax before. I think you can save PK instead and locate for it.


>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
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform