A
agent_008_nl
Guest
OE 11.3.0, sports2000 database (original). Very strange. I want to sort on repname and get differences when I change only the batchsize. With 6 sorting is ok, with 7 not. See below for code and results. Is this a known bug solved in a later version? DEFINE DATA-SOURCE srcSalesrep FOR Salesrep. DEFINE TEMP-TABLE eSalesrep NO-UNDO BEFORE-TABLE beSalesrep FIELD SalesRep AS CHARACTER FIELD RepName AS CHARACTER FIELD Region AS CHARACTER FIELD MonthQuota AS INTEGER INDEX SalesRep IS UNIQUE PRIMARY SalesRep. DEFINE DATASET dsSalesrep FOR eSalesrep. BUFFER eSalesrep:ATTACH-DATA-SOURCE(DATA-SOURCE srcSalesrep:HANDLE). DATA-SOURCE srcSalesrep:FILL-WHERE-STRING = "WHERE TRUE BY repname". BUFFER eSalesrep:BATCH-SIZE = 6. DATASET dsSalesrep:FILL(). FOR EACH eSalesrep: DISP eSalesrep. END. BUFFER eSalesrep
ETACH-DATA-SOURCE(). Below with BUFFER eSalesrep:BATCH-SIZE = 7. With no batch-size stting sorting does not work either. -- Kind regards, Stefan Houtzager Houtzager ICT consultancy & development www.linkedin.com/in/stefanhoutzager
Continue reading...
Continue reading...