record out of range 1

[R17]

i have this,

use leave
append blank
store recno() to nrec
.
.
.
go nrec

but why am i having a record out of range in "go nrec"?

 

[baltman]

You're trying to go to a record outside the table's scope... such as 'GO 10' in an 8 record table.

If you are trying to locate a specific record you may want to consider a primary key (unique identifier), or you could change your command to 'GO MAX(NREC,RECCOUNT())' or 'LOCATE FOR RECNO()>=NREC' etc. depending upon what you are trying to achieve.

Brian

 

[bon011]

I get this error sometimes.

It happens to me when I chenge work area(select table or cursor)

try to use this:

use leave
append blank
store recno() to nrec
.
.
.
use leave
go nrec

 

[R17]

hi baltman,

when i append blank, shouldn't the recno() be equal to the last record?

 

[bon011]

Of course when You add a new record than recno() retun the last record number.

 

[Mike Gagnon]

Bon011

Of course when You add a new record than recno() retun the last record number.

In my experience, when a table is buffered the Recno() of a new record return -1.

LOCAL nRec
SET MULTILOCKS on
CREATE TABLE c:\myTable (name c(20))
=CURSORSETPROP("Buffering",5,"myTable")
GO botto
APPEND BLANK
STORE RECNO() TO nRec
MESSAGEBOX(TRANSFORM(nRec))

In the case of an unbuffered table it returns the actual RECNO().

LOCAL nRec
CREATE TABLE c:\myTable (name c(20))
GO botto
APPEND BLANK
STORE RECNO() TO nRec
MESSAGEBOX(TRANSFORM(nRec))

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Lewis]

R17,

Sorry if this is obvious, but are you sure you still have Leave selected at the time you do the Go nrec?

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[craigsboyd]

I would guess that it is a record buffering problem as Mike Gagnon has outlined.

LOCAL nRec
SET MULTILOCKS ON
CREATE TABLE c:\myTable (name c(20))
=CURSORSETPROP("Buffering",5,"myTable")
GO BOTTOM
APPEND BLANK
STORE RECNO() TO nRec
MESSAGEBOX(TRANSFORM(nRec))
GO nRec &&Works Fine
=TABLEUPDATE() &&Now the record number -1 is gone
GO nRec &&Throws an error

Slighthaze = NULL
_{craig1442@mchsi.com}

"Whom computers would destroy, they must first drive mad." - Anon​

 

[R17]

yes mike, i have the table selected before i do nrec. mgagnon is right, nrec returns to -1.