Hi Yuri,

I already have the aerror() information at that point. My coding is something like this:

on error do logerror

procedure logerror

=aerror(laError)
=sqlexec(gnHandle, "insert into logtable...")

The problem with this coding is that =sqlexec(gnHandle, "insert into logtable...") may generate error if the error which has trigger on error routine is caused by connection problem. So, I want to have a checking before I execute that statement:

on error do logerror

procedure logerror

=aerror(laError)
if no connection problem */ this is the part I cannot figure how to code this
=sqlexec(gnHandle, "insert into logtable...") */ sql server table
else
insert into logtable */ foxpro table
endif


Thank you for your help,

Peter