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
