1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
|
<xmlgram name="InsertFONCTIONNAIRE">
<Assign Name="Params">
<Trace>
<BeforeInstruction/>
<BeforeInternalInstruction/>
<AfterInternalInstruction/>
<AfterInstruction/>
</Trace>
<Fields>
<Field>
<ID/>
<Destination>CONTEXT</Destination>
<Name>NextAction</Name>
<Source>CONTEXT</Source>
<SourceField>NextActionAfterInsertFct</SourceField>
<Value/>
</Field>
</Fields>
</Assign>
<GenID Name="GenNewID">
<Fields>
<Field>
<Name>ID_FCT</Name>
<Generator>GENERAL</Generator>
</Field>
</Fields>
</GenID>
<DBBatch Name="FONCTIONNAIRE">
<DataSource>yakaDB</DataSource>
<Params>
<Param>
<Name>ID_FCT</Name>
<Type>INTEGER</Type>
<Value>830</Value>
</Param>
<Param>
<Name>ID_ORG</Name>
<Type>INTEGER</Type>
<Value>832</Value>
</Param>
<Param>
<Name>ID_GRADE</Name>
<Type>INTEGER</Type>
<Value>831</Value>
</Param>
<Param>
<Name>NI_FCT</Name>
<Type>INTEGER</Type>
<Value>423784</Value>
</Param>
<Param>
<Name>NOM_FCT</Name>
<Type>VARCHAR</Type>
<Value>GALINAJTIS</Value>
</Param>
<Param>
<Name>NOMEP_FCT</Name>
<Type>VARCHAR</Type>
<Value/>
</Param>
<Param>
<Name>PRENOM_FCT</Name>
<Type>VARCHAR</Type>
<Value>LUCIEN</Value>
</Param>
<Param>
<Name>SEXE_FCT</Name>
<Type>VARCHAR</Type>
<Value>M</Value>
</Param>
</Params>
<Statement><![CDATA[INSERT INTO FONCTIONNAIRE (ID_FCT, ID_ORG, ID_GRADE, NI_FCT, NOM_FCT, NOMEP_FCT, PRENOM_FCT, SEXE_FCT)
VALUES (:ID_FCT, :ID_ORG, :ID_GRADE, :NI_FCT, :NOM_FCT, :NOMEP_FCT, :PRENOM_FCT, :SEXE_FCT)]]></Statement>
</DBBatch>
</xmlgram> |
Partager