Stupid SQL?

Martin_Gäckler

Hello,I have found the SQL command select agentid from AgentSchedule where AgentId = :A1in connect102.log, then hundreds of Fetch( 9999 ).How much money did OpenText receive from network and server hardware vendors?Why did Opentext not use this sequence:select count(*) into :count from AgentSchedule where AgentId = :A1for( i=0; i<count; i++ ){ // do any stuff}?Confused Martin