Re: Log: TextAsLongVarchar=0 don't work - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: Log: TextAsLongVarchar=0 don't work
Date
Msg-id 20060111165222.GB31142@soptik.pzkagis.cz
Whole thread Raw
List pgsql-odbc
> Just to thank you for the great solution you give me.
> I finally could solve the problem regarding TextAsLongVarchar!

Not at all. I thank you for cooperation.

> If I execute a select statement using bind variables (the way used by
> Centura Team Developer to read data from db) I get an implicit rollback...
>
> If I write:
> UPDATE A SET C=C+1
> SELECT C FROM A into :c
> COMMIT
>
> The value of C is not incremented because there is a implicit rollback
> caused by the select.
> If I don't specified the "into :c" clause every thing works properly, but I
> can't read the value ;-)

The output binding parameters isn't supported by psqlodbc yet.
Another question do you use autocommit on? I create patch for autocommit
off and implicit rollback (maybe after 08.01.0106 dev snapshot - I
don't know - I can take a look on it at home).

Please be patient I'm planning release new development snapshot at the
end of week so you maybe find the fix there.

Please, please, please don't write directly only to me. Post it to
pgsql-odbc@postgresql.org mailing list (feel free to cc: to me).

Regards,

Luf

pgsql-odbc by date:

Previous
From: "A.J. Langereis"
Date:
Subject: Fw: Values in the select
Next
From: Adam Biser
Date:
Subject: Re: Parameters.Refresh error.