Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql no working
Message
 
 
To
04/08/2001 03:10:17
Daniel C.
InfoData Bacau
Bacau, Romania
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00539262
Message ID:
00539779
Views:
10
>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--
Previous
Reply
Map
View

Click here to load this message in the networking platform