PB à toute heure et à tout moment. (à parcourir avec modération)

Le forum (ô combien francophone) des utilisateurs de Powerbuilder.

Recherche rapide

Annonce

Certaines rubriques, dont des cours, sont uniquement visibles par les membres du forum ^^.
Dans la rubrique Liens & Références, vous avez accès à un sommaire de téléchargement, profitez-en !
Il existe maintenant un nouveau TOPIC "Votre CV en Ligne" accessible uniquement par demande.

Pages: 1

 

#1 29-09-2006 07:46:00

Deedoo2000  
Membre Geek
Date d'inscription: 13-09-2006
Messages: 91
Pépites: 408
Banque: 0

[RESOLU] Executer une requete SQL

Bonjour,

Je n'arrive pas à exécuter une requête SQL en procédant de la sorte :

ls_requete contient ma requête

et

Code: pb

execute immediate :ls_requete

me renvoie un syntax error.

Savez-vous quelle est la bonne syntaxe ?

Hors ligne

 

#2 29-09-2006 07:53:34

pick ouic  
La bourse ou la vie ^^
Award: gearotter
Lieu: Massy-Verrières
Date d'inscription: 29-05-2006
Messages: 4658
Pépites: 942
Banque: 2,147,483,647
Site web

Re: [RESOLU] Executer une requete SQL

tu peux mettre toute la syntaxe ?

histoire de voir au detail.

sinon, tu as été voir la ?  http://pbadonf.fr/forum/viewtopic.php?pid=538#p538

Connaitre son ignorance est une grande part de la connaissance.
http://animegifs.free.fr/anime/mazinger/mazinger.gif

Hors ligne

 

#3 29-09-2006 07:57:25

Deedoo2000  
Membre Geek
Date d'inscription: 13-09-2006
Messages: 91
Pépites: 408
Banque: 0

Re: [RESOLU] Executer une requete SQL

le lien que tu me donnes, c'est pour executer une procédure stockée.

Là , je voudrais executer une requête SQL que je construis dans mon script PowerBuilder.

Par exemple

ls_requete = "insert into EMPLOYES(NOM) values("toto")

execute immediate :ls_requete

Mais ça ne marche pas...

Hors ligne

 

#4 29-09-2006 08:02:16

pick ouic  
La bourse ou la vie ^^
Award: gearotter
Lieu: Massy-Verrières
Date d'inscription: 29-05-2006
Messages: 4658
Pépites: 942
Banque: 2,147,483,647
Site web

Re: [RESOLU] Executer une requete SQL

execute, c'est pour l'appel des procédures stockées.

sinon, depuis pb, tu peux mettre directement la commande
insert into ect... ;

http://pbadonf.fr/forum/viewtopic.php?pid=38#p38

Connaitre son ignorance est une grande part de la connaissance.
http://animegifs.free.fr/anime/mazinger/mazinger.gif

Hors ligne

 

#5 29-09-2006 08:05:04

Deedoo2000  
Membre Geek
Date d'inscription: 13-09-2006
Messages: 91
Pépites: 408
Banque: 0

Re: [RESOLU] Executer une requete SQL

Oui mais je ne suis pas sur que écrire directement insert into marche en faisant quelquechose comme :

insert into EMPLOYES(ls_colonne[i])
values(ls_nom)

où on fait une boucle sur i qui permet d'énumérer les colonnes de la table EMPLOYES une par une.

Hors ligne

 

#6 29-09-2006 08:08:06

pick ouic  
La bourse ou la vie ^^
Award: gearotter
Lieu: Massy-Verrières
Date d'inscription: 29-05-2006
Messages: 4658
Pépites: 942
Banque: 2,147,483,647
Site web

Re: [RESOLU] Executer une requete SQL

je ne comprends pas pourquoi tu te compliques autant.
la methode via une datastore est la plus simple,
il suffit juste de recuperer les données de la datawindow 1, et mettre apres sur la bonne colonne de la datastore cible.

apres, il n'y a plus qu'à faire un update.

la , j'ai du mal à te comprendre.

Connaitre son ignorance est une grande part de la connaissance.
http://animegifs.free.fr/anime/mazinger/mazinger.gif

Hors ligne

 

#7 29-09-2006 08:13:56

Deedoo2000  
Membre Geek
Date d'inscription: 13-09-2006
Messages: 91
Pépites: 408
Banque: 0

Re: [RESOLU] Executer une requete SQL

pick ouic a écrit:

je ne comprends pas pourquoi tu te compliques autant.
la methode via une datastore est la plus simple,
il suffit juste de recuperer les données de la datawindow 1, et mettre apres sur la bonne colonne de la datastore cible.

apres, il n'y a plus qu'à faire un update.

la , j'ai du mal à te comprendre.

Je n'arrive pas à le faire
J'ai bien compris le principe mais je n'arrive pas à l'appliquer...
Voila comment je m'y prends :

J'ai mon lds_1 dont le dataobect est dw_1 qui comporte 73 colonnes, que je souhaite insérer dans une table sybase.
J'ai donc créé une table sybase qui reprend la même structure (73 colonnes).
Je crée un lds_2 auquel j'associe dw_2.
dw_2 a été construit en Quick Select dans l'interface PB. Avec le QuickSelect je fais juste un select sur toutes les colonnes de ma table cible et j'obtiens donc dw_2 qui a la même structure que dw_1.
Je fais ensuite un rowscopy de dw_1 vers dw_2 mais celui-ci se passe mal. J'ai -1 en retour.
Je m'y prends mal quelquepart ?

Hors ligne

 

#8 29-09-2006 08:18:16

pick ouic  
La bourse ou la vie ^^
Award: gearotter
Lieu: Massy-Verrières
Date d'inscription: 29-05-2006
Messages: 4658
Pépites: 942
Banque: 2,147,483,647
Site web

Re: [RESOLU] Executer une requete SQL

on peut le faire ensemble, en live
si tu veux.
ca va resoudre rapidement ton probleme.

donnes moi le descriptif de la premiere datawindow,
puis celui de la datastore.

enfin, les valeurs à recuperer pour la datastore.

Connaitre son ignorance est une grande part de la connaissance.
http://animegifs.free.fr/anime/mazinger/mazinger.gif

Hors ligne

 

#9 29-09-2006 08:25:18

Deedoo2000  
Membre Geek
Date d'inscription: 13-09-2006
Messages: 91
Pépites: 408
Banque: 0

Re: [RESOLU] Executer une requete SQL

pick ouic a écrit:

on peut le faire ensemble, en live
si tu veux.
ca va resoudre rapidement ton probleme.

donnes moi le descriptif de la premiere datawindow,
puis celui de la datastore.

enfin, les valeurs à recuperer pour la datastore.

Tu veux que je fasse un export de dw_1 et que je le colle ici ?
Je ne comprends pas la suite. Qu'apelles-tu descriptif d'une datastore ? Je me contente juste de la déclarer, la créer et ensuite lui associer dw_1.

Les valeurs à récupérer sont les colonnes affichées dans dw_1 pour toutes les lignes, que je souhaite insérer dans une table sybase.

Hors ligne

 

#10 29-09-2006 08:28:22

pick ouic  
La bourse ou la vie ^^
Award: gearotter
Lieu: Massy-Verrières
Date d'inscription: 29-05-2006
Messages: 4658
Pépites: 942
Banque: 2,147,483,647
Site web

Re: [RESOLU] Executer une requete SQL

oui, fais un export.
et colles l'export ici.
pareil pour la datastore.
ca permettra deja de voir un peu plus clair la structure de tes datawindows

Connaitre son ignorance est une grande part de la connaissance.
http://animegifs.free.fr/anime/mazinger/mazinger.gif

Hors ligne

 

#11 29-09-2006 08:29:34

Deedoo2000  
Membre Geek
Date d'inscription: 13-09-2006
Messages: 91
Pépites: 408
Banque: 0

Re: [RESOLU] Executer une requete SQL

pick ouic a écrit:

oui, fais un export.
et colles l'export ici.
pareil pour la datastore.
ca permettra deja de voir un peu plus clair la structure de tes datawindows

Mais pour moi une datastore ça ne s'exporte pas, c'est juste un container de datawindow. Je ne comprends pas...

Hors ligne

 

#12 29-09-2006 08:30:46

Deedoo2000  
Membre Geek
Date d'inscription: 13-09-2006
Messages: 91
Pépites: 408
Banque: 0

Re: [RESOLU] Executer une requete SQL

pick ouic a écrit:

oui, fais un export.
et colles l'export ici.
pareil pour la datastore.
ca permettra deja de voir un peu plus clair la structure de tes datawindows

Voila l'export de dw_1 :

Code:

$PBExportHeader$d_export_vote_vpc_file_agm.srd
release 9;
datawindow(units=0 timer_interval=0 color=16777215 processing=1 HTMLDW=no print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes hidegrayline=no grid.lines=0 )
header(height=80 color="536870912" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=92 color="536870912" )
table(column=(type=decimal(0) updatewhereclause=no name=id_actnaire dbname="ID_ACTNAIRE" )
 column=(type=char(50) updatewhereclause=no name=civilite dbname="CIVILITE" )
 column=(type=char(64) updatewhereclause=no name=nom dbname="NOM" )
 column=(type=char(50) updatewhereclause=no name=prenom dbname="PRENOM" )
 column=(type=char(50) updatewhereclause=no name=rue dbname="RUE" )
 column=(type=char(50) updatewhereclause=no name=batiment dbname="BATIMENT" )
 column=(type=char(50) updatewhereclause=no name=complement dbname="COMPLEMENT" )
 column=(type=char(50) updatewhereclause=no name=code_postal dbname="CODE_POSTAL" )
 column=(type=char(50) updatewhereclause=no name=ville dbname="VILLE" )
 column=(type=char(50) updatewhereclause=no name=pays dbname="PAYS" )
 column=(type=decimal(0) updatewhereclause=no name=ccn dbname="CCN" )
 column=(type=char(50) updatewhereclause=no name=intermediaire dbname="INTERMEDIAIRE" )
 column=(type=char(10) updatewhereclause=no name=type dbname="TYPE" )
 column=(type=char(25) updatewhereclause=no name=origine dbname="ORIGINE" )
 column=(type=decimal(0) updatewhereclause=no name=actions_ago dbname="ACTIONS_AGO" )
 column=(type=decimal(0) updatewhereclause=no name=voix_ago dbname="VOIX_AGO" )
 column=(type=decimal(0) updatewhereclause=no name=actions_age dbname="ACTIONS_AGE" )
 column=(type=decimal(0) updatewhereclause=no name=voix_age dbname="VOIX_AGE" )
 column=(type=char(3) updatewhereclause=no name=nouv_res dbname="NOUV_RES" )
 column=(type=char(32) updatewhereclause=no name=ref_societe dbname="REF_SOCIETE" )
 column=(type=char(100) updatewhereclause=no name=ref_salarie dbname="REF_SALARIE" )
 column=(type=char(5) updatewhereclause=no name=cd_reg_cou dbname="CD_REG_COU" )
 column=(type=char(5) updatewhereclause=no name=cd_ss_reg_cou dbname="CD_SS_REG_COU" )
 column=(type=char(1) updatewhereclause=no name=r01 dbname="R01" )
 column=(type=char(1) updatewhereclause=no name=r02 dbname="R02" )
 column=(type=char(1) updatewhereclause=no name=r03 dbname="R03" )
 column=(type=char(1) updatewhereclause=no name=r04 dbname="R04" )
 column=(type=char(1) updatewhereclause=no name=r05 dbname="R05" )
 column=(type=char(1) updatewhereclause=no name=r06 dbname="R06" )
 column=(type=char(1) updatewhereclause=no name=r07 dbname="R07" )
 column=(type=char(1) updatewhereclause=no name=r08 dbname="R08" )
 column=(type=char(1) updatewhereclause=no name=r09 dbname="R09" )
 column=(type=char(1) updatewhereclause=no name=r10 dbname="R10" )
 column=(type=char(1) updatewhereclause=no name=r11 dbname="R11" )
 column=(type=char(1) updatewhereclause=no name=r12 dbname="R12" )
 column=(type=char(1) updatewhereclause=no name=r13 dbname="R13" )
 column=(type=char(1) updatewhereclause=no name=r14 dbname="R14" )
 column=(type=char(1) updatewhereclause=no name=r15 dbname="R15" )
 column=(type=char(1) updatewhereclause=no name=r16 dbname="R16" )
 column=(type=char(1) updatewhereclause=no name=r17 dbname="R17" )
 column=(type=char(1) updatewhereclause=no name=r18 dbname="R18" )
 column=(type=char(1) updatewhereclause=no name=r19 dbname="R19" )
 column=(type=char(1) updatewhereclause=no name=r20 dbname="R20" )
 column=(type=char(1) updatewhereclause=no name=r21 dbname="R21" )
 column=(type=char(1) updatewhereclause=no name=r22 dbname="R22" )
 column=(type=char(1) updatewhereclause=no name=r23 dbname="R23" )
 column=(type=char(1) updatewhereclause=no name=r24 dbname="R24" )
 column=(type=char(1) updatewhereclause=no name=r25 dbname="R25" )
 column=(type=char(1) updatewhereclause=no name=r26 dbname="R26" )
 column=(type=char(1) updatewhereclause=no name=r27 dbname="R27" )
 column=(type=char(1) updatewhereclause=no name=r28 dbname="R28" )
 column=(type=char(1) updatewhereclause=no name=r29 dbname="R29" )
 column=(type=char(1) updatewhereclause=no name=r30 dbname="R30" )
 column=(type=char(1) updatewhereclause=no name=r31 dbname="R31" )
 column=(type=char(1) updatewhereclause=no name=r32 dbname="R32" )
 column=(type=char(1) updatewhereclause=no name=r33 dbname="R33" )
 column=(type=char(1) updatewhereclause=no name=r34 dbname="R34" )
 column=(type=char(1) updatewhereclause=no name=r35 dbname="R35" )
 column=(type=char(1) updatewhereclause=no name=r36 dbname="R36" )
 column=(type=char(1) updatewhereclause=no name=r37 dbname="R37" )
 column=(type=char(1) updatewhereclause=no name=r38 dbname="R38" )
 column=(type=char(1) updatewhereclause=no name=r39 dbname="R39" )
 column=(type=char(1) updatewhereclause=no name=r40 dbname="R40" )
 column=(type=char(1) updatewhereclause=no name=r41 dbname="R41" )
 column=(type=char(1) updatewhereclause=no name=r42 dbname="R42" )
 column=(type=char(1) updatewhereclause=no name=r43 dbname="R43" )
 column=(type=char(1) updatewhereclause=no name=r44 dbname="R44" )
 column=(type=char(1) updatewhereclause=no name=r45 dbname="R45" )
 column=(type=char(1) updatewhereclause=no name=r46 dbname="R46" )
 column=(type=char(1) updatewhereclause=no name=r47 dbname="R47" )
 column=(type=char(1) updatewhereclause=no name=r48 dbname="R48" )
 column=(type=char(1) updatewhereclause=no name=r49 dbname="R49" )
 column=(type=char(1) updatewhereclause=no name=r50 dbname="R50" )
 )
group(level=1 header.height=0 trailer.height=96 by=("intermediaire" ) header.color="536870912" trailer.color="536870912" )
text(band=header alignment="2" text="Civilite" border="0" color="0" x="9" y="8" height="64" width="297" html.valueishtml="0"  name=civilite_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Nom" border="0" color="0" x="315" y="8" height="64" width="229" html.valueishtml="0"  name=nom_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Prenom" border="0" color="0" x="553" y="8" height="64" width="256" html.valueishtml="0"  name=prenom_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Rue" border="0" color="0" x="818" y="8" height="64" width="293" html.valueishtml="0"  name=rue_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Batiment" border="0" color="0" x="1120" y="8" height="64" width="334" html.valueishtml="0"  name=batiment_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Complement" border="0" color="0" x="1463" y="8" height="64" width="416" html.valueishtml="0"  name=complement_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Code Postal" border="0" color="0" x="1888" y="8" height="64" width="352" html.valueishtml="0"  name=code_postal_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Ville" border="0" color="0" x="2249" y="8" height="64" width="151" html.valueishtml="0"  name=ville_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Pays" border="0" color="0" x="2409" y="8" height="64" width="210" html.valueishtml="0"  name=pays_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Actions" border="0" color="0" x="2629" y="8" height="64" width="251" html.valueishtml="0"  name=actions_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Voix" border="0" color="0" x="2889" y="8" height="64" width="215" html.valueishtml="0"  name=voix_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R01" border="0" color="0" x="3982" y="8" height="64" width="105" html.valueishtml="0"  name=r01_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R02" border="0" color="0" x="4096" y="8" height="64" width="105" html.valueishtml="0"  name=r02_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R03" border="0" color="0" x="4210" y="8" height="64" width="105" html.valueishtml="0"  name=r03_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R04" border="0" color="0" x="4325" y="8" height="64" width="105" html.valueishtml="0"  name=r04_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R05" border="0" color="0" x="4439" y="8" height="64" width="105" html.valueishtml="0"  name=r05_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R06" border="0" color="0" x="4553" y="8" height="64" width="105" html.valueishtml="0"  name=r06_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R07" border="0" color="0" x="4667" y="8" height="64" width="105" html.valueishtml="0"  name=r07_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R08" border="0" color="0" x="4782" y="8" height="64" width="105" html.valueishtml="0"  name=r08_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R09" border="0" color="0" x="4896" y="8" height="64" width="105" html.valueishtml="0"  name=r09_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R10" border="0" color="0" x="5010" y="8" height="64" width="105" html.valueishtml="0"  name=r10_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R11" border="0" color="0" x="5125" y="8" height="64" width="105" html.valueishtml="0"  name=r11_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R12" border="0" color="0" x="5239" y="8" height="64" width="105" html.valueishtml="0"  name=r12_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R13" border="0" color="0" x="5353" y="8" height="64" width="105" html.valueishtml="0"  name=r13_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R14" border="0" color="0" x="5467" y="8" height="64" width="105" html.valueishtml="0"  name=r14_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R15" border="0" color="0" x="5582" y="8" height="64" width="105" html.valueishtml="0"  name=r15_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R16" border="0" color="0" x="5696" y="8" height="64" width="105" html.valueishtml="0"  name=r16_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R17" border="0" color="0" x="5810" y="8" height="64" width="105" html.valueishtml="0"  name=r17_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R18" border="0" color="0" x="5925" y="8" height="64" width="105" html.valueishtml="0"  name=r18_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R19" border="0" color="0" x="6039" y="8" height="64" width="105" html.valueishtml="0"  name=r19_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R20" border="0" color="0" x="6153" y="8" height="64" width="105" html.valueishtml="0"  name=r20_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R21" border="0" color="0" x="6267" y="8" height="64" width="105" html.valueishtml="0"  name=r21_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R22" border="0" color="0" x="6382" y="8" height="64" width="105" html.valueishtml="0"  name=r22_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R23" border="0" color="0" x="6496" y="8" height="64" width="105" html.valueishtml="0"  name=r23_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R24" border="0" color="0" x="6610" y="8" height="64" width="105" html.valueishtml="0"  name=r24_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R25" border="0" color="0" x="6725" y="8" height="64" width="105" html.valueishtml="0"  name=r25_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R26" border="0" color="0" x="6839" y="8" height="64" width="105" html.valueishtml="0"  name=r26_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R27" border="0" color="0" x="6953" y="8" height="64" width="105" html.valueishtml="0"  name=r27_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R28" border="0" color="0" x="7067" y="8" height="64" width="105" html.valueishtml="0"  name=r28_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R29" border="0" color="0" x="7182" y="8" height="64" width="105" html.valueishtml="0"  name=r29_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R30" border="0" color="0" x="7296" y="8" height="64" width="105" html.valueishtml="0"  name=r30_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R31" border="0" color="0" x="7410" y="8" height="64" width="105" html.valueishtml="0"  name=r31_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R32" border="0" color="0" x="7525" y="8" height="64" width="105" html.valueishtml="0"  name=r32_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R33" border="0" color="0" x="7639" y="8" height="64" width="105" html.valueishtml="0"  name=r33_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R34" border="0" color="0" x="7753" y="8" height="64" width="105" html.valueishtml="0"  name=r34_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R35" border="0" color="0" x="7867" y="8" height="64" width="105" html.valueishtml="0"  name=r35_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R36" border="0" color="0" x="7982" y="8" height="64" width="105" html.valueishtml="0"  name=r36_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R37" border="0" color="0" x="8096" y="8" height="64" width="105" html.valueishtml="0"  name=r37_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R38" border="0" color="0" x="8210" y="8" height="64" width="105" html.valueishtml="0"  name=r38_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R39" border="0" color="0" x="8325" y="8" height="64" width="105" html.valueishtml="0"  name=r39_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R40" border="0" color="0" x="8439" y="8" height="64" width="105" html.valueishtml="0"  name=r40_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R41" border="0" color="0" x="8553" y="8" height="64" width="105" html.valueishtml="0"  name=r41_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R42" border="0" color="0" x="8667" y="8" height="64" width="105" html.valueishtml="0"  name=r42_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R43" border="0" color="0" x="8782" y="8" height="64" width="105" html.valueishtml="0"  name=r43_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R44" border="0" color="0" x="8896" y="8" height="64" width="105" html.valueishtml="0"  name=r44_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R45" border="0" color="0" x="9010" y="8" height="64" width="105" html.valueishtml="0"  name=r45_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R46" border="0" color="0" x="9125" y="8" height="64" width="105" html.valueishtml="0"  name=r46_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R47" border="0" color="0" x="9239" y="8" height="64" width="105" html.valueishtml="0"  name=r47_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R48" border="0" color="0" x="9353" y="8" height="64" width="105" html.valueishtml="0"  name=r48_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R49" border="0" color="0" x="9467" y="8" height="64" width="105" html.valueishtml="0"  name=r49_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="0" text="Actions Age" border="0" color="0" x="3113" y="4" height="64" width="425" html.valueishtml="0"  name=t_5 visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="0" text="Voix Age" border="0" color="0" x="3547" y="4" height="64" width="425" html.valueishtml="0"  name=t_6 visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="R50" border="0" color="0" x="9582" y="8" height="64" width="105" html.valueishtml="0"  name=r50_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="0" text="Intermediaire" border="0" color="0" x="9696" y="8" height="64" width="247" html.valueishtml="0"  name=t_1 visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=header alignment="0" text="Origine" border="0" color="0" x="9952" y="8" height="64" width="791" html.valueishtml="0"  name=t_2 visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=header alignment="0" text="Ccn" border="0" color="0" x="10752" y="8" height="64" width="247" html.valueishtml="0"  name=t_3 visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=header alignment="0" text="Type" border="0" color="0" x="11008" y="8" height="64" width="311" html.valueishtml="0"  name=t_4 visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=header alignment="0" text="Id Actnaire" border="0" color="0" x="11328" y="8" height="64" width="247" html.valueishtml="0"  name=t_7 visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=header alignment="0" text="Ref Societe" border="0" color="0" x="11584" y="8" height="64" width="855" html.valueishtml="0"  name=ref_societe_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="0" text="Ref Salarie" border="0" color="0" x="12448" y="8" height="64" width="2693" html.valueishtml="0"  name=ref_salarie_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="0" text="Cd Reg Cou" border="0" color="0" x="15150" y="8" height="64" width="128" html.valueishtml="0"  name=cd_reg_cou_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="0" text="Cd Ss Reg Cou" border="0" color="0" x="15287" y="8" height="64" width="128" html.valueishtml="0"  name=cd_ss_reg_cou_t visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=2 alignment="0" tabsequence=10 border="0" color="0" x="9" y="8" height="76" width="297" format="[general]" html.valueishtml="0"  name=civilite visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=3 alignment="0" tabsequence=20 border="0" color="0" x="315" y="12" height="76" width="229" format="[general]" html.valueishtml="0"  name=nom visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=4 alignment="0" tabsequence=30 border="0" color="0" x="553" y="8" height="76" width="256" format="[general]" html.valueishtml="0"  name=prenom visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=5 alignment="0" tabsequence=40 border="0" color="0" x="818" y="8" height="76" width="293" format="[general]" html.valueishtml="0"  name=rue visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=6 alignment="0" tabsequence=50 border="0" color="0" x="1120" y="8" height="76" width="334" format="[general]" html.valueishtml="0"  name=batiment visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=7 alignment="0" tabsequence=60 border="0" color="0" x="1463" y="8" height="76" width="416" format="[general]" html.valueishtml="0"  name=complement visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=8 alignment="0" tabsequence=70 border="0" color="0" x="1888" y="8" height="76" width="352" format="[general]" html.valueishtml="0"  name=code_postal visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=9 alignment="0" tabsequence=80 border="0" color="0" x="2249" y="8" height="76" width="151" format="[general]" html.valueishtml="0"  name=ville visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=10 alignment="0" tabsequence=90 border="0" color="0" x="2409" y="8" height="76" width="210" format="[general]" html.valueishtml="0"  name=pays visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=24 alignment="0" tabsequence=120 border="0" color="0" x="3982" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r01 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=25 alignment="0" tabsequence=130 border="0" color="0" x="4096" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r02 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=26 alignment="0" tabsequence=140 border="0" color="0" x="4210" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r03 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=27 alignment="0" tabsequence=150 border="0" color="0" x="4325" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r04 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=28 alignment="0" tabsequence=160 border="0" color="0" x="4439" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r05 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=29 alignment="0" tabsequence=170 border="0" color="0" x="4553" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r06 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=30 alignment="0" tabsequence=180 border="0" color="0" x="4667" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r07 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=31 alignment="0" tabsequence=190 border="0" color="0" x="4782" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r08 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=32 alignment="0" tabsequence=200 border="0" color="0" x="4896" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r09 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=33 alignment="0" tabsequence=210 border="0" color="0" x="5010" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r10 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=34 alignment="0" tabsequence=220 border="0" color="0" x="5125" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r11 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=35 alignment="0" tabsequence=230 border="0" color="0" x="5239" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r12 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=36 alignment="0" tabsequence=240 border="0" color="0" x="5353" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r13 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=37 alignment="0" tabsequence=250 border="0" color="0" x="5467" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r14 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=38 alignment="0" tabsequence=260 border="0" color="0" x="5582" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r15 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=39 alignment="0" tabsequence=270 border="0" color="0" x="5696" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r16 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=40 alignment="0" tabsequence=280 border="0" color="0" x="5810" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r17 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=41 alignment="0" tabsequence=290 border="0" color="0" x="5925" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r18 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=42 alignment="0" tabsequence=300 border="0" color="0" x="6039" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r19 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=43 alignment="0" tabsequence=310 border="0" color="0" x="6153" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r20 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=44 alignment="0" tabsequence=320 border="0" color="0" x="6267" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r21 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=45 alignment="0" tabsequence=330 border="0" color="0" x="6382" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r22 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=46 alignment="0" tabsequence=340 border="0" color="0" x="6496" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r23 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=47 alignment="0" tabsequence=350 border="0" color="0" x="6610" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r24 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=48 alignment="0" tabsequence=360 border="0" color="0" x="6725" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r25 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=49 alignment="0" tabsequence=370 border="0" color="0" x="6839" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r26 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=50 alignment="0" tabsequence=380 border="0" color="0" x="6953" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r27 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=51 alignment="0" tabsequence=390 border="0" color="0" x="7067" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r28 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=52 alignment="0" tabsequence=400 border="0" color="0" x="7182" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r29 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=53 alignment="0" tabsequence=410 border="0" color="0" x="7296" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r30 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=54 alignment="0" tabsequence=420 border="0" color="0" x="7410" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r31 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=55 alignment="0" tabsequence=430 border="0" color="0" x="7525" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r32 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=56 alignment="0" tabsequence=440 border="0" color="0" x="7639" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r33 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=57 alignment="0" tabsequence=450 border="0" color="0" x="7753" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r34 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=58 alignment="0" tabsequence=460 border="0" color="0" x="7867" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r35 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=59 alignment="0" tabsequence=470 border="0" color="0" x="7982" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r36 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=60 alignment="0" tabsequence=480 border="0" color="0" x="8096" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r37 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=61 alignment="0" tabsequence=490 border="0" color="0" x="8210" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r38 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=62 alignment="0" tabsequence=500 border="0" color="0" x="8325" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r39 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=63 alignment="0" tabsequence=510 border="0" color="0" x="8439" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r40 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=64 alignment="0" tabsequence=520 border="0" color="0" x="8553" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r41 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=65 alignment="0" tabsequence=530 border="0" color="0" x="8667" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r42 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=66 alignment="0" tabsequence=540 border="0" color="0" x="8782" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r43 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=67 alignment="0" tabsequence=550 border="0" color="0" x="8896" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r44 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=68 alignment="0" tabsequence=560 border="0" color="0" x="9010" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r45 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=69 alignment="0" tabsequence=570 border="0" color="0" x="9125" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r46 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=70 alignment="0" tabsequence=580 border="0" color="0" x="9239" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r47 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=71 alignment="0" tabsequence=590 border="0" color="0" x="9353" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r48 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=72 alignment="0" tabsequence=600 border="0" color="0" x="9467" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r49 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=15 alignment="1" tabsequence=100 border="0" color="0" x="2629" y="8" height="76" width="251" format="[general]" html.valueishtml="0"  name=actions_ago visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=16 alignment="1" tabsequence=110 border="0" color="0" x="2889" y="8" height="76" width="215" format="[general]" html.valueishtml="0"  name=voix_ago visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=17 alignment="0" tabsequence=32766 border="0" color="0" x="3113" y="16" height="64" width="425" format="[general]" html.valueishtml="0"  name=actions_age visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=18 alignment="0" tabsequence=32766 border="0" color="0" x="3547" y="20" height="64" width="425" format="[general]" html.valueishtml="0"  name=voix_age visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=73 alignment="0" tabsequence=610 border="0" color="0" x="9582" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r50 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=12 alignment="0" tabsequence=32766 border="0" color="0" x="9696" y="8" height="76" width="247" format="[general]" html.valueishtml="0"  name=intermediaire visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=14 alignment="0" tabsequence=32766 border="0" color="0" x="9952" y="8" height="76" width="791" format="[general]" html.valueishtml="0"  name=origine visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=11 alignment="0" tabsequence=32766 border="0" color="0" x="10752" y="8" height="76" width="247" format="[general]" html.valueishtml="0"  name=ccn visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=13 alignment="0" tabsequence=32766 border="0" color="0" x="11008" y="8" height="76" width="311" format="[general]" html.valueishtml="0"  name=type visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=1 alignment="0" tabsequence=32766 border="0" color="0" x="11328" y="8" height="76" width="247" format="[general]" html.valueishtml="0"  name=id_actnaire visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=20 alignment="0" tabsequence=620 border="0" color="0" x="11584" y="8" height="64" width="855" format="[general]" html.valueishtml="0"  name=ref_societe visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=21 alignment="0" tabsequence=630 border="0" color="0" x="12448" y="8" height="64" width="2693" format="[general]" html.valueishtml="0"  name=ref_salarie visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=22 alignment="0" tabsequence=640 border="0" color="0" x="15150" y="8" height="64" width="128" format="[general]" html.valueishtml="0"  name=cd_reg_cou visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=23 alignment="0" tabsequence=650 border="0" color="0" x="15287" y="8" height="64" width="128" format="[general]" html.valueishtml="0"  name=cd_ss_reg_cou visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
compute(band=trailer.1 alignment="1" expression="sum(actions_ago for group 1)"border="0" color="0" x="2629" y="4" height="64" width="251" format="[general]" html.valueishtml="0"  name=co_nb_1 visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
compute(band=trailer.1 alignment="1" expression="sum(voix_ago for group 1)"border="0" color="0" x="2889" y="4" height="64" width="215" format="[general]" html.valueishtml="0"  name=co_nb_2 visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
compute(band=trailer.1 alignment="0" expression="sum(actions_age for group 1)"border="0" color="0" x="3113" y="4" height="64" width="425" format="[general]" html.valueishtml="0"  name=co_nb_3 visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
compute(band=trailer.1 alignment="0" expression="sum(voix_age for group 1)"border="0" color="0" x="3547" y="4" height="64" width="425" format="[general]" html.valueishtml="0"  name=co_nb_4 visible="1"  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
htmltable(border="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )

Hors ligne

 

#13 29-09-2006 08:33:23

pick ouic  
La bourse ou la vie ^^
Award: gearotter
Lieu: Massy-Verrières
Date d'inscription: 29-05-2006
Messages: 4658
Pépites: 942
Banque: 2,147,483,647
Site web

Re: [RESOLU] Executer une requete SQL

hoooo le tueur !!!!!!!!

je regarde ca de suite.
et pour la datastore cible ?

Connaitre son ignorance est une grande part de la connaissance.
http://animegifs.free.fr/anime/mazinger/mazinger.gif

Hors ligne

 

#14 29-09-2006 08:36:00

Deedoo2000  
Membre Geek
Date d'inscription: 13-09-2006
Messages: 91
Pépites: 408
Banque: 0

Re: [RESOLU] Executer une requete SQL

voila la dw cible :

Code: pb

$PBExportHeader$d_analyse.srd
release 9;
datawindow(units=0 timer_interval=0 color=1073741824 processing=1 HTMLDW=no print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes hidegrayline=no grid.lines=0 )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=92 color="536870912" )
table(column=(type=decimal(0) updatewhereclause=yes key=yes name=id_actnaire dbname="ANALYSE.ID_ACTNAIRE" )
 column=(type=char(50) update=yes updatewhereclause=yes key=yes name=libelle dbname="ANALYSE.LIBELLE" )
 column=(type=char(50) update=yes updatewhereclause=yes key=yes name=nom dbname="ANALYSE.NOM" )
 column=(type=char(50) update=yes updatewhereclause=yes key=yes name=prenom dbname="ANALYSE.PRENOM" )
 column=(type=char(50) update=yes updatewhereclause=yes key=yes name=rue dbname="ANALYSE.RUE" )
 column=(type=char(50) update=yes updatewhereclause=yes key=yes name=batiment dbname="ANALYSE.BATIMENT" )
 column=(type=char(50) update=yes updatewhereclause=yes key=yes name=complement dbname="ANALYSE.COMPLEMENT" )
 column=(type=char(50) update=yes updatewhereclause=yes key=yes name=code_postal dbname="ANALYSE.CODE_POSTAL" )
 column=(type=char(50) update=yes updatewhereclause=yes key=yes name=ville dbname="ANALYSE.VILLE" )
 column=(type=char(50) update=yes updatewhereclause=yes key=yes name=pays dbname="ANALYSE.PAYS" )
 column=(type=decimal(0) updatewhereclause=yes key=yes name=id_nominatif dbname="ANALYSE.ID_NOMINATIF" )
 column=(type=decimal(0) updatewhereclause=yes key=yes name=intermediaire dbname="ANALYSE.INTERMEDIAIRE" )
 column=(type=char(3) updatewhereclause=yes key=yes name=type dbname="ANALYSE.TYPE" )
 column=(type=char(50) updatewhereclause=yes key=yes name=origine dbname="ANALYSE.ORIGINE" )
 column=(type=decimal(0) update=yes updatewhereclause=yes key=yes name=actions dbname="ANALYSE.ACTIONS" )
 column=(type=decimal(0) update=yes updatewhereclause=yes key=yes name=voix dbname="ANALYSE.VOIX" )
 column=(type=decimal(0) update=yes updatewhereclause=yes key=yes name=actions_age dbname="ANALYSE.ACTIONS_AGE" )
 column=(type=decimal(0) update=yes updatewhereclause=yes key=yes name=voix_age dbname="ANALYSE.VOIX_AGE" )
 column=(type=char(3) updatewhereclause=yes key=yes name=nouv_res dbname="ANALYSE.NOUV_RES" )
 column=(type=char(32) updatewhereclause=yes key=yes name=ref_societe dbname="ANALYSE.REF_SOCIETE" )
 column=(type=char(100) updatewhereclause=yes key=yes name=ref_salarie dbname="ANALYSE.REF_SALARIE" )
 column=(type=char(5) updatewhereclause=yes key=yes name=cd_reg_cou dbname="ANALYSE.CD_REG_COU" )
 column=(type=char(5) updatewhereclause=yes key=yes name=cd_ss_reg_cou dbname="ANALYSE.CD_SS_REG_COU" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r1 dbname="ANALYSE.R1" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r2 dbname="ANALYSE.R2" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r3 dbname="ANALYSE.R3" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r4 dbname="ANALYSE.R4" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r5 dbname="ANALYSE.R5" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r6 dbname="ANALYSE.R6" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r7 dbname="ANALYSE.R7" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r8 dbname="ANALYSE.R8" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r9 dbname="ANALYSE.R9" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r10 dbname="ANALYSE.R10" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r11 dbname="ANALYSE.R11" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r12 dbname="ANALYSE.R12" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r13 dbname="ANALYSE.R13" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r14 dbname="ANALYSE.R14" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r15 dbname="ANALYSE.R15" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r16 dbname="ANALYSE.R16" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r17 dbname="ANALYSE.R17" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r18 dbname="ANALYSE.R18" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r19 dbname="ANALYSE.R19" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r20 dbname="ANALYSE.R20" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r21 dbname="ANALYSE.R21" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r22 dbname="ANALYSE.R22" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r23 dbname="ANALYSE.R23" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r24 dbname="ANALYSE.R24" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r25 dbname="ANALYSE.R25" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r26 dbname="ANALYSE.R26" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r27 dbname="ANALYSE.R27" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r28 dbname="ANALYSE.R28" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r29 dbname="ANALYSE.R29" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r30 dbname="ANALYSE.R30" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r31 dbname="ANALYSE.R31" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r32 dbname="ANALYSE.R32" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r33 dbname="ANALYSE.R33" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r34 dbname="ANALYSE.R34" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r35 dbname="ANALYSE.R35" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r36 dbname="ANALYSE.R36" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r37 dbname="ANALYSE.R37" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r38 dbname="ANALYSE.R38" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r39 dbname="ANALYSE.R39" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r40 dbname="ANALYSE.R40" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r41 dbname="ANALYSE.R41" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r42 dbname="ANALYSE.R42" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r43 dbname="ANALYSE.R43" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r44 dbname="ANALYSE.R44" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r45 dbname="ANALYSE.R45" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r46 dbname="ANALYSE.R46" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r47 dbname="ANALYSE.R47" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r48 dbname="ANALYSE.R48" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r49 dbname="ANALYSE.R49" )
 column=(type=char(1) update=yes updatewhereclause=yes key=yes name=r50 dbname="ANALYSE.R50" )
 retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"ANALYSE~" ) COLUMN(NAME=~"ANALYSE.ID_ACTNAIRE~") COLUMN(NAME=~"ANALYSE.LIBELLE~") COLUMN(NAME=~"ANALYSE.NOM~") COLUMN(NAME=~"ANALYSE.PRENOM~") COLUMN(NAME=~"ANALYSE.RUE~") COLUMN(NAME=~"ANALYSE.BATIMENT~") COLUMN(NAME=~"ANALYSE.COMPLEMENT~") COLUMN(NAME=~"ANALYSE.CODE_POSTAL~") COLUMN(NAME=~"ANALYSE.VILLE~") COLUMN(NAME=~"ANALYSE.PAYS~") COLUMN(NAME=~"ANALYSE.ID_NOMINATIF~") COLUMN(NAME=~"ANALYSE.INTERMEDIAIRE~") COLUMN(NAME=~"ANALYSE.TYPE~") COLUMN(NAME=~"ANALYSE.ORIGINE~") COLUMN(NAME=~"ANALYSE.ACTIONS~") COLUMN(NAME=~"ANALYSE.VOIX~") COLUMN(NAME=~"ANALYSE.ACTIONS_AGE~") COLUMN(NAME=~"ANALYSE.VOIX_AGE~") COLUMN(NAME=~"ANALYSE.NOUV_RES~") COLUMN(NAME=~"ANALYSE.REF_SOCIETE~") COLUMN(NAME=~"ANALYSE.REF_SALARIE~") COLUMN(NAME=~"ANALYSE.CD_REG_COU~") COLUMN(NAME=~"ANALYSE.CD_SS_REG_COU~") COLUMN(NAME=~"ANALYSE.R1~") COLUMN(NAME=~"ANALYSE.R2~") COLUMN(NAME=~"ANALYSE.R3~") COLUMN(NAME=~"ANALYSE.R4~") COLUMN(NAME=~"ANALYSE.R5~") COLUMN(NAME=~"ANALYSE.R6~") COLUMN(NAME=~"ANALYSE.R7~") COLUMN(NAME=~"ANALYSE.R8~") COLUMN(NAME=~"ANALYSE.R9~") COLUMN(NAME=~"ANALYSE.R10~") COLUMN(NAME=~"ANALYSE.R11~") COLUMN(NAME=~"ANALYSE.R12~") COLUMN(NAME=~"ANALYSE.R13~") COLUMN(NAME=~"ANALYSE.R14~") COLUMN(NAME=~"ANALYSE.R15~") COLUMN(NAME=~"ANALYSE.R16~") COLUMN(NAME=~"ANALYSE.R17~") COLUMN(NAME=~"ANALYSE.R18~") COLUMN(NAME=~"ANALYSE.R19~") COLUMN(NAME=~"ANALYSE.R20~") COLUMN(NAME=~"ANALYSE.R21~") COLUMN(NAME=~"ANALYSE.R22~") COLUMN(NAME=~"ANALYSE.R23~") COLUMN(NAME=~"ANALYSE.R24~") COLUMN(NAME=~"ANALYSE.R25~") COLUMN(NAME=~"ANALYSE.R26~") COLUMN(NAME=~"ANALYSE.R27~") COLUMN(NAME=~"ANALYSE.R28~") COLUMN(NAME=~"ANALYSE.R29~") COLUMN(NAME=~"ANALYSE.R30~") COLUMN(NAME=~"ANALYSE.R31~") COLUMN(NAME=~"ANALYSE.R32~") COLUMN(NAME=~"ANALYSE.R33~") COLUMN(NAME=~"ANALYSE.R34~") COLUMN(NAME=~"ANALYSE.R35~") COLUMN(NAME=~"ANALYSE.R36~") COLUMN(NAME=~"ANALYSE.R37~") COLUMN(NAME=~"ANALYSE.R38~") COLUMN(NAME=~"ANALYSE.R39~") COLUMN(NAME=~"ANALYSE.R40~") COLUMN(NAME=~"ANALYSE.R41~") COLUMN(NAME=~"ANALYSE.R42~") COLUMN(NAME=~"ANALYSE.R43~") COLUMN(NAME=~"ANALYSE.R44~") COLUMN(NAME=~"ANALYSE.R45~") COLUMN(NAME=~"ANALYSE.R46~") COLUMN(NAME=~"ANALYSE.R47~") COLUMN(NAME=~"ANALYSE.R48~") COLUMN(NAME=~"ANALYSE.R49~") COLUMN(NAME=~"ANALYSE.R50~")) " update="ANALYSE" updatewhere=0 updatekeyinplace=no )
column(band=detail id=2 alignment="0" tabsequence=10 border="0" color="33554432" x="9" y="8" height="76" width="1399" format="[general]" html.valueishtml="0"  name=libelle visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=3 alignment="0" tabsequence=20 border="0" color="33554432" x="1417" y="8" height="76" width="1399" format="[general]" html.valueishtml="0"  name=nom visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=4 alignment="0" tabsequence=30 border="0" color="33554432" x="2825" y="8" height="76" width="1399" format="[general]" html.valueishtml="0"  name=prenom visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=5 alignment="0" tabsequence=40 border="0" color="33554432" x="4233" y="8" height="76" width="1399" format="[general]" html.valueishtml="0"  name=rue visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=6 alignment="0" tabsequence=50 border="0" color="33554432" x="5641" y="8" height="76" width="1399" format="[general]" html.valueishtml="0"  name=batiment visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=7 alignment="0" tabsequence=60 border="0" color="33554432" x="7049" y="8" height="76" width="1399" format="[general]" html.valueishtml="0"  name=complement visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=8 alignment="0" tabsequence=70 border="0" color="33554432" x="8457" y="8" height="76" width="1399" format="[general]" html.valueishtml="0"  name=code_postal visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=9 alignment="0" tabsequence=80 border="0" color="33554432" x="9865" y="8" height="76" width="1399" format="[general]" html.valueishtml="0"  name=ville visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=10 alignment="0" tabsequence=90 border="0" color="33554432" x="11273" y="8" height="76" width="1399" format="[general]" html.valueishtml="0"  name=pays visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=15 alignment="1" tabsequence=100 border="0" color="33554432" x="12681" y="8" height="76" width="329" format="[general]" html.valueishtml="0"  name=actions visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=16 alignment="1" tabsequence=110 border="0" color="33554432" x="13019" y="8" height="76" width="329" format="[general]" html.valueishtml="0"  name=voix visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=17 alignment="1" tabsequence=120 border="0" color="33554432" x="13358" y="8" height="76" width="329" format="[general]" html.valueishtml="0"  name=actions_age visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=18 alignment="1" tabsequence=130 border="0" color="33554432" x="13696" y="8" height="76" width="329" format="[general]" html.valueishtml="0"  name=voix_age visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=24 alignment="0" tabsequence=140 border="0" color="33554432" x="14034" y="8" height="76" width="73" format="[general]" html.valueishtml="0"  name=r1 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=25 alignment="0" tabsequence=150 border="0" color="33554432" x="14117" y="8" height="76" width="73" format="[general]" html.valueishtml="0"  name=r2 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=26 alignment="0" tabsequence=160 border="0" color="33554432" x="14199" y="8" height="76" width="73" format="[general]" html.valueishtml="0"  name=r3 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=27 alignment="0" tabsequence=170 border="0" color="33554432" x="14281" y="8" height="76" width="73" format="[general]" html.valueishtml="0"  name=r4 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=28 alignment="0" tabsequence=180 border="0" color="33554432" x="14363" y="8" height="76" width="73" format="[general]" html.valueishtml="0"  name=r5 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=29 alignment="0" tabsequence=190 border="0" color="33554432" x="14446" y="8" height="76" width="73" format="[general]" html.valueishtml="0"  name=r6 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=30 alignment="0" tabsequence=200 border="0" color="33554432" x="14528" y="8" height="76" width="73" format="[general]" html.valueishtml="0"  name=r7 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=31 alignment="0" tabsequence=210 border="0" color="33554432" x="14610" y="8" height="76" width="73" format="[general]" html.valueishtml="0"  name=r8 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=32 alignment="0" tabsequence=220 border="0" color="33554432" x="14693" y="8" height="76" width="73" format="[general]" html.valueishtml="0"  name=r9 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=33 alignment="0" tabsequence=230 border="0" color="33554432" x="14775" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r10 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=34 alignment="0" tabsequence=240 border="0" color="33554432" x="14889" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r11 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=35 alignment="0" tabsequence=250 border="0" color="33554432" x="15003" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r12 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=36 alignment="0" tabsequence=260 border="0" color="33554432" x="15118" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r13 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=37 alignment="0" tabsequence=270 border="0" color="33554432" x="15232" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r14 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=38 alignment="0" tabsequence=280 border="0" color="33554432" x="15346" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r15 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=39 alignment="0" tabsequence=290 border="0" color="33554432" x="15461" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r16 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=40 alignment="0" tabsequence=300 border="0" color="33554432" x="15575" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r17 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=41 alignment="0" tabsequence=310 border="0" color="33554432" x="15689" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r18 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=42 alignment="0" tabsequence=320 border="0" color="33554432" x="15803" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r19 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=43 alignment="0" tabsequence=330 border="0" color="33554432" x="15918" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r20 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=44 alignment="0" tabsequence=340 border="0" color="33554432" x="16032" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r21 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=45 alignment="0" tabsequence=350 border="0" color="33554432" x="16146" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r22 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=46 alignment="0" tabsequence=360 border="0" color="33554432" x="16261" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r23 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=47 alignment="0" tabsequence=370 border="0" color="33554432" x="16375" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r24 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=48 alignment="0" tabsequence=380 border="0" color="33554432" x="16489" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r25 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=49 alignment="0" tabsequence=390 border="0" color="33554432" x="16603" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r26 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=50 alignment="0" tabsequence=400 border="0" color="33554432" x="16718" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r27 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=51 alignment="0" tabsequence=410 border="0" color="33554432" x="16832" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r28 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=52 alignment="0" tabsequence=420 border="0" color="33554432" x="16946" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r29 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=53 alignment="0" tabsequence=430 border="0" color="33554432" x="17061" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r30 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=54 alignment="0" tabsequence=440 border="0" color="33554432" x="17175" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r31 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=55 alignment="0" tabsequence=450 border="0" color="33554432" x="17289" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r32 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=56 alignment="0" tabsequence=460 border="0" color="33554432" x="17403" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r33 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=57 alignment="0" tabsequence=470 border="0" color="33554432" x="17518" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r34 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=58 alignment="0" tabsequence=480 border="0" color="33554432" x="17632" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r35 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=59 alignment="0" tabsequence=490 border="0" color="33554432" x="17746" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r36 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=60 alignment="0" tabsequence=500 border="0" color="33554432" x="17861" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r37 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=61 alignment="0" tabsequence=510 border="0" color="33554432" x="17975" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r38 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=62 alignment="0" tabsequence=520 border="0" color="33554432" x="18089" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r39 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=63 alignment="0" tabsequence=530 border="0" color="33554432" x="18203" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r40 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=64 alignment="0" tabsequence=540 border="0" color="33554432" x="18318" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r41 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=65 alignment="0" tabsequence=550 border="0" color="33554432" x="18432" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r42 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=66 alignment="0" tabsequence=560 border="0" color="33554432" x="18546" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r43 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=67 alignment="0" tabsequence=570 border="0" color="33554432" x="18661" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r44 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=68 alignment="0" tabsequence=580 border="0" color="33554432" x="18775" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r45 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=69 alignment="0" tabsequence=590 border="0" color="33554432" x="18889" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r46 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=70 alignment="0" tabsequence=600 border="0" color="33554432" x="19003" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r47 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=71 alignment="0" tabsequence=610 border="0" color="33554432" x="19118" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r48 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=72 alignment="0" tabsequence=620 border="0" color="33554432" x="19232" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r49 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=73 alignment="0" tabsequence=630 border="0" color="33554432" x="19346" y="8" height="76" width="105" format="[general]" html.valueishtml="0"  name=r50 visible="1" edit.limit=1 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=1 alignment="0" tabsequence=640 border="0" color="33554432" x="19461" y="0" height="64" width="1152" format="[general]" html.valueishtml="0"  name=id_actnaire visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=19 alignment="0" tabsequence=650 border="0" color="33554432" x="20622" y="0" height="64" width="73" format="[general]" html.valueishtml="0"  name=nouv_res visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=20 alignment="0" tabsequence=660 border="0" color="33554432" x="20704" y="0" height="64" width="855" format="[general]" html.valueishtml="0"  name=ref_societe visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=21 alignment="0" tabsequence=670 border="0" color="33554432" x="21568" y="0" height="64" width="2693" format="[general]" html.valueishtml="0"  name=ref_salarie visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=22 alignment="0" tabsequence=680 border="0" color="33554432" x="24270" y="0" height="64" width="128" format="[general]" html.valueishtml="0"  name=cd_reg_cou visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=23 alignment="0" tabsequence=690 border="0" color="33554432" x="24407" y="0" height="64" width="128" format="[general]" html.valueishtml="0"  name=cd_ss_reg_cou visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=11 alignment="0" tabsequence=700 border="0" color="33554432" x="24544" y="0" height="64" width="1152" format="[general]" html.valueishtml="0"  name=id_nominatif visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=12 alignment="0" tabsequence=710 border="0" color="33554432" x="25705" y="0" height="64" width="1152" format="[general]" html.valueishtml="0"  name=intermediaire visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=13 alignment="0" tabsequence=720 border="0" color="33554432" x="26866" y="0" height="64" width="73" format="[general]" html.valueishtml="0"  name=type visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=14 alignment="0" tabsequence=730 border="0" color="33554432" x="26949" y="0" height="64" width="1339" format="[general]" html.valueishtml="0"  name=origine visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="Arial" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
htmltable(border="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )

cette datawindox a donc été construite en QuickSelect sur la table ANALYSE comme tu pourras le constater.

Hors ligne

 

#15 29-09-2006 08:38:48

Deedoo2000  
Membre Geek
Date d'inscription: 13-09-2006
Messages: 91
Pépites: 408
Banque: 0

Re: [RESOLU] Executer une requete SQL

En fait le plus simple serait que tu me dises comment tu ferais, pas à pas, pour transférer le contenu de dw_1 dans une table sybase. En détaillant les étapes de création des différents objets utilisés...

Hors ligne

 

#16 29-09-2006 08:58:43

pick ouic  
La bourse ou la vie ^^
Award: gearotter
Lieu: Massy-Verrières
Date d'inscription: 29-05-2006
Messages: 4658
Pépites: 942
Banque: 2,147,483,647
Site web

Re: [RESOLU] Executer une requete SQL

je regarde ca
je te donne une reponse debut apres midi.

Connaitre son ignorance est une grande part de la connaissance.
http://animegifs.free.fr/anime/mazinger/mazinger.gif

Hors ligne

 

#17 29-09-2006 08:59:03

Deedoo2000  
Membre Geek
Date d'inscription: 13-09-2006
Messages: 91
Pépites: 408
Banque: 0

Re: [RESOLU] Executer une requete SQL

pick ouic a écrit:

je regarde ca
je te donne une reponse debut apres midi.

ok merci

Hors ligne

 

#18 29-09-2006 09:03:59

pick ouic  
La bourse ou la vie ^^
Award: gearotter
Lieu: Massy-Verrières
Date d'inscription: 29-05-2006
Messages: 4658
Pépites: 942
Banque: 2,147,483,647
Site web

Re: [RESOLU] Executer une requete SQL

il y a une difference entre les 2 datawindows !!!!!!!!

regarde bien, au niveau des formats !

colonne 3
colonne 12
colonne 13
colonne 14


d_export_vote_pc_file_agm :

colonne 3     nom (64)
colonne 12   intermediaire(50)
colonne 13   type(10)
colonne 14   origine(25)

d_analyse :

colonne 3     nom (50)
colonne 12   intermediaire(decimal !)
colonne 13   type(3)
colonne 14   origine(50)

Connaitre son ignorance est une grande part de la connaissance.
http://animegifs.free.fr/anime/mazinger/mazinger.gif

Hors ligne

 

#19 29-09-2006 09:17:43

Deedoo2000  
Membre Geek
Date d'inscription: 13-09-2006
Messages: 91
Pépites: 408
Banque: 0

Re: [RESOLU] Executer une requete SQL

oups, je vais corriger ça et voir ce que ça donne.
par contre autre question : pour faire l'update en supposant que le rowscopy fonctionne bien : je suis allé dans update properties de dw_2, j'ai coché allow update en spécifiant la table (comme tu peux le constater d'après mon export) et j'ai aussi assigné un numéro à chacune de mes colonnes pour qu'elles soit updatable.
et ensuite je fais un lds_2.update()

Est-ce correct ?

Hors ligne

 

#20 29-09-2006 09:21:45

pick ouic  
La bourse ou la vie ^^
Award: gearotter
Lieu: Massy-Verrières
Date d'inscription: 29-05-2006
Messages: 4658
Pépites: 942
Banque: 2,147,483,647
Site web

Re: [RESOLU] Executer une requete SQL

oui tout devrait marcher.
maintenant, faut voir si ce sont des INSERT ou des Updates...

j'ai pas fait le test du rowscopy, mais ca devrait mieux fonctionner maintenant

Connaitre son ignorance est une grande part de la connaissance.
http://animegifs.free.fr/anime/mazinger/mazinger.gif

Hors ligne

 

#21 29-09-2006 09:32:52

Deedoo2000  
Membre Geek
Date d'inscription: 13-09-2006
Messages: 91
Pépites: 408
Banque: 0

Re: [RESOLU] Executer une requete SQL

pick ouic a écrit:

oui tout devrait marcher.
maintenant, faut voir si ce sont des INSERT ou des Updates...

j'ai pas fait le test du rowscopy, mais ca devrait mieux fonctionner maintenant

Ca marche !
Merci beaucoup pour ton aide, je te paye un coup à boire virtuel

Hors ligne

 

#22 29-09-2006 09:36:07

pick ouic  
La bourse ou la vie ^^
Award: gearotter
Lieu: Massy-Verrières
Date d'inscription: 29-05-2006
Messages: 4658
Pépites: 942
Banque: 2,147,483,647
Site web

Re: [RESOLU] Executer une requete SQL

quoi, seulement virtuel ?
maissss c'est pas juste caaaaaaaaa !!!!

hi hi hi, ok, no problemo !
finalement, tout fonctionne !

Connaitre son ignorance est une grande part de la connaissance.
http://animegifs.free.fr/anime/mazinger/mazinger.gif

Hors ligne

 

 

Pages: 1

Pied de page des forums

Propulsé par FluxBB 1.2.22