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és   

Sujet

rss Flux RSS des derniers messages

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

mer. 18 juillet 2012, 12h12

FoxInCloud (Th. Nivelet)
France France

atoutfox.public.association

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

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=0000009406
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