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 13:22:56
 
 
À
06/01/2000 12:43:53
Rex Mahel
Realm Software, Llc
Ohio, États-Unis
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:
00314021
Vues:
50
You can use a cursor created by SQL as the recordsource for a grid- I do it all the time.

>Erik,
>
>How about you want to use the view as a RecordSource for a Grid?
>
>Just a thought
>
>Rex
>
>>>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