Subject Re: NULL STMT handle
From Boris Borzic <bb>
Date Mon, 25 Feb 2019 09:34:45 +0100
Newsgroups sqlexpress

"Adrian Wykrota" <adrian@wykrota.pl> wrote in
news:czfqtqcmrm1laya.200220191640@daz17:

> I haveproc with get of table columns like this:
>
> LOCAL nThreadId := THREADID()
> IF saColumn[nThread] == NIL
>   soColumn := SQLListColumns(MyGetCon(nThreadId))
>   saColumn[nThread] := soColumn
> ELSE
>   soColumn := saColumn[nThread]
> ENDIF
>
> sometimesmy soColumn object has an error like subject (err no 65534)
> and of course soColumn:Handle is null
> I use Ms SQL Server - how to reconect to get valid odbc handle ?

You can use the :Reconnect method. Just keep in mind that after
reconnecting you will need to re-execute the failed SQL statement.

--
Best regards,
Boris Borzic

http://xb2.net
http://sqlexpress.net
industrial strength Xbase++ development tools

Recent messages in this thread
 
-# NULL STMT handle Adrian Wykrota 20-Feb-2019 03:40 pm
.-# Re: NULL STMT handle (Current message) Boris Borzic <bb> 25-Feb-2019 08:34 am
..\# Re: NULL STMT handle Adrian Wykrota 28-Feb-2019 02:21 pm