Skip site navigation (1) Skip section navigation (2)

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

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Alexandre Caneo <alexandre(at)adtinformatica(dot)com(dot)br>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: RES: BUG #4322: Problems with field not updatable
Date: 2008-07-29 13:41:11
Message-ID: 488F1DF7.2090608@hagander.net (view raw or flat)
Thread:
Lists: pgsql-bugs
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
>  


In response to

pgsql-bugs by date

Next:From: Maxime CarbonneauDate: 2008-07-29 20:15:16
Subject: BUG #4332: ERROR: invalid byte sequence for encoding "UTF8": 0xc3
Previous:From: valgogDate: 2008-07-29 10:26:00
Subject: Re: BUG #4328: help in creating database encoded with LATIN1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group