At 11:24 PM 1/22/2010, [email protected] wrote:
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
Diane,
Just curious ...
What are you trying to achieve with the huge list of SEQ#s, separated by
comma, in one big string?
Did you know that you can PROJECT a TEMPORARY table with just one column to
store those SEQ#s, and then do what you have to do with that list of SEQ#s.
Hope that gives you some blue's clues!
Very Best R:egards,
Razzak.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
