>Hello all,
>
>I have tried to use macro to set up SQL statment to use macro
>
for i = 1 to 10
SQL_Text = "INSERT INTO testtable( empno,Solde ) SELECT empno,solde" ;
+ LTRIM( STR( i ) ) ;
+ " from mytable"
next for
>
>always not worked on solde&i variable
>
>TIA for any help.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up