Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exact
Message
 
 
To
02/02/2011 14:24:13
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Exact
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01498386
Message ID:
01498389
Views:
48
This message has been marked as a message which has helped to the initial question of the thread.
create cursor csrTypes (Type char(10) primary key)

for lnI = 1 to 18
  insert into csrTypes (Type) values (padl(lnI,10))
next

select depno,empnam,empno, typ1,custno,;
 count(custno) As total_cfil,SUM(VAL(last)) As ntotal_cfil,SUM(VAL(now)) As ttotal_cfil,SUM(VAL(balance)) As rtotal_cfil ;
  from injaz1 In ;
 inner join csrTypes Ty on  In.Typ1 = Ty.Type
  group By 1, 2,3,4,5 ;
  INTO table mucurtw
From the top of my head - not tested.

>thank you fro reply,
>??this is the code i need your help to create a cursor with every type as a record and JOIN with that cursor
>
>
>Select depno,empnam,empno, typ1,custno,;
>    count(custno) As total_cfil,SUM(VAL(last)) As ntotal_cfil,SUM(VAL(now)) As ttotal_cfil,SUM(VAL(balance)) As rtotal_cfil ;
>  from injaz1 ;
>  WHERE typ1 In ('          2','          3','          4','          18') ;
>  group By 1, 2,3,4,5 ;
>  INTO table mucurtw
>
>
>>>hi all,
>>>
>>>i need to select as ==2 , == 3 ...4, and ==18...etc
>>>
>>>from injaz1 ;
>>>  WHERE typ1 In ('          2','          3','          4','          18') ;&& i get many typ1 as 20 ,49...etc
>>>
>>>thanks
>>
>>I suggest to create a cursor with every type as a record and JOIN with that cursor. It should be better than Type IN (...)
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform