|
This command produces an error message (illegal column
specification 2512):
SELECT (LISTOF(Name_DataBase)) INTO vDBList INDICATOR
vIndicator +
FROM Temp_Table ORDER BY Menu_Sort This version has no error but doesn't appear to sort the
list:
SELECT (LISTOF(Name_DataBase)) INTO vDBList INDICATOR
vIndicator +
FROM Temp_Table WHERE Name_DataBase IS NOT NULL ORDER BY Menu_Sort I have overcome this by simply projecting a second and
sorted temp table and selecting from that but should the order by clause
work?
Regards,
Alastair. ----------------------------------
A D B Burr, St. Albans, UK. ---------------------------------- [EMAIL PROTECTED] ---------------------------------- |
