Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

procmail modify subject, procmail alter subject, formail get body of message, www.xxxcon, www xxxcon, board.issociate.de, registrieren fehler dll server 0x8002801c, far2 vs near2 raid10, access abfragen aus linux, "Can't send mail: sendmail process failed with error code 69"

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