Database query with SET values (for SQL UPDATE), WHERE parameters, LIMIT, and ORDER BY. Do not modify this derived type directly!
| Type | Visibility | Attributes | Name | Initial | |||
|---|---|---|---|---|---|---|---|
| character(len=:), | public, | allocatable | :: | order_by |
ORDER BY clause. |
||
| logical, | public | :: | order_desc | = | .false. |
ASC or DESC order. |
|
| integer(kind=i8), | public | :: | limit | = | 0_i8 |
Row limit. |
|
| integer, | public | :: | nparams | = | 0 |
Current WHERE parameter array size. |
|
| integer, | public | :: | nupdates | = | 0 |
Current SET parameter array size. |
|
| type(db_query_param_type), | public | :: | params(DB_QUERY_NPARAMS) |
WHERE parameter array. |
|||
| type(db_query_param_type), | public | :: | updates(DB_QUERY_NPARAMS) |
SET parameter array. |