Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Want to remove the last two rows of an array
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Want to remove the last two rows of an array
Divers
Thread ID:
00477183
Message ID:
00477183
Vues:
64
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
Fil
Voir

Click here to load this message in the networking platform