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(at)hagander(dot)net]
Enviada em: segunda-feira, 28 de julho de 2008 08:34
Para: Alexandre Caneo
Cc: pgsql-bugs(at)postgresql(dot)org
Assunto: Re: [BUGS] BUG #4322: Problems with field not updatable

Alexandre Caneo wrote:
> The following bug has been logged online:
>
> Bug reference: 4322
> Logged by: Alexandre Caneo
> Email address: alexandre(at)adtinformatica(dot)com(dot)br
> PostgreSQL version: 8.2.6
> Operating system: WIN XP
> Description: Problems with field not updatable
> Details:
>
> I'm using Win XP SP2, VB6 and PostgreSql 8.2.6.
>
> When I select the datas with this instruction
> "select a.x from a,b where a.z = 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".
>
> String connection
> ls_StrConn = "PROVIDER=MSDASQL.1; DRIVER={PostgreSQL UNICODE};
> DATABASE=" & ls_Conexao & "; SERVER=" & ls_Host & "; PORT=" & ls_Servico &
> "; UID=" & ls_login & "; PWD=" & ls_Senha & "; ByteaAsLongVarBinary=1;"
>
> Recordset's properties
> mo_Record.CursorType = adOpenDynamic
> mo_Record.LockType = adLockOptimistic
>
> mo_Record.Open mo_Command
>
> 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.
Version: 7.5.441 / Virus Database: 270.5.6/1523 - Release Date: 25/7/2008 00:00

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