Re: Problem with psqlODBC 07.02.0001and VB 6 - Mailing list pgsql-odbc

Eng Kern Shen wrote:
>
> Hi,
>
> I've been using previous versions of the ODBC driver without any
> problem, but after intalling the version 07.02.0001, I discovered a
> serious problem with the following codes in VB6.  Locking tables with
> the codes below doesn't work.
>
>         cn.Execute "BEGIN"
>
>         cn.Execute "LOCK TABLE serialno IN ACCESS EXCLUSIVE MODE"
>
>           ......
>
>         cn.Execute "COMMIT"

Direct execution of "BEGIN", "COMMIT" or "ROLLBACK" isn't
a recommended way. Please call BeginTrans, CommitTrans or
RollbackTrans instead.

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/