Array content to ADS SQL statement

[fraxzi]

Hello All!

I need help.

I have this multiple element aArray variable

Code: Select all  Expand view

aArray := { {'element1', 'value1'},;
                 {'elemnet2', 'value2'} }
 

How can I iterate and translate this to ADS SQL statement to be able to update a table?



Best regards,
Fraxzi

[anserkk]

How can I iterate and translate this to ADS SQL statement to be able to update a table?

I am not sure whether I understood your requirement exactly

Assuming Element1, Element2 are the Column names of your Table

Update Query

Code: Select all  Expand view

cSql:="UPDATE Table_Name SET "
for i=1 to len(aArray)
    cSql+=aArray[i][1]+" = "+aArray[i][2]
Next

Regards
Anser

[fraxzi]

How can I iterate and translate this to ADS SQL statement to be able to update a table?

I am not sure whether I understood your requirement exactly

Assuming Element1, Element2 are the Column names of your Table

Update Query

Code: Select all  Expand view

cSql:="UPDATE Table_Name SET "
for i=1 to len(aArray)
    cSql+=aArray[i][1]+" = "+aArray[i][2]
Next

Regards
Anser

Hello Anser,

The array contains the field (column) or values.

Is there a better approach than iterating AdsExecuteSQLDirect() ?

Regards,
Fraxzi

[anserkk]

Hi Mr.Frances,

Sorry, I am not familiar with the ADS.

Regards
Anser

[nageswaragunupudi]

Mr Anser

SQL statements are the same in ADS also