Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
USE myview NODATA... and VFP ask for parameters???
Message
De
06/01/2000 08:35:43
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00313345
Message ID:
00313835
Vues:
45
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform