RES: BUG #4322: Problems with field not updatable

Magnus,

I've tried open cursor with adOpenStatic or adOpenForwardOnly,  but it didn=
't work.

Do you have others suggestions?

Tks.
Alexandre.


-----Mensagem original-----
De: Magnus Hagander [mailto:magnus@hagander.net]=20
Enviada em: segunda-feira, 28 de julho de 2008 08:34
Para: Alexandre Caneo
Cc: pgsql-bugs@postgresql.org
Assunto: Re: [BUGS] BUG #4322: Problems with field not updatable

Alexandre Caneo wrote:
> The following bug has been logged online:
>=20
> Bug reference:      4322
> Logged by:          Alexandre Caneo
> Email address:      alexandre@adtinformatica.com.br
> PostgreSQL version: 8.2.6
> Operating system:   WIN XP
> Description:        Problems with field not updatable
> Details:=20
>=20
> I'm using Win XP SP2, VB6 and PostgreSql 8.2.6.
>=20
> When I select the datas with this instruction
> "select a.x from a,b where a.z =3D b.z order by 1"
> the program run very well and I can insert, update and delete rows. But,
> when I select any column from table b an error occurs when I try to modify
> the column value from textbox for an example.
> "Binding Collection Error. field not updatable".
>=20
> String connection
>     ls_StrConn =3D "PROVIDER=3DMSDASQL.1; DRIVER=3D{PostgreSQL UNICODE};
> DATABASE=3D" & ls_Conexao & "; SERVER=3D" & ls_Host & "; PORT=3D" & ls_Se=
rvico &
> "; UID=3D" & ls_login & "; PWD=3D" & ls_Senha & "; ByteaAsLongVarBinary=
=3D1;"
>=20
> Recordset's properties
>   mo_Record.CursorType =3D adOpenDynamic
>   mo_Record.LockType =3D adLockOptimistic=20=20
>=20=20=20=20=20
>   mo_Record.Open mo_Command
>=20
> One more thing.
> I don't need update the table's b column, just show them.

If you don't need updating, you should open your cursor as either
adOpenStatic or adOpenForwardOnly. Using adOpenDynamic explicitly
requests the ability to do updates/inserts/deletes through the cursor.

//Magnus

No virus found in this incoming message.
Checked by AVG.=20
Version: 7.5.441 / Virus Database: 270.5.6/1523 - Release Date: 25/7/2008 0=
0:00
=20

No virus found in this outgoing message.
Checked by AVG.=20
Version: 7.5.441 / Virus Database: 270.5.6/1523 - Release Date: 25/7/2008 0=
0:00
=20