Information générale
Catégorie:
Codage, syntaxe et commandes
> code description date qty
> 1 desc for code 1 1st Dt for code 1 1st qty for code 1
> 2nd Dt for code 1 2nd qty for code 1
> 3rd dt for code 1 3rd qty for code 1
> 2 desc for code 2 1st dt for code 2 1st qty for code 2
>
> where instead of repeating the parent fields, it should blank.
>
> Pls advs your comments, if it possible to do it through Sql or what is the
> best way to do it. I don't want to use scan..endscan.
I'm not very sure that SQL is the best way, but if you must
do it with sql commands check this out :
local lcLastCode
lcLastCode = '}}}}' && if the code is char type
select ;
HideRepValue(a.code) as code,HideRepValue(a.desc) as desc,b.date,b.qty ;
from ;
main a,child b ;
where ;
a.code = b.code
function HideRepValues
lparameter lcFieldValue
if lcFieldValue == lcLastCode
return space(len(lcFieldValue))
else
lcLastCode = lcFieldValue
return lcFieldValue
endif
Précédent
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