Information générale
Catégorie:
Codage, syntaxe et commandes
>@Rick,
>Rick I am afraid your solution, for only spaces and no .NULL. does not work as such since I am not working with text but memo fields.
My solution is Cetin's exact solution except for using NVL() assignment on the fields.
You'll want to cast your field contents to a fixed c(###) length so the values are not truncated if the first record happens to be short compared to other longer records.
I was thinking also on my drive home, Cetin's solution may not work if there is more than one field1, field2, or field3 record for a given group.
I don't have VFP on this computer, but Cetin should be able to give you a new SQL expression. If not, I can give you an XBASE-based solution tomorrow that will work.
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