Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql no working
Message
 
 
À
04/08/2001 03:10:17
Daniel C.
InfoData Bacau
Bacau, Roumanie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00539262
Message ID:
00539779
Vues:
11
>First is
>Sele f1,sum(f3) from cstView into array thisform.aSumf1 group by 1
>sorry for the mistake and second this sql should return some sums but returns .f..
>
>Thanks.

Daniel,
Try to use a local array instead of form property
Local Array laSumf1[1]
laSumf1[1] = 0     && In case if cstView has no records
SELECT f1, Sum(f3) ;
  From cstView ;
  Group By 1 ;
  Into Array laSumf1 

* The number of records retrieved by select 
*  is stored in system variable _TALLY. 
* If it's zero than your view doesn't have any records, it's empty
Thisform.aSumf1 = laSumf1
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform