Error handling

[Mirko]

 Posted by:  Mirko BONANNO 

Hi all,

in my web application when I get a SqlError sometimes I get the blanck page
"Application Error" and there is no way to handle this (I can see the
offending SqlStatement in the logs) whatever I return from On SqlError !

Why ?

Mirko

[czavala]

 Posted by:  Conrado ZAVALA 

Hello Mirko,

I'm not sure if you already tried this but what I have done is something
like this:

On SAM_Click
! CAPTURE SQL ERROR:
When SqlError
Call SqlExtract( ... )
...
Call WebMessageBox( ... )
Return FALSE

! PREPARE and execute SQL Statement:
If SqlPrepareAndExecute( hSql, "SELECT NAME INTO :sName FROM..." )
Call SqlFetchNext( hSql, nSqlFetch )
! RELEASE connection:
Call SqlCommit( hSql )
VALIDATE nSqlFetch:
If nSqlFetch = FETCH_Ok
Return TRUE
Return FALSE

Conrado

[Mirko]

 Posted by:  Mirko BONANNO 

I'd like to get rid of this message at the client side:

Application Error

in a white page

TIA
Mirko