Re: Error Num -229

Nils Myklebust wrote: > :is this to large of a select? > That may indeed be your problem. There may not be enough space on the > device where your temporary table is created. > Log in another time and check the available space as this foreach is > executed. > > :should I break it down into sets? > You may also check your select statement. If it is indeed what you > give above (a simple select from one table with no where clause) no > temporary table should be generated and I don't immediately understand > why you get the error you do. > If there is realy something more (an order by on a non indexed row > perhaps?) a temporary table may easily be generated and there may not > be enough space for it. The SELECT Statement is actually as follows: SELECT jc_jobdesc, cpja_job, cp_race, county, dst_campus, sch_co, sch_dist, sch_num, sch_campus FROM jobcode, cpja, cpdem, county, district, school WHERE county.county_co = district.district_co AND district.district_co = school.sch_co AND district.district_dst = school.sch_dist AND cpdem.cp_co = school.sch_co AND cpdem.cp_dst = school.sch_dist AND cpdem.cp_sch = school.sch_num AND cpja.cpja_ssn = cpdem.cp_ssn AND jobcode.jc_jobcode > "1020" AND jobcode.jc_jobcode = cpja.cpja_job ORDER BY sch_co, sch_dist, sch_num, cpja_job KEYS are as follows: TABLE | column ================================ jobcode | jc_jobcode ---------------+---------------- cpja | cpja_co " | cpja_dst " | cpja_sch " | cpja_ssn " | cpja_job ---------------+---------------- cpdem | cp_co " | cp_dst " | cp_sch " | cp_ssn ---------------+---------------- school | sch_co " | sch_dst " | sch_num ---------------+---------------- district | district_co " | district_dst ---------------+---------------- county | county_co