Forum Post: sorting problem with fill-where-string

  • Thread starter Thread starter agent_008_nl
  • Start date Start date
Status
Not open for further replies.
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:DETACH-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...
 
Status
Not open for further replies.
Back
Top