| From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | Eng Kern Shen <kernshen(at)pacific(dot)net(dot)sg> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Problem with psqlODBC 07.02.0001and VB 6 |
| Date: | 2002-08-09 00:00:25 |
| Message-ID: | 3D530619.E8325ED1@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 2002-08-09 00:19:34 | Re: Select * causes a crash, or How I learned to Hate VB |
| Previous Message | Corey Gibbs | 2002-08-08 15:56:09 | Re: Select * causes a crash, or How I learned to Hate VB |