General information
Category:
Coding, syntax & commands
Try:
SELECT (calias)
SCAN FOR ALLTRIM(USER_ID) = ALLTRIM(User) and alltrim(lettername) = alltrim(letters.lettername)
SCATTER TO A_Temp
dime a_temp[alen(a_temp)-2]
INSERT INTO RT_LETTR FROM ARRAY A_Temp
release A_Temp
ENDSCAN
>>>>>>>>>>>>>your message below
SELECT (calias)
SCAN FOR ALLTRIM(USER_ID) = ALLTRIM(User) and alltrim(lettername) = alltrim(letters.lettername)
SCATTER TO A_Temp
INSERT INTO RT_LETTR FROM ARRAY A_Temp
ENDSCAN
Is some existing code that works. Except the last two columns of calias contain fields user and lettername which are really just in the table for programming. They should not be inserted into RT_LETTR. So I would like to prevent the last two columns of calias from being inserted into RT_LETTR. calias is built with a STRUCTURE and never has the same number of columns or the same column names.
Thanks
Brenda
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only