Hello everyone,

>> I'm on WinCC RT Professional V16 Upd3

I have a problem while reading string into a SQL table and put it into a recipe UA

Here is the C-SCRIPT:

__object *objConnexionSQL;
__object *objRecordsetSQL;
UAHCONNECT objConnexionUA;
UAHARCHIVE objArchiveUA;
char Phrase[255], Requete[255];
char *Designation;

// Create SQL objects
objConnexionSQL=__object_create("ADODB.Connection");
objRecordsetSQL=__object_create("ADODB.Recordset");

// Conexion to SQL Server
sprintf(Phrase,"Provider=SQLOLEDB;Data Source= %s\\WINCC;Initial Catalog=%s;Trusted_connection=yes;",GetTagChar("@ServerName"),GetTagChar("NomBDD"));
objConnexionSQL->ConnectionString = Phrase;
objConnexionSQL->Open;

// SQL Request
sprintf(Requete,"SELECT Designation FROM dbo.OF_ID WHERE Flag_ExportERP=0");
objRecordsetSQL=objConnexionSQL->Execute(Requete);

// Traitement du résultat
while (!objRecordsetSQL->eof){

//Reading results
Designation=objRecordsetSQL->Fields(0)->Value;
printf("Designation: %s \r\n",Designation);

//Insert string into uaRecipe
uaConnect(&objConnexionUA);
printf("Designation: %s \r\n",Designation);

uaQueryArchiveByName(objConnexionUA,"Pup_CarteProd",&objArchiveUA);
printf("Designation: %s \r\n",Designation);

uaArchiveOpen(objArchiveUA);
uaArchiveSetFieldValueString(objArchiveUA,2,Designation);


// etc .....

 Have a look on the 3 printf() at the bottom, it returns:

Designation: My result
Designation: My result
Designation: #''(8|à£

The string value read from the SQL table and put into the variable 'Designation' is correct until the third line.

 It seems that the function uaQueryArchiveByName() overwrite the variable 'Designation' and I don't understand why.

 Have you any idea ?