Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot, bind-address mysql multiple, sanibleone xxxx, ftp://192.168.100.100/, www.xxxcon

Links

XODOX
Impressum

#1: Updating MyODBC Error

Posted on 2006-04-25 15:47:03 by rafarife

----------MailBlocks_8C83685DE59A8E8_2D88_8E95_mblkn-m02.sys ops.aol.com
Content-Type: multipart/alternative;
boundary="--------MailBlocks_8C83685DE59A8E8_2D88_8E96_mblkn -m02.sysops.aol.com"



----------MailBlocks_8C83685DE59A8E8_2D88_8E96_mblkn-m02.sys ops.aol.com
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello,
I have a problem when I try to update a record in a client-cursor.
=20
I am using Visual Basic 6.0, MyOdbc 3.51.12, Windows 2000 and ADO 2.8, and I=
=20
have found the problem both in Mysql 4.0 and Mysql 4.1 (latest versions) wit=
h
InnoDB.

Here is the code:
........................
Dim Conexion as ADODB.Connection
Dim Opciones As Long
Set Conexion =3D New ADODB.Connection
Opciones =3D 1 + 2 + 8 + 16384
=20
'Open the connection
Conexion.ConnectionString =3D "DRIVER=3D{MySQL ODBC 3.51 Driver};" _
& "SERVER=3Dlocalhost;" _
& "UID=3Duser;PWD=3Dpassword;OPTION=3D" & Str$(Opcione=
s)
Conexion.Open
=20
'open the cursor
Dim MiSet as ADODB.Recorset,MiSQL as string
Set MiSet =3D New ADODB.Recordset
=20
'SQL to get the cursor
MiSQL=3D"select articulos.*,tPrv.Nom PrvNom from articulos " & _
"inner join artdivision ad on articulos.cod=3Dad.cod and ad.division=3D'00=
1' " & _
"left join proveedores tPrv on articulos.prv=3DtPrv.cod " & _
"where articulos.cod>'Z0000008' order by articulos.cod asc limit 1"

'Configuring then cursor
MiSet.CursorLocation =3D adUseClient
MiSet.CursorType =3D adOpenStatic
MiSet.LockType =3D adLockOptimistic
MiSet.Properties("Update Criteria") =3D adCriteriaKey
MiSet.Properties("Update Resync") =3D adResyncNone
MiSet.Properties("Unique Table").Value =3D "articulos"
=20
'Open the cursor
MiSet.Open MiSQL, Conexion, , , adCmdText 'This opens the cursor. (Ok)
=20
'This does not run
MiSet!Nom=3D"New name"
MiSet.Update ->ERROR ...=20
=20
I get the following error:
?conexion.Errors(0).Description,conexion.Errors(0).NativeErr or,conexion.Err=
ors(0).Number
Informaci=F3n de columna clave insuficiente para realizar la operaci=F3n Up=
date o Refresh. =20
1007 -2147467259=20
'The information of the key column is not sufficient to do the update or re=
fresh'
=20
........................
If I get the cursor from this SQL:
SELECT ARTICULOS.*,TPRV.NOM PRVNOM FROM ARTICULOS=20
INNER JOIN ARTDIVISION AD ON ARTICULOS.COD=3DAD.COD AND AD.DIVISION=3D'001'=20
LEFT JOIN PROVEEDORES TPRV ON ARTICULOS.PRV=3DTPRV.COD=20
WHERE ARTICULOS.COD<'Z0000250' ORDER BY ARTICULOS.COD DESC LIMIT 1
=20
I cannot either update the cursor.=20

I think It is a problem of MyODBC.
I have sent the tables in the MyTables.Sql file.
Thanks in advance,
Rafa
=20
___________________________________________________
Try the New Netscape Mail Today!
Virtually Spam-Free | More Storage | Import Your Contact List
http://mail.netscape.com

----------MailBlocks_8C83685DE59A8E8_2D88_8E96_mblkn-m02.sys ops.aol.com
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<HTML><BODY><DIV style=3D'font-family: "Verdana"; font-size: 10pt;'><DIV>Hel=
lo,</DIV>
<DIV>I have a problem when I try to update a record in a client-cursor.</DIV=
>
<DIV>&nbsp;</DIV>
<DIV>I am using Visual Basic 6.0, MyOdbc 3.51.12, Windows 2000 and ADO 2.8,=20=
and I <BR>have found the problem both in Mysql 4.0 and Mysql 4.1 (latest ver=
sions) with<BR>InnoDB.</DIV>
<DIV><BR>Here is the code:<BR>.......................</DIV>
<DIV>Dim Conexion as ADODB.Connection<BR>Dim Opciones As Long</DIV>
<DIV>Set Conexion =3D New ADODB.Connection</DIV>
<DIV>Opciones =3D 1 + 2 + 8 + 16384</DIV>
<DIV>&nbsp;</DIV>
<DIV>'Open the connection<BR>Conexion.ConnectionString =3D "DRIVER=3D{MySQL=20=
ODBC 3.51 Driver};" _<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20=
&amp; "SERVER=3Dlocalhost;" _<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp; &amp; "UID=3Duser;PWD=3Dpassword;OPTION=3D" &amp; Str$(Opciones)</DI=
V>
<DIV>Conexion.Open</DIV>
<DIV>&nbsp;</DIV>
<DIV>'open the cursor<BR>Dim MiSet as ADODB.Recorset,MiSQL as string</DIV>
<DIV>Set MiSet =3D New ADODB.Recordset</DIV>
<DIV>&nbsp;</DIV>
<DIV>'SQL to get the cursor<BR>MiSQL=3D"select articulos.*,tPrv.Nom PrvNom f=
rom articulos " &amp; _<BR>&nbsp; "inner join artdivision ad on articulos.co=
d=3Dad.cod and ad.division=3D'001' " &amp; _<BR>&nbsp; "left join proveedore=
s tPrv on articulos.prv=3DtPrv.cod " &amp; _<BR>&nbsp; "where articulos.cod&=
gt;'Z0000008' order by articulos.cod asc limit 1"</DIV>
<DIV><BR>'Configuring then cursor<BR>MiSet.CursorLocation =3D adUseClient<BR=
>MiSet.CursorType =3D adOpenStatic<BR>MiSet.LockType =3D adLockOptimistic<BR=
>MiSet.Properties("Update Criteria") =3D adCriteriaKey<BR>MiSet.Properties("=
Update Resync") =3D adResyncNone<BR>MiSet.Properties("Unique Table").Value=20=
=3D "articulos"</DIV>
<DIV>&nbsp;</DIV>
<DIV>'Open the cursor<BR>MiSet.Open MiSQL, Conexion, , , adCmdText 'This ope=
ns the cursor. (Ok)</DIV>
<DIV>&nbsp;</DIV>
<DIV>'This does not run<BR>MiSet!Nom=3D"New name"<BR>MiSet.Update -&gt;ERROR=
... </DIV>
<DIV>&nbsp;</DIV>
<DIV>I get the following error:</DIV>
<DIV>&nbsp; ?conexion.Errors(0).Description,conexion.Errors(0).NativeErr or,co=
nexion.Errors(0).Number<BR>&nbsp;Informaci=F3n de columna clave insuficiente=
para realizar la operaci=F3n Update o Refresh.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR>&nbsp;1007&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp; -2147467259 </DIV>
<DIV>&nbsp;'The information of the key column is not sufficient to do the up=
date or refresh'<BR>&nbsp;<BR>.......................</DIV>
<DIV>If I get the cursor from this SQL:</DIV>
<DIV>SELECT ARTICULOS.*,TPRV.NOM PRVNOM FROM ARTICULOS <BR>INNER JOIN ARTDIV=
ISION AD ON ARTICULOS.COD=3DAD.COD AND AD.DIVISION=3D'001' <BR>LEFT JOIN PRO=
VEEDORES TPRV ON ARTICULOS.PRV=3DTPRV.COD <BR>WHERE ARTICULOS.COD&lt;'Z00002=
50' ORDER BY ARTICULOS.COD DESC LIMIT 1</DIV>
<DIV>&nbsp;</DIV>
<DIV>I cannot either update the cursor. </DIV>
<DIV><BR>&nbsp;I think It is a problem of MyODBC.</DIV>
<DIV>&nbsp;I have sent the tables in the MyTables.Sql file.</DIV>
<DIV>&nbsp;Thanks in advance,<BR>&nbsp;Rafa</DIV>
<DIV>&nbsp;</DIV></DIV>


<hr style=3D"MARGIN-TOP:10px" >
<b>Try the New Netscape Mail Today!</b>

Virtually Spam-Free | More Storage | Import Your Contact List
<a href=
=3D"http://mail.netscape.com">http://mail.netscape.com</a>

</BODY></HTML>

----------MailBlocks_8C83685DE59A8E8_2D88_8E96_mblkn-m02.sys ops.aol.com--


----------MailBlocks_8C83685DE59A8E8_2D88_8E95_mblkn-m02.sys ops.aol.com
Content-Type: text/plain; charset=us-ascii


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
----------MailBlocks_8C83685DE59A8E8_2D88_8E95_mblkn-m02.sys ops.aol.com--

Report this message