Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
USE myview NODATA... and VFP ask for parameters???
Message
From
06/01/2000 08:35:43
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00313345
Message ID:
00313835
Views:
47
>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
>

I'm not sure wshat is causing the problem- I've never run into it because I have never tried to create a view with a GROUP BY clause. If your view does not need to be updatable, why not just use a plain ol' SQL query?
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform