Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Want to remove the last two rows of an array
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 rows (i always get columns and rows confused. i want to delete two from the first subscript) 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 rows of calias from being inserted into RT_LETTR. calias is built with a STRUCTURE and never has the same number of rows or the same table column names.
Thanks
Brenda
Suivant
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