Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sql problem
- Thread starter DannC
- Start date
rajeevnandanmishra
Programmer
Hi Nefra,
The into array expects an array name and not any varibale name.
Instead Use this command,
sele f1, sum(f3) from view21 into array aSum group by 1
And then assign these values to your thisform variables like,
thisform.aSum1=asum(1,1)
thisform.aSum2=asum(1,2)
The into array expects an array name and not any varibale name.
Instead Use this command,
sele f1, sum(f3) from view21 into array aSum group by 1
And then assign these values to your thisform variables like,
thisform.aSum1=asum(1,1)
thisform.aSum2=asum(1,2)
Hi Nefra,
Make sure your view is not a filtered view. Otherwise, the select will choose from the View and not the full table. Alternative is to use the Table directly instead of the view in the select from view21. I think your answer lies in this, that the view is carrying only one f1 value.
Hope this helps ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK
Make sure your view is not a filtered view. Otherwise, the select will choose from the View and not the full table. Alternative is to use the Table directly instead of the view in the select from view21. I think your answer lies in this, that the view is carrying only one f1 value.
Hope this helps ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK
- Thread starter
- #4
- Status
