Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
edbmngr: maxrowcount |
Fri, May 11 2007 2:50 PM | Permanent Link |
"Harry de Boer" | LS
The statement below returns 20 records select id_medewerker, datum, min(aanvang) as begin, max(einde) as einde, max(einde) - min(aanvang) as werktijd from registraties where id_medewerker = '20003' and datum between date'2004-07-01' and date'2005-04-01' group by id_medewerker, datum If I set maxrowcount in edbmngr to 10 I except that the result would be the first 10 records. It only gives 4 records as result. Regards, Harry |
Mon, May 14 2007 5:27 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Harry,
<< If I set maxrowcount in edbmngr to 10 I except that the result would be the first 10 records. It only gives 4 records as result. >> MaxRowCount under EDB works the same as with DBISAM - it only limits the number of rows input into an aggregated query. It doesn't affect the number of rows output from an aggregated query. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Monday, May 6, 2024 at 03:23 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |