Text-in query examples b, Query example i, Text-in query examples – Honeywell HRSD16 User Manual

Page 135

Advertising
background image

Text-In Query Examples

Document 800-00918

Rev F

135

02/08

B

Text-In Query Examples

Query Example I

1

2

3

4

5

6

123456789012345678901234567890123456789012345678901234567890

Item

Unit price

Qty

amount

==============================================

Coke

| $ 2.20 |

1(s) |

$

2.20

Fanta

| $ 2.20 |

1(s) |

$ 2.20

Hotdog

| $ 3.50 |

3(s) |

$ 10.50

Pepsi

| $ 1.95 |

1(s) |

$

1.95

==============================================

total : $ 16.85

Thank you~~

In the above text-in data, you can find that the comparison value is located at 17th (Unit
price, $ mark will be ignored automatically), 28th (Qty) and 40th (amount) characters
(including spaces) from the left. In this case, you can enter 17, 28, and 40 in each
Column field.

For example, if you want to search for Coke with a Qty (Quantity) of more than 1 and
Hotdog with an amount totaling over $8, the following search condition can be set.

Figure B-1

Query Example 1

Advertising