Subject Re: [IBO] SQL ERROR CODE:-836
Author Johannes Pretorius
hI there
=-0-==0-0-=

I found this post from rastafareysoft

that states this fix

if ( SQLCODE = -836 ) and ( error_messages.Count > 2 ) then
tmpText := error_messages[ 5 ] //the original index is 4
else
tmpText := error_messages.Text;

I will try and see

Thansk

Johannes



At 09:05 AM 05/07/2006, you wrote:

>Good day all
>-=0=-0-=0=-0
>
>We have a weird error at a site. We have the same version of the program at other sites with no problems. But only this one site
>is giving this error.
>
>We tried with the Monitor to see what causes it, BUT no such luck. The error does not happen then. Thus intermitted.
>
>The thing that confuses us, is the error message. We do not know where to start with this.
>
>Here is the message
>
>//------------------------------------------------
>SQL ERROR CODE:-836
>
>SQL ERROR MESSAGE:
>exception 0
>//------------------------------------------------
>
>Any help will be appreciated.
>
>I hope it helps
>
>
>Johannes Pretorius
>
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>Yahoo! Groups Links
>
>
>
>