ATOUTFOX
COMMUNAUTÉ FRANCOPHONE DES PROFESSIONNELS FOXPRO
Visual FoxPro : le développement durable

Forum AtoutFox : Re: SQL - Dédoublonner un curseur selon des critères hiérarchisé   

Sujet

rss Flux RSS des derniers messages

Vous devez vous identifier pour pouvoir poser une question ou répondre.

mer. 18 juillet 2012, 13h32
Gregory
atoutfox.public.association

Re: SQL - Dédoublonner un curseur selon des critères hiérarchisé

Faudra peut-etre modifier l'ordre de la premiere requete

(1) Select de bren dans l'ordre (titre, max budget d'abord, ...)
Donc, par titre, celui qu'on veut apparait en premier

puis on ajoute une sequence

donc, par titre le max budget vient en premier

select recno() as seq, ;
T.* ;
from ( ;
select ctable,id,
ctitre,ditem,noccs,bbib_soci,id_bbib,bbib_budg,bbib_type,france ;
from bren ;
order by ctitre, bbib_budg desc, bbib_type, France,
Bbib_Soci, Bbib_Soci, ditem desc ;
) T ;
order by ctitre, seq ;
into cursor tmp ;

(2) on ne prend que la premiere ligne par tritre du resultat en haut


select tmp.* ;
from tmp, ;
( select ctitre, min(seq) as minSeq from tmp group by 1) X ;
where ( tmp.ctitre == X.ctitre ) ;
and ( seq = minSeq )

______
Gregory
______
"FoxInCloud" wrote in message news:ju625g$25ss$1@news.niouzes.net...

Merci Greg,

en fait je dois dédoublonner des enregistrements dans un ensemble
d'enregistrements ...

Voici un aperçu des données à dédoublonner
ctable,id,ctitre,ditem,noccs,bbib_soci,id_bbib,bbib_budg,bbib_type,france
"BREN",16939,"Adapter l’investissement aux besoins",31/10/2007,2,"HAAS
AUTOMATION EUROPE"
,999,0,"0",F
"BREN",16690,"Deux centres de fraisage UGV",28/09/2007,2,"JOBS
FRANCE"
,1213,0,"2",T
"BREN",26747,"Fehlmann expose sur le stand de Repmo
Machines-Outils"
,15/03/2012,3,"FEHLMANN SUISSE",789,0,"0",F
"BREN",26748,"Fehlmann expose sur le stand de Repmo
Machines-Outils"
,15/03/2012,3,"REPMO",1905,0,"1",T
"BREN",18627,"Fraiseuses CNC pour les matériaux
tendres"
,30/05/2008,2,"CHARLYROBOT",373,0,"1",T
"BREN",18971,"Fraiseuses CNC pour les matériaux
tendres"
,16/06/2008,2,"CHARLYROBOT",373,0,"1",T
"BREN",22573,"Lorsqu’un Artisan Horloger passe à la CN",29/01/2010,2,"HAAS
AUTOMATION EUROPE"
,999,0,"0",F
"BREN",25921,"L’art de la machine-outil selon Haas",25/10/2011,3,"HAAS
AUTOMATION EUROPE"
,999,0,"0",F
"BREN",25922,"L’art de la machine-outil selon Haas",25/10/2011,3,"DP
TECHNOLOGY EUROPE"
,6945,0,"0",T
"BREN",22385,"On modernise en vue de la
reprise"
,20/12/2009,4,"ACMM",13,0,"5",T
"BREN",22387,"On modernise en vue de la
reprise"
,20/12/2009,4,"CMOF",430,0,"0",T
"BREN",22388,"On modernise en vue de la reprise",20/12/2009,4,"HEIDENHAIN
FRANCE"
,1038,0,"0",T
"BREN",22386,"On modernise en vue de la reprise",20/12/2009,4,"MASCHINEN
WAGNER WERKZEUGMASCHINEN"
,10665,0,"5",F
"BREN",20609,"Prototypage rapide Soustractif",26/02/2009,2,"3D
SOLUTIONS"
,10209,0,"3",T
"BREN",20128,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"ARNO WERKZEUGE
KARL HEINZ ARNOLD GMBH"
,91,0,"2",F
"BREN",20141,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"BENZINGER",168,0,"5",F
"BREN",20149,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"SORALUCE",556,0,"2",T
"BREN",20134,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"ON.ING",649,0,"2",T
"BREN",20139,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"DMG
FRANCE"
,934,0,"0",T
"BREN",20143,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"HURON
GRAFFENSTADEN"
,1092,0,"0",T
"BREN",20136,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"KASTO
FRANCE"
,1253,0,"0",T
"BREN",20146,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"MANDELLI SISTEMI
SPA"
,1445,0,"2",F
"BREN",20137,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"YAMAZAKI MAZAK
FRANCE"
,1479,0,"0",T
"BREN",20140,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"MCM
FRANCE"
,1485,0,"0",T
"BREN",20138,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"MORI SEIKI
FRANCE"
,1604,0,"0",T
"BREN",20148,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"RIELLO MACCHINE
TRANSFER"
,1914,0,"2",F
"BREN",20133,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"FASTEMS
FRANCE"
,2066,0,"2",T
"BREN",20153,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"STAUBLI
ROBOTS"
,2289,0,"0",T
"BREN",20125,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"UCIMU
ITALIE"
,2468,0,"0",F
"BREN",20126,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"VERGNANO",2505,0,"5",F
"BREN",20152,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"REIS
FRANCE"
,2646,0,"2",T
"BREN",20127,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"MIKRON
TOOL"
,3220,0,"2",F
"BREN",20129,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"DENI
AG"
,4147,0,"2",F
"BREN",20144,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"SERRMAC",4200,0,"2",T
"BREN",20145,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"ATEMO MACHINES
OUTILS"
,4514,0,"0",T
"BREN",20150,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"NICOLAS
CORREA"
,6262,0,"5",F
"BREN",20142,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"MAKINO
FRANCE"
,6737,0,"0",T
"BREN",20132,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"CIELLE
DIFFUSION"
,8330,0,"2",T
"BREN",20147,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"MECOF
FRANCE"
,8486,0,"2",T
"BREN",20131,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"CABER
IMPIANTI"
,8938,0,"5",F
"BREN",20130,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"REA RHONE
EQUIPEMENT AUTOMATISMES"
,9223,0,"4",T
"BREN",20135,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"EMERSON PROCESS
MANAGEMENT"
,11827,0,"4",T
"BREN",25165,"Tournage/fraisage : DMG apporte des nouvelles d’Allemagne",31/03/2011,2,"DMG
FRANCE"
,934,0,"0",T
"BREN",23021,"Une CNC fait du point de croix chez B&R
Automation"
,26/02/2010,2,"B&R AUTOMATION",10267,0,"4",T


voici ce que me donne ma requête
ctable,id,ctitre,ditem,noccs,bbib_soci,id_bbib,bbib_budg,bbib_type,france
"BREN",16939,"Adapter l’investissement aux besoins",31/10/2007,2,"HAAS
AUTOMATION EUROPE"
,999,0,"0",F
"BREN",16690,"Deux centres de fraisage UGV",28/09/2007,2,"JOBS
FRANCE"
,1213,0,"2",T
"BREN",26747,"Fehlmann expose sur le stand de Repmo
Machines-Outils"
,15/03/2012,3,"FEHLMANN SUISSE",789,0,"0",F
"BREN",26748,"Fehlmann expose sur le stand de Repmo
Machines-Outils"
,15/03/2012,3,"REPMO",1905,0,"1",T
"BREN",18971,"Fraiseuses CNC pour les matériaux
tendres"
,16/06/2008,2,"CHARLYROBOT",373,0,"1",T
"BREN",22573,"Lorsqu’un Artisan Horloger passe à la CN",29/01/2010,2,"HAAS
AUTOMATION EUROPE"
,999,0,"0",F
"BREN",25921,"L’art de la machine-outil selon Haas",25/10/2011,3,"HAAS
AUTOMATION EUROPE"
,999,0,"0",F
"BREN",25922,"L’art de la machine-outil selon Haas",25/10/2011,3,"DP
TECHNOLOGY EUROPE"
,6945,0,"0",T
"BREN",22385,"On modernise en vue de la
reprise"
,20/12/2009,4,"ACMM",13,0,"5",T
"BREN",22387,"On modernise en vue de la
reprise"
,20/12/2009,4,"CMOF",430,0,"0",T
"BREN",22386,"On modernise en vue de la reprise",20/12/2009,4,"MASCHINEN
WAGNER WERKZEUGMASCHINEN"
,10665,0,"5",F
"BREN",20609,"Prototypage rapide Soustractif",26/02/2009,2,"3D
SOLUTIONS"
,10209,0,"3",T
"BREN",20128,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"ARNO WERKZEUGE
KARL HEINZ ARNOLD GMBH"
,91,0,"2",F
"BREN",20141,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"BENZINGER",168,0,"5",F
"BREN",20125,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"UCIMU
ITALIE"
,2468,0,"0",F
"BREN",20145,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"ATEMO MACHINES
OUTILS"
,4514,0,"0",T
"BREN",20132,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"CIELLE
DIFFUSION"
,8330,0,"2",T
"BREN",20135,"Quand la Bi MU prépare l’EMO",22/12/2008,2,"EMERSON PROCESS
MANAGEMENT"
,11827,0,"4",T
"BREN",25165,"Tournage/fraisage : DMG apporte des nouvelles d’Allemagne",31/03/2011,2,"DMG
FRANCE"
,934,0,"0",T
"BREN",23021,"Une CNC fait du point de croix chez B&R
Automation"
,26/02/2010,2,"B&R AUTOMATION",10267,0,"4",T


J'élimine des enregistrements mais ne n'arrive pas au résultat attendu à
savoir une seul ligne
"Quand la Bi MU prépare l’EMO"
Permalink : http://www.atoutfox.org/nntp.asp?ID=0000009407
20 286 messages dans le forum • Liste complète des messages

www.atoutfox.org - Site de la Communauté Francophone des Professionnels FoxPro - v3.4.0 - © 2004-2026.
Cette page est générée par un composant COM+ développé en Visual FoxPro 9.0-SP2-HF3