Updating MyODBC Error

----------MailBlocks_8C83717FCAEB684_CE0_34DD_mblkn-m08.syso ps.aol.com
Content-Type: text/plain; charset="us-ascii"

Hello,

I have noticed that if I change INNER JOIN by LEFT JOIN I get a cursor that I can
Update.

So,
select articulos.*,tPrv.Nom PrvNom from articulos
INNER JOIN artdivision ad on articulos.cod=ad.cod and ad.division='001'
left join proveedores tPrv on articulos.prv=tPrv.cod
where articulos.cod>'Z0000008' order by articulos.cod asc limit 1

Whith this sql, I get a cursor that I cannot update (I get an error)

But with this sql, I get a cursor that I can update.

select articulos.*,tPrv.Nom PrvNom from articulos
LEFT JOIN artdivision ad on articulos.cod=ad.cod and ad.division='001'
left join proveedores tPrv on articulos.prv=tPrv.cod
where articulos.cod>'Z0000008' order by articulos.cod asc limit 1

The difference is LEFT JOIN ARTDIVISION

Configuration of the cursor
---------------------------
MiSet.CursorLocation = adUseClient
MiSet.CursorType = adOpenStatic
MiSet.LockType = adLockOptimistic
MiSet.Properties("Update Criteria") = adCriteriaKey
MiSet.Properties("Update Resync") = adResyncNone
MiSet.Properties("Unique Table").Value = "articulos"

I hope this can help you.

Thanks,
Rafa
___________________________________________________
Try the New Netscape Mail Today!
Virtually Spam-Free | More Storage | Import Your Contact List
http://mail.netscape.com

----------MailBlocks_8C83717FCAEB684_CE0_34DD_mblkn-m08.syso ps.aol.com--