Hi, I have a table with about 30,000 records and an AUTONUM field called "seq#". I am using a SELECT command to generate a list of seq#s: SELECT (LISTOF(seq#)) INTO vlist IND vind from TABLENAME where &vwhere where "vwhere" is some condition. Because vlist can be long, I've defined it as VARCHAR: SET VAR vlist VARCHAR. However, the length of the list of seq# is never longer than 1500 characters. Is there any way to allow R:BASE to generate a longer list? I see that the LISTOF function returns a text value, so that is probably why the string returned is never longer than 1500 characters. Is the WHERE clause also limited to a certain number of characters as well? Thank you in advance, Diane DeMers [email protected] DeKalb, IL
