ULTIMATE DATABASE
HIGH QUALITY BESPOKE SOFTWARE DEVELOPMENT TOOL
Feature Rich
Rapid Application Development
Helping you or your customers
Manage their Business

All Commands All Reference
Commands

QUERY_REQ

Run a UDB Query but return a calculated value based on the response.
Number Name Default Type Description
1 action 1 Integer

The Action to run against the Query

Sum Minimum Maximum
1  = Return Qty
2  = Return Sum Int
3  = Return Sum Currency
4  = Return Sum Double

6  = Return Sum Int2
7  = Return Sum Currency2
8  = Return Sum Double2

10 = Return Sum of XML Value (tag name in ap1)		 11 = Return Min ID
12 = Return Min Int
13 = Return Min Currency
14 = Return Min Double
15 = Return Min Date
16 = Return Min Int2
17 = Return Min Currency2
18 = Return Min Double2
19 = Return Min Date2
20 = Return Min of XML Value (tag name in ap1)		 21 = Return Max ID
22 = Return Max Int
23 = Return Max Currency
24 = Return Max Double
25 = Return Max Date
26 = Return Max Int2
27 = Return Max Currency2
28 = Return Max Double2
29 = Return Max Date2
30 = Return Max of XML Value (tag name in ap1)
2 query String The Query to execute
3 tot_id 0 Integer The ID of the Total to add the result to.
If this is used then the result will not be output.
- ap1-8 String Additional Parameters to be passed to the Query
to add a Comment.