I'm not sure if this will help, but here goes; rather than use On Error to
trap a condition where there are no mathcing records you can use to see how
many matching records there are, and if there are none, the handle the
error yourself. For example:
Select * from YOUR_TABLE where YOUR _FIELD Like YOUR_CRITERIA into Selection
i_check = SelectionInfo(SEL_INFO_NROWS)
if i_check > 0 Then
' it morked, do something
Else
' It didn't work, alert the user
Note "No matching Records"
End If
At 03:35 AM 1/18/2000 PST, you wrote:
>HI
>
>I am getting really lost in trying to use the OnError Command. I don't know
>much programmning, so this could be the reason why. What I am aiming to do
>is when I have selected a point, but discover that there is no records
>within the table, I want to give out a message saying that there is no
>records, and then come out of the loop, and start from the beginning of that
>particular sub. At the moment, I keep having to start from the beginnning of
>the program...and there are too many markers if I had to do that all the
>time.
>
>So please advise me,
>
>THanks in advance
>
>Yvonne,
>
>email: [EMAIL PROTECTED]
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com
>
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
>
Richard W. Greenwood, PLS
Greenwood Mapping, Inc.
[EMAIL PROTECTED]
(307) 733-0203 fax: 733-4018
http://www.GreenwoodMap.com
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
