This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
programs:odxsql:commands:assignvalues [2009/07/16 22:07] 127.0.0.1 external edit |
programs:odxsql:commands:assignvalues [2012/10/26 14:28] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== ASSIGNVALUES ====== | ====== ASSIGNVALUES ====== | ||
| + | |||
| + | ===== Description ===== | ||
| ASSIGNVALUES is used to assign an undetermined set of values contained in a buffer ($VALUES) to be used as selection criteria in a SQL select statement. | ASSIGNVALUES is used to assign an undetermined set of values contained in a buffer ($VALUES) to be used as selection criteria in a SQL select statement. | ||
| Line 17: | Line 19: | ||
| - | ASSIGNVALUES <value|(value[,value...])>[TO label][ON [CURSOR] cursor][WITH options] | + | ASSIGNVALUES <value|(value[,value...])> |
| + | [TO label] | ||
| + | [ON [CURSOR] cursor] | ||
| + | |||
| ASSIGNVALUES | ASSIGNVALUES | ||
| Required | Required | ||
| - | value | (value[,value...]) | + | == value | (value[,value...]) == |
| Required - Either a single value or a comma separated value list enclosed in parenthesis. These are the values to be used as criteria in a SELECT statement. | Required - Either a single value or a comma separated value list enclosed in parenthesis. These are the values to be used as criteria in a SELECT statement. | ||
| - | [TO label] | + | == [TO label] == |
| Optional - Give a name to the buffer containing the values to be used as criteria. This is most useful when using more than one set of values. | Optional - Give a name to the buffer containing the values to be used as criteria. This is most useful when using more than one set of values. | ||
| - | [ON [CURSOR] cursor] | + | == [ON [CURSOR] cursor] == |
| Optional - Specify which cursor is to be used for this command. If omitted, the current cursor will be used. The "CURSOR" keyword is optional. | Optional - Specify which cursor is to be used for this command. If omitted, the current cursor will be used. The "CURSOR" keyword is optional. | ||
| + | |||
| ===== Examples ===== | ===== Examples ===== | ||
| Line 49: | Line 58: | ||
| Multiple $VALUES assignments can be used in a single select by giving each a label. | Multiple $VALUES assignments can be used in a single select by giving each a label. | ||
| - | >select company, contact from customers where state in $values(2,,,'VAL1') and city in $values(4,,,'VAL2') | + | > select company, contact from customers where state in $values(2,,,'VAL1') \ |
| - | >assignvalues ('CO','CA') to VAL1 | + | (cont) and city in $values(4,,,'VAL2') |
| - | >assignvalues ('BOULDER','DENVER','LOS ANGELES','SAN FRANCISCO') to VAL2 | + | > assignvalues ('CO','CA') to VAL1 |
| - | >fetch all | + | > assignvalues ('BOULDER','DENVER','LOS ANGELES','SAN FRANCISCO') to VAL2 |
| + | > fetch all | ||
| - | |||
| - | |||
| - | |||