Information générale
Catégorie:
Codage, syntaxe et commandes
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement