> SELECT ColumnName INTO vValueList INDIC IvValueList +
> FROM TableName WHERE ... ORDER BY ...
>
> I see a major problem with this change. Many developers I know us this
> syntax to retrieve one value from a table, ignoring the error message if
> there are more values because they just want the first.
I don't think Razzak's reply was an indication of a change in the way SELECT
works, I think he meant that if you can get a your menu list from a single
record in the table, then you can use the syntax above.
> You really need another keyword in the
> select to tell it to retrieve a list, or have a SET LISTSELECT ON as an
> environmental setting with OFF as the default. My preference would be the
> extra keyword in the select command because it is more easily documented,
> and is self documenting in the code.
> SELECT LIST ColumnName INTO vValueList INDIC IvValueList +
> FROM TableName WHERE ... ORDER BY ...
My preference would be an additional aggregate function LIST or LISTOF:
SELECT LISTOF(ColumnName) INTO vValueList +
FROM TableName WHERE ... ORDER BY ...
which would produce a vValueList with all the ColumnName values separated by
the current DELIMITER. I think this fits in very well with the current
aggregate functions SUM and COUNT (etc) and also suggests where in the code
it could most easily be added.
--
Larry
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
