Ricardo,
I used 'count' instead of 'sum' but had Count and Group By clauses and the remote view worked fine with the NODATA clause.
Barbara
>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