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/11/30 05:38] tdo |
programs:odxsql:commands:assignvalues [2012/10/26 14:57] (current) |
||
|---|---|---|---|
| Line 19: | 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 60: | Line 67: | ||
| - | |||
| - | |||
| - | |||