Insert Multiple Lines For i Loop 1

[girky]

Hello

I'm trying to insert multiple lines into a table with variable called desc1, desc2, desc3...desc10. And I can't get the proper syntax. I've tried:

('" & desci "')
('" & desc(i) "')
('" "desc" & i & "')
('" & desc( & i & ) "') and a few others I think

Here's the code:
For i = 1 to 10
sql_add = sql_add & "INSERT INTO REQUEST_SUB(DESCRIPTION)"
sql_add = sql_add & "VALUES "
sql_add = sql_add & "('" & desc( & i & ) "');"
next


Any help is greatly appreciated. Thank you

 

[mwolf00]

Sounds like you need the EVAL() function....

For i = 1 to 10
sql_add = sql_add & "INSERT INTO REQUEST_SUB(DESCRIPTION)"
sql_add = sql_add & "VALUES "
sql_add = sql_add & "('" & EVAL("desc" & i) & "');"
next -----------------------------------------------------------------
DIM bulb
SET bulb = NEW brain

mikewolf@tst-us.com

 

[girky]

Works great. I learn something new everyday. Thanks so much