topic-17794

Posts: 811

Joined: Tue May 06, 2008 04:28 AM

Array content to ADS SQL statement
Posted: Fri Jan 08, 2010 08:47 AM

Hello All!

I need help.

I have this multiple element aArray variable

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

Kind Regards,

Frances

Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15

anserkk

Posts: 1335

Joined: Fri Jun 13, 2008 11:04 AM

Re: Array content to ADS SQL statement
Posted: Fri Jan 08, 2010 09:12 AM

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 (fw): Select all Collapse

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

Regards
Anser

fraxzi

Posts: 811

Joined: Tue May 06, 2008 04:28 AM

Re: Array content to ADS SQL statement
Posted: Sat Jan 09, 2010 12:44 AM

anserkk wrote:
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 (fw): Select all Collapse
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

Kind Regards,

Frances

Fivewin for xHarbour v18.07

xHarbour v1.2.3.x

BCC 7.3 + PellesC8 ( Resource Compiler only)

ADS 10.1 / MariaDB

Crystal Reports 8.5/9.23 DE

xMate v1.15

anserkk

Posts: 1335

Joined: Fri Jun 13, 2008 11:04 AM

Re: Array content to ADS SQL statement
Posted: Sat Jan 09, 2010 04:27 AM

Hi Mr.Frances,

Sorry, I am not familiar with the ADS.

Regards
Anser

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Array content to ADS SQL statement
Posted: Sat Jan 09, 2010 06:07 AM

Mr Anser

SQL statements are the same in ADS also

Regards

G. N. Rao.

Hyderabad, India

FiveTech Support Forums

Continue the discussion