Subject Re: NULL STMT handle
From Adrian Wykrota <adrian@wykrota.pl>
Date Thu, 28 Feb 2019 15:21:35 +0100
Newsgroups sqlexpress

OK. Working.

Użytkownik "Boris Borzic"  napisał w wiadomości grup
dyskusyjnych:XnsAA0124718441ESQLExpress@52.178.151.74...

"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 10:40 am
.-# Re: NULL STMT handle Boris Borzic <bb> 25-Feb-2019 03:34 am
..\# Re: NULL STMT handle (Current message) Adrian Wykrota 28-Feb-2019 09:21 am