Simple question...

[hudhwk]

Hi guys,

I have a very simple question, but of it's simplicty becomes a weird one.

How do you capture an EOF() with a GO command?

I mean, I HAVE to do a GO but I want to avoid the EOF() adn be able to inform the user that the record doesn't exist.

Any idea?

Thanks a lot in advance!

Sincerely,
Daniel Buentello
"Here comes the hawk!

 

[agoeddeke]

Hudhwk,

Is this what you're looking for?

SELECT MyTable
IF BETWEEN(lnMyRec, 1, RECCOUNT())
   GO lnMyRec
ELSE
   MESSAGEBOX("Not in Range")
ENDIF

Andy

 

[hudhwk]

Yes!!!

Thanks a lot, never heard of BETWEEN command, but it works just perfect.

Thanks a lot again.

See ya.

Daniel.