In that code, remove Primary Key. You can do instead
index on Type tag Type.

I think if you fix this error, the other error will go away by itself.

>2 error message
>1.Feature is not supported for non-.DBC tables
>i use free table
>2.GROUP BY clause is invalid
>
>>

>>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 (...)