it's strange that it works but is limited to 26 lines. Is it
possible that 26 records is all that the SQL statement produces from
the database? (ie have you tried a "SELECT * FROM <table>" to see if
it returns more?)