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:[EMAIL PROTECTED] > 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: >> >> Bug reference: 4322 >> Logged by: Alexandre Caneo >> Email address: [EMAIL PROTECTED] >> 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 > -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
