I simply create a variable i1 and use that on every variable in a select
into. The same null indicator on every variable works for me, and takes
up very little room in RBEdit.
Albert
On 16/05/2012 7:31 AM, Lawrence Lustig wrote:
<<
I too like the SELECT ... INTO ... option
but I would include INDICATOR variables to test for NULL values.
>>
I always include an INDICATOR variable (to avoid the warning), but
it's the same variable for each column (always called vI) and I never
check it.
--
Larry
No virus found in this message.
Checked by AVG - www.avg.com <http://www.avg.com>
Version: 2012.0.2176 / Virus Database: 2425/5001 - Release Date: 05/15/12
--- 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.
================================================
