Re: RES: BUG #4322: Problems with field not updatable

Can't say that I do. I think you need to get the ODBC folks to look at
it, the problem appears to be there rather than in the server product.

//Magnus

Alexandre Caneo wrote:
> 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
>