Updating MyODBC Error

----------MailBlocks_8C83717FCAEB684_CE0_34DD_mblkn-m08.sysops.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.sysops.aol.com--