OK, here's the sql-statement:

Select ;
pza_cjaar, pza_ckwartaal, ;
Sum(pza_n001) As pza_n001, Sum(pza_n002) As pza_n002, Sum(pza_n003) As pza_n003, Sum(pza_n004) As pza_n004, ;
Sum(pza_n005) As pza_n005, Sum(pza_n006) As pza_n006, Sum(pza_n007) As pza_n007, Sum(pza_n008) As pza_n008, ;
Sum(pza_n009) As pza_n009, Sum(pza_n010) As pza_n010, Sum(pza_n011) As pza_n011, Sum(pza_n012) As pza_n012, ;
Sum(pza_n013) As pza_n013, Sum(pza_n014) As pza_n014, Sum(pza_n015) As pza_n015, Sum(pza_n016) As pza_n016, ;
Sum(pza_n017) As pza_n017, Sum(pza_n018) As pza_n018, Sum(pza_n019) As pza_n019, Sum(pza_n020) As pza_n020, ;
Sum(pza_n021) As pza_n021, Sum(pza_n022) As pza_n022, Sum(pza_n023) As pza_n023, Sum(pza_n024) As pza_n024, ;
Sum(pza_n025) As pza_n025, Sum(pza_n026) As pza_n026, Sum(pza_n027) As pza_n027, Sum(pza_n028) As pza_n028, ;
Sum(pza_n029) As pza_n029, Sum(pza_n030) As pza_n030, Sum(pza_n031) As pza_n031, Sum(pza_n032) As pza_n032, ;
Sum(pza_n033) As pza_n033, Sum(pza_n034) As pza_n034, Sum(pza_n035) As pza_n035, sum(pza_n036) As pza_n036, ;
Sum(pza_n037) As pza_n037, Sum(pza_n038) As pza_n038, Sum(pza_n039) As pza_n039, Sum(pza_n040) As pza_n040, ;
Sum(pza_n041) As pza_n041, Sum(pza_n042) As pza_n042, Sum(pza_n043) As pza_n043, Sum(pza_n044) As pza_n044, ;
Sum(pza_n045) As pza_n045, Sum(pza_n046) As pza_n046, Sum(pza_n047) As pza_n047, Sum(pza_n048) As pza_n048, ;
Sum(pza_n049) As pza_n049, Sum(pza_n050) As pza_n050, Sum(pza_n051) As pza_n051, Sum(pza_n052) As pza_n052, ;
Sum(pza_n053) As pza_n053, Sum(pza_n054) As pza_n054, Sum(pza_n055) As pza_n055, Sum(pza_n056) As pza_n056, ;
Sum(pza_n057) As pza_n057, Sum(pza_n058) As pza_n058, Sum(pza_n059) As pza_n059, Sum(pza_n060) As pza_n060, ;
Sum(pza_n061) As pza_n061, Sum(pza_n062) As pza_n062, Sum(pza_n063) As pza_n063, Sum(pza_n064) As pza_n064, ;
Sum(pza_n065) As pza_n065, Sum(pza_n066) As pza_n066, Sum(pza_n067) As pza_n067, Sum(pza_n068) As pza_n068, ;
Sum(pza_n069) As pza_n069, Sum(pza_n070) As pza_n070, Sum(pza_n071) As pza_n071, Sum(pza_n072) As pza_n072, ;
Sum(pza_n073) As pza_n073, Sum(pza_n074) As pza_n074, Sum(pza_n075) As pza_n075, Sum(pza_n076) As pza_n076, ;
Sum(pza_n077) As pza_n077, Sum(pza_n078) As pza_n078, Sum(pza_n079) As pza_n079, Sum(pza_n080) As pza_n080, ;
Sum(pza_n081) As pza_n081, Sum(pza_n082) As pza_n082, Sum(pza_n083) As pza_n083, Sum(pza_n084) As pza_n084, ;
Sum(pza_n085) As pza_n085, Sum(pza_n086) As pza_n086, Sum(pza_n087) As pza_n087, Sum(pza_n088) As pza_n088, ;
Sum(pza_n089) As pza_n089, Sum(pza_n090) As pza_n090, Sum(pza_n091) As pza_n091, Sum(pza_n092) As pza_n092, ;
Sum(pza_n093) As pza_n093, Sum(pza_n094) As pza_n094, Sum(pza_n095) As pza_n095, Sum(pza_n096) As pza_n096, ;
Sum(pza_n097) As pza_n097, Sum(pza_n098) As pza_n098, Sum(pza_n099) As pza_n099, Sum(pza_n100) As pza_n100, ;
Sum(pza_n101) As pza_n101, Sum(pza_n102) As pza_n102, Sum(pza_n103) As pza_n103, Sum(pza_n104) As pza_n104, ;
Sum(pza_n105) As pza_n105, Sum(pza_n106) As pza_n106, Sum(pza_n107) As pza_n107, Sum(pza_n108) As pza_n108, ;
sum(pza_n109) as pza_n109, Sum(pza_n110) As pza_n110, Sum(pza_n111) As pza_n111, Sum(pza_n112) As pza_n112, ;
Sum(pza_n113) As pza_n113, Sum(pza_n114) As pza_n114, Sum(pza_n115) As pza_n115, Sum(pza_n116) As pza_n116, ;
Sum(pza_n117) As pza_n117, Sum(pza_n118) As pza_n118, Sum(pza_n119) As pza_n119, Sum(pza_n120) As pza_n120, ;
Sum(pza_n121) As pza_n121, Sum(pza_n122) As pza_n122, Sum(pza_n123) As pza_n123, Sum(pza_n124) As pza_n124, ;
Sum(pza_n125) As pza_n125, Sum(pza_n126) As pza_n126, Sum(pza_n127) As pza_n127, Sum(pza_n128) As pza_n128, ;
Sum(pza_n129) As pza_n129, Sum(pza_n130) As pza_n130, Sum(pza_n131) As pza_n131, Sum(pza_n132) As pza_n132, ;
Sum(pza_n133) As pza_n133, Sum(pza_n134) As pza_n134, Sum(pza_n135) As pza_n135, Sum(pza_n136) As pza_n136, ;
Sum(pza_n137) As pza_n137, Sum(pza_n138) As pza_n138, Sum(pza_n139) As pza_n139, Sum(pza_n140) As pza_n140;
From "tntnieuw!prodziekenhuizen alg" Where pza_cjaar='2004' And pza_ckwartaal='5' And pza_cinsfk In(;
Select Distinct b.ins_cpk from tntnieuw!instellingen b Where Upper(Alltrim(b.ins_cregfk)) =Upper(Alltrim('01')));
Group By pza_cjaar, pza_ckwartaal Order By 1,2 Into Cursor ZaSp_prod_reg_jaar_kw5

I think the problem has something to do with the length of the statement; when i put just the first 5 sum's in the select-statement(like in the example below) it works fine. So it looks like the limits for the length of an SQL-statement are SMALLER in VFP8 than in VFP7... And i refuse to beleve this...

Select ;
pza_cjaar, pza_ckwartaal, ;
Sum(pza_n001) As pza_n001, Sum(pza_n002) As pza_n002, Sum(pza_n003) As pza_n003, Sum(pza_n004) As pza_n004, ;
Sum(pza_n005) As pza_n005;
From "tntnieuw!prodziekenhuizen alg" Where pza_cjaar='2004' And pza_ckwartaal='5' And pza_cinsfk In(;
Select Distinct b.ins_cpk from tntnieuw!instellingen b Where Upper(Alltrim(b.ins_cregfk)) =Upper(Alltrim('01')));
Group By pza_cjaar, pza_ckwartaal Order By 1,2 Into Cursor ZaSp_prod_reg_jaar_kw5

Can anybody tell me something about this problem?

Tia!

Willem-Jan van Ede.