For some reason when I attempt this I get and error. I've changed the result to an array and appending from that.

>Yes you can.
>
>selec * from mytable into cursor mycursor
>
>select table1
>
>append from mycursor

Jim Philippi

quando omni flunkus moritati