Query Problem

jhanvincent14

I've Just create a QUERY and that Query I set some FILTERS (See Attached Image). The FILTERS are correct, supposedly my codes (see attached image) are returning 3 lines of data and sum up the value. but my condition is not working even I'm using READ and FINDSET. please help solve my problem. I'm a newbie

Peter+is1

Hi,

I think you want to sum all amounts? You need a loop for that. In the example WHILE .. DO.

// Sets a filter to display only sales quantities greater than 20.
MyQuery.SETFILTER(Quantity, '>20'); 
// Runs the query.
MyQuery.OPEN;
// Reads each row in the dataset and displays message with column values.
// Stops reading when there are no more rows remaining in the dataset (READ is FALSE).
WHILE MyQuery.READ DO
BEGIN
  MESSAGE(Text000, MyQuery.Name, MyQuery.Quantity); 
END;
// Closes the query.
MyQuery.CLOSE;

Good luck, let us know how it works out for you!

Peter+is1

Hi,

I think you want to sum all amounts? You need a loop for that. In the example WHILE .. DO.

// Sets a filter to display only sales quantities greater than 20.
MyQuery.SETFILTER(Quantity, '>20'); 
// Runs the query.
MyQuery.OPEN;
// Reads each row in the dataset and displays message with column values.
// Stops reading when there are no more rows remaining in the dataset (READ is FALSE).
WHILE MyQuery.READ DO
BEGIN
  MESSAGE(Text000, MyQuery.Name, MyQuery.Quantity); 
END;
// Closes the query.
MyQuery.CLOSE;

Good luck, let us know how it works out for you!

jhanvincent14

it works. thanks a lot