{

//Insert the code starting here

char NOM[40];

long NbPieces;

long MyID;

char MyFilter[3];

BOOL isRecord;

UAHCONNECT hConnect;

UAHARCHIVE hArchive;

//Get RecipeID from tag

MyID = GetTagWord("GestionEtatmagasin_DB_IHM_Maj_Cellule.Cellule.Code");

//Build a filter, related to recipe ID

sprintf(MyFilter, "ID=%d", MyID) ;

//Connect to user archives

if(uaConnect(&hConnect)==TRUE)

{

//Get recipe handle

if(uaQueryArchiveByName(hConnect,"Recette", &hArchive)==TRUE)

{

//Open recipe

if(uaArchiveOpen(hArchive)==TRUE)

{

//Sets the Filter to the RecipeID

if (uaArchiveSetFilter(hArchive,MyFilter)==FALSE)

printf("Error calling uaArchiveSetFilter: %d / %08lx\r\n", uaGetLastError(), uaGetLastHResult());

//Call uaArchiveRequery after uaArchiveSetFilter or uaArchiveSetSort is mandatory (To reload the Recipe

if (uaArchiveRequery(hArchive)==FALSE)

printf("Error calling uaArchiveRequery: %d / %08lx\r\n", uaGetLastError(), uaGetLastHResult());

//Move to record 1

if((isRecord=uaArchiveMoveFirst(hArchive))==FALSE)

printf("Error calling uaArchiveMoveFirst: %d / %08lx\r\n", uaGetLastError(), uaGetLastHResult());

//Loop through all records

else

while (isRecord)

{

//Read fieldvalue from column 19(Nombre de pièces)

if(uaArchiveGetFieldValueLong(hArchive,19,&NbPieces)==FALSE)

printf("Error calling uaArchiveGetFieldValueLong: %d / %08lx\r\n", uaGetLastError(), uaGetLastHResult());

//Read filed value from column 1(Nom produit)

if(uaArchiveGetFieldValueString( hArchive, 1, NOM ,40)==FALSE)

printf("Error calling uaArchiveGetFieldValueString: %d / %08lx\r\n", uaGetLastError(), uaGetLastHResult());

//Affect script internal values to HMI internal values

SetTagDWord("Recipe_NB_P", NbPieces);

SetTagChar("Recipe_Nom", NOM);

isRecord = uaArchiveMoveNext(hArchive);

}

//Close the recipe

if(uaArchiveClose(hArchive)==FALSE)

printf("Error calling uaArchiveClose: %d / %08lx\r\n", uaGetLastError(), uaGetLastHResult());

}

else

printf("Error calling uaArchiveOpen: %d / %08lx\r\n", uaGetLastError(), uaGetLastHResult());

//Release recipe handle

if(uaReleaseArchive(hArchive)==FALSE)

printf("Error calling uaReleaseArchive: %d / %08lx\r\n", uaGetLastError(), uaGetLastHResult());

}

else

printf("Error calling uaQueryArchiveByName: %d / %08lx\r\n", uaGetLastError(), uaGetLastHResult());

//Disconnect from user archives

if(uaDisconnect(hConnect)==FALSE)

printf("Error calling uaDisconnect: %d / %08lx\r\n", uaGetLastError(), uaGetLastHResult());

}

else

printf("Error calling uaConnect: %d / %08lx\r\n", uaGetLastError(), uaGetLastHResult());

}