Dear friends,

I will try to answer to all...

My code for the view is:

select az.codArm, az.descricao, aaz.lote, Sum(aaz.quant) ;
from tabAtAz aaz inner join tabAz az ;
On az.stamp = aaz.st_tabAz Where aaz.st_tabAt = ?st_Artigo ;
GROUP BY az.codArm, az.descricao, aaz.lote ORDER BY az.CodArm, aaz.lote

----------------

Hi Barbara,

The problem is that i'm using GROUP BY and SUM funtions, because with other "simple" views i don't have this trouble.

Hi Erik,

Yes! You're rigth! I don't need to make this view updatable, but i get the problem right after creating the view!

Hi Victor,

No, i'm just using tables from server. My view doesn't contain other views.

----------------
Possible solution: as this view will be used on a Grid (just to show information) and can create a cursor, and do a SQLEXEC with the SQL code. But, i really wanna know how to make it with a remote view.
----------------

Well, any ideas are appreciated.


Thanks to all,

Ricardo